> ## Documentation Index > Fetch the complete documentation index at: https://docs.ionworks.com/llms.txt > Use this file to discover all available pages before exploring further. # List projects for an organization > List projects for an organization with pagination, filtering, and sorting. Filter parameters support Supabase filter operators, per the field's declared policy: - Text fields (name, description): use ``ilike.%value%`` for partial match - Date fields: use ``gte.value``, ``lte.value``, etc. - Date range: use created_at_gt and created_at_lt for between queries There is no ``created_by_email`` filter: the projects table records no creator, so there is nothing to match against. ## OpenAPI ````yaml https://api.ionworks.com/openapi.json get /projects openapi: 3.1.0 info: title: FastAPI version: 0.1.0 servers: - url: https://api.ionworks.com description: Production security: [] paths: /projects: get: summary: List projects for an organization description: >- List projects for an organization with pagination, filtering, and sorting. Filter parameters support Supabase filter operators, per the field's declared policy: - Text fields (name, description): use ``ilike.%value%`` for partial match - Date fields: use ``gte.value``, ``lte.value``, etc. - Date range: use created_at_gt and created_at_lt for between queries There is no ``created_by_email`` filter: the projects table records no creator, so there is nothing to match against. operationId: list_projects_for_organization_endpoint_projects_get parameters: - name: limit in: query required: false schema: type: integer maximum: 100 minimum: 1 default: 100 title: Limit - name: offset in: query required: false schema: type: integer minimum: 0 title: Offset default: 0 - name: name in: query required: false schema: anyOf: - type: string - type: 'null' title: Name - name: description in: query required: false schema: anyOf: - type: string - type: 'null' title: Description - name: created_at in: query required: false schema: anyOf: - type: string - type: 'null' title: Created At - name: created_at_gt in: query required: false schema: anyOf: - type: string - type: 'null' title: Created At Gt - name: created_at_lt in: query required: false schema: anyOf: - type: string - type: 'null' title: Created At Lt - name: updated_at in: query required: false schema: anyOf: - type: string - type: 'null' title: Updated At - name: updated_at_gt in: query required: false schema: anyOf: - type: string - type: 'null' title: Updated At Gt - name: updated_at_lt in: query required: false schema: anyOf: - type: string - type: 'null' title: Updated At Lt - name: order_by in: query required: false schema: enum: - name - created_at - updated_at type: string default: created_at title: Order By - name: order in: query required: false schema: enum: - asc - desc type: string default: desc title: Order responses: '200': description: Successful Response content: application/json: schema: $ref: '#/components/schemas/PaginatedResponse_Project_' '422': description: Validation Error content: application/json: schema: $ref: '#/components/schemas/HTTPValidationError' components: schemas: PaginatedResponse_Project_: properties: items: items: $ref: '#/components/schemas/Project' type: array title: Items count: type: integer title: Count total: type: integer title: Total type: object required: - items - count - total title: PaginatedResponse[Project] HTTPValidationError: properties: detail: items: $ref: '#/components/schemas/ValidationError' type: array title: Detail type: object title: HTTPValidationError Project: properties: name: type: string title: Name description: The name of the project. description: anyOf: - type: string - type: 'null' title: Description description: An optional description for the project. id: type: string title: Id description: The unique identifier for the project. organization_id: type: string title: Organization Id description: The ID of the organization this project belongs to. created_at: type: string format: date-time title: Created At description: Timestamp of when the project was created. updated_at: type: string format: date-time title: Updated At description: Timestamp of when the project was last updated. created_by: anyOf: - type: string - type: 'null' title: Created By description: User ID of the creator. user_project_roles: anyOf: - items: $ref: '#/components/schemas/UserProjectRole' type: array - type: 'null' title: User Project Roles description: The user project roles in the project. type: object required: - name - id - organization_id - created_at - updated_at title: Project ValidationError: properties: loc: items: anyOf: - type: string - type: integer type: array title: Location msg: type: string title: Message type: type: string title: Error Type input: title: Input ctx: type: object title: Context type: object required: - loc - msg - type title: ValidationError UserProjectRole: properties: user_id: type: string title: User Id description: The ID of the user. project_id: type: string title: Project Id description: The ID of the project. project_role_id: type: string title: Project Role Id description: The ID of the project role. project_roles: anyOf: - $ref: '#/components/schemas/ProjectRole' - type: 'null' description: The project roles for the user in the project. created_at: type: string format: date-time title: Created At description: Timestamp of when the user project role was created. updated_at: type: string format: date-time title: Updated At description: Timestamp of when the user project role was last updated. type: object required: - user_id - project_id - project_role_id - created_at - updated_at title: UserProjectRole ProjectRole: properties: id: type: string title: Id name: type: string title: Name created_at: type: string format: date-time title: Created At updated_at: type: string format: date-time title: Updated At project_role_permissions: anyOf: - items: additionalProperties: $ref: '#/components/schemas/Permission' type: object type: array - type: 'null' title: Project Role Permissions description: The permissions for the project role. type: object required: - id - name - created_at - updated_at title: ProjectRole Permission: properties: id: anyOf: - type: string - type: 'null' title: Id action: type: string title: Action description: anyOf: - type: string - type: 'null' title: Description created_at: anyOf: - type: string format: date-time - type: 'null' title: Created At type: object required: - action title: Permission ````