> ## Documentation Index
> Fetch the complete documentation index at: https://docs.assetinfinity.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Work orders by assigned worker, open and closed.

> The Current work and History tabs are the same view with different filters.



## OpenAPI

````yaml /api-reference/openapi.json get /worker_assignments
openapi: 3.0.0
info:
  description: ''
  title: >-
    The only schema PostgREST exposes (ADR-014). Reads are security_invoker
    views; writes are SECURITY DEFINER functions. Rebuilt wholesale on every
    deploy — it holds no data.
  version: 12.2.3
servers:
  - url: https://app.assetinfinity.ai/api
security: []
tags:
  - name: Signing in
  - name: Profile
  - name: Assets
  - name: Asset lifecycle
  - name: Work lifecycle
  - name: Maintenance
  - name: Inventory
  - name: Inventory detail
  - name: Procurement
  - name: Contracts
  - name: Workforce
  - name: Capacity
  - name: Dispatch
  - name: Routing
  - name: Tools
  - name: Inspections
  - name: Verification
  - name: Reliability
  - name: Parts demand
  - name: Sensors and meters
  - name: Map
  - name: Floor plans
  - name: Labels
  - name: Lost and found
  - name: Root cause analysis
  - name: Reports
  - name: Audit center
  - name: Activity
  - name: Notifications
  - name: Channels
  - name: Search
  - name: Copilot
  - name: Import
  - name: Files
  - name: Sync
  - name: Support
  - name: Admin
  - name: Access
  - name: Lookups
  - name: Read models
  - name: Branding
  - name: Custom fields
  - name: Form studio
  - name: Workflows
  - name: Workflow studio
  - name: Rules
  - name: Statuses and transitions
  - name: Currencies and locales
  - name: Work configuration
  - name: Asset configuration
  - name: Inventory configuration
  - name: Tool configuration
  - name: Workforce configuration
  - name: Vendor and contract configuration
  - name: Document configuration
  - name: Inspection configuration
  - name: Sites, locations and the organisation
  - name: Platform
  - name: Self verification
  - name: Setup
  - name: Tools on a job, and who has them out
  - name: Vendors and contracts
  - name: Work order execution
  - name: Workforce detail
externalDocs:
  description: PostgREST Documentation
  url: https://postgrest.org/en/v12/references/api.html
paths:
  /worker_assignments:
    get:
      tags:
        - Workforce detail
      summary: Work orders by assigned worker, open and closed.
      description: >-
        The Current work and History tabs are the same view with different
        filters.
      parameters:
        - $ref: '#/components/parameters/rowFilter.worker_assignments.id'
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.work_order_number
        - $ref: '#/components/parameters/rowFilter.worker_assignments.title'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.description'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.work_order_type'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.is_planned'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.is_emergency'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.priority'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.priority_rank'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.status'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.status_label'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.status_category'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.is_open'
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.allows_technician_edit
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.allows_parts_consumption
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.allows_labour_entry
        - $ref: '#/components/parameters/rowFilter.worker_assignments.origin'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.asset_id'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.asset_number'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.asset_name'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.site_id'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.site_code'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.location_id'
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.maintenance_occurrence_id
        - $ref: '#/components/parameters/rowFilter.worker_assignments.work_request_id'
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.planned_start_at
        - $ref: '#/components/parameters/rowFilter.worker_assignments.due_at'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.response_due_at'
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.resolution_due_at
        - $ref: '#/components/parameters/rowFilter.worker_assignments.actual_start_at'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.actual_end_at'
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.actual_duration_minutes
        - $ref: '#/components/parameters/rowFilter.worker_assignments.closed_at'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.readiness_score'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.is_ready'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.problem_code'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.failure_code'
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.is_warranty_covered
        - $ref: '#/components/parameters/rowFilter.worker_assignments.contract_id'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.sla_breached'
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.estimated_duration_minutes
        - $ref: '#/components/parameters/rowFilter.worker_assignments.total_cost'
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.total_cost_currency_id
        - $ref: '#/components/parameters/rowFilter.worker_assignments.labour_cost'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.parts_cost'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.vendor_cost'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.assignees'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.task_count'
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.mandatory_tasks_outstanding
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.primary_image_file_id
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.asset_image_file_id
        - $ref: '#/components/parameters/rowFilter.worker_assignments.custom_fields'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.is_unassigned'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.age_days'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.is_overdue'
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.sla_breached_now
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.pending_approval_request_id
        - $ref: '#/components/parameters/rowFilter.worker_assignments.row_version'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.updated_at'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.worker_id'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.assignment_role'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.accepted'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.accepted_at'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.rejected_at'
        - $ref: >-
            #/components/parameters/rowFilter.worker_assignments.rejection_reason
        - $ref: '#/components/parameters/rowFilter.worker_assignments.assigned_at'
        - $ref: '#/components/parameters/rowFilter.worker_assignments.planned_minutes'
        - $ref: '#/components/parameters/select'
        - $ref: '#/components/parameters/order'
        - $ref: '#/components/parameters/range'
        - $ref: '#/components/parameters/rangeUnit'
        - $ref: '#/components/parameters/offset'
        - $ref: '#/components/parameters/limit'
        - $ref: '#/components/parameters/preferCount'
      responses:
        '200':
          content:
            application/json:
              schema:
                items:
                  $ref: '#/components/schemas/worker_assignments'
                type: array
            application/vnd.pgrst.object+json:
              schema:
                items:
                  $ref: '#/components/schemas/worker_assignments'
                type: array
            application/vnd.pgrst.object+json;nulls=stripped:
              schema:
                items:
                  $ref: '#/components/schemas/worker_assignments'
                type: array
            text/csv:
              schema:
                items:
                  $ref: '#/components/schemas/worker_assignments'
                type: array
          description: OK
        '206':
          description: Partial Content
components:
  parameters:
    rowFilter.worker_assignments.id:
      in: query
      name: id
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.work_order_number:
      in: query
      name: work_order_number
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.title:
      in: query
      name: title
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.description:
      in: query
      name: description
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.work_order_type:
      in: query
      name: work_order_type
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.is_planned:
      in: query
      name: is_planned
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.is_emergency:
      in: query
      name: is_emergency
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.priority:
      in: query
      name: priority
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.priority_rank:
      in: query
      name: priority_rank
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.status:
      in: query
      name: status
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.status_label:
      in: query
      name: status_label
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.status_category:
      in: query
      name: status_category
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.is_open:
      in: query
      name: is_open
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.allows_technician_edit:
      in: query
      name: allows_technician_edit
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.allows_parts_consumption:
      in: query
      name: allows_parts_consumption
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.allows_labour_entry:
      in: query
      name: allows_labour_entry
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.origin:
      in: query
      name: origin
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.asset_id:
      in: query
      name: asset_id
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.asset_number:
      in: query
      name: asset_number
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.asset_name:
      in: query
      name: asset_name
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.site_id:
      in: query
      name: site_id
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.site_code:
      in: query
      name: site_code
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.location_id:
      in: query
      name: location_id
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.maintenance_occurrence_id:
      in: query
      name: maintenance_occurrence_id
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.work_request_id:
      in: query
      name: work_request_id
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.planned_start_at:
      in: query
      name: planned_start_at
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.due_at:
      in: query
      name: due_at
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.response_due_at:
      in: query
      name: response_due_at
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.resolution_due_at:
      in: query
      name: resolution_due_at
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.actual_start_at:
      in: query
      name: actual_start_at
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.actual_end_at:
      in: query
      name: actual_end_at
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.actual_duration_minutes:
      in: query
      name: actual_duration_minutes
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.closed_at:
      in: query
      name: closed_at
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.readiness_score:
      in: query
      name: readiness_score
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.is_ready:
      in: query
      name: is_ready
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.problem_code:
      in: query
      name: problem_code
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.failure_code:
      in: query
      name: failure_code
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.is_warranty_covered:
      in: query
      name: is_warranty_covered
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.contract_id:
      in: query
      name: contract_id
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.sla_breached:
      in: query
      name: sla_breached
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.estimated_duration_minutes:
      in: query
      name: estimated_duration_minutes
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.total_cost:
      in: query
      name: total_cost
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.total_cost_currency_id:
      in: query
      name: total_cost_currency_id
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.labour_cost:
      in: query
      name: labour_cost
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.parts_cost:
      in: query
      name: parts_cost
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.vendor_cost:
      in: query
      name: vendor_cost
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.assignees:
      in: query
      name: assignees
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.task_count:
      in: query
      name: task_count
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.mandatory_tasks_outstanding:
      in: query
      name: mandatory_tasks_outstanding
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.primary_image_file_id:
      in: query
      name: primary_image_file_id
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.asset_image_file_id:
      in: query
      name: asset_image_file_id
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.custom_fields:
      in: query
      name: custom_fields
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.is_unassigned:
      in: query
      name: is_unassigned
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.age_days:
      in: query
      name: age_days
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.is_overdue:
      in: query
      name: is_overdue
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.sla_breached_now:
      in: query
      name: sla_breached_now
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.pending_approval_request_id:
      in: query
      name: pending_approval_request_id
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.row_version:
      in: query
      name: row_version
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.updated_at:
      in: query
      name: updated_at
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.worker_id:
      in: query
      name: worker_id
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.assignment_role:
      in: query
      name: assignment_role
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.accepted:
      in: query
      name: accepted
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.accepted_at:
      in: query
      name: accepted_at
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.rejected_at:
      in: query
      name: rejected_at
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.rejection_reason:
      in: query
      name: rejection_reason
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.assigned_at:
      in: query
      name: assigned_at
      required: false
      schema:
        type: string
    rowFilter.worker_assignments.planned_minutes:
      in: query
      name: planned_minutes
      required: false
      schema:
        type: string
    select:
      description: Filtering Columns
      in: query
      name: select
      required: false
      schema:
        type: string
    order:
      description: Ordering
      in: query
      name: order
      required: false
      schema:
        type: string
    range:
      description: Limiting and Pagination
      in: header
      name: Range
      required: false
      schema:
        type: string
    rangeUnit:
      description: Limiting and Pagination
      in: header
      name: Range-Unit
      required: false
      schema:
        default: items
        type: string
    offset:
      description: Limiting and Pagination
      in: query
      name: offset
      required: false
      schema:
        type: string
    limit:
      description: Limiting and Pagination
      in: query
      name: limit
      required: false
      schema:
        type: string
    preferCount:
      description: Preference
      in: header
      name: Prefer
      required: false
      schema:
        enum:
          - count=none
        type: string
  schemas:
    worker_assignments:
      description: >-
        Work orders by assigned worker, open and closed.


        The Current work and History tabs are the same view with different
        filters.
      properties:
        accepted:
          format: boolean
          type: boolean
        accepted_at:
          format: timestamp with time zone
          type: string
        actual_duration_minutes:
          format: integer
          type: integer
        actual_end_at:
          format: timestamp with time zone
          type: string
        actual_start_at:
          format: timestamp with time zone
          type: string
        age_days:
          format: integer
          type: integer
        allows_labour_entry:
          format: boolean
          type: boolean
        allows_parts_consumption:
          format: boolean
          type: boolean
        allows_technician_edit:
          format: boolean
          type: boolean
        asset_id:
          description: >-
            Note:

            This is a Foreign Key to `asset_contracts.asset_id`.<fk
            table='asset_contracts' column='asset_id'/>
          format: uuid
          type: string
        asset_image_file_id:
          format: uuid
          type: string
        asset_name:
          format: character varying
          maxLength: 250
          type: string
        asset_number:
          format: character varying
          maxLength: 80
          type: string
        assigned_at:
          format: timestamp with time zone
          type: string
        assignees:
          format: jsonb
        assignment_role:
          format: character varying
          maxLength: 30
          type: string
        closed_at:
          format: timestamp with time zone
          type: string
        contract_id:
          description: >-
            Note:

            This is a Foreign Key to `contracts.id`.<fk table='contracts'
            column='id'/>
          format: uuid
          type: string
        custom_fields:
          format: jsonb
        description:
          format: text
          type: string
        due_at:
          format: timestamp with time zone
          type: string
        estimated_duration_minutes:
          format: integer
          type: integer
        failure_code:
          format: character varying
          maxLength: 80
          type: string
        id:
          description: |-
            Note:
            This is a Primary Key.<pk/>
          format: uuid
          type: string
        is_emergency:
          format: boolean
          type: boolean
        is_open:
          format: boolean
          type: boolean
        is_overdue:
          format: boolean
          type: boolean
        is_planned:
          format: boolean
          type: boolean
        is_ready:
          format: boolean
          type: boolean
        is_unassigned:
          format: boolean
          type: boolean
        is_warranty_covered:
          format: boolean
          type: boolean
        labour_cost:
          format: numeric
          type: number
        location_id:
          description: >-
            Note:

            This is a Foreign Key to `location_settings.id`.<fk
            table='location_settings' column='id'/>
          format: uuid
          type: string
        maintenance_occurrence_id:
          description: >-
            Note:

            This is a Foreign Key to `maintenance_due.occurrence_id`.<fk
            table='maintenance_due' column='occurrence_id'/>
          format: uuid
          type: string
        mandatory_tasks_outstanding:
          format: bigint
          type: integer
        origin:
          format: character varying
          maxLength: 30
          type: string
        parts_cost:
          format: numeric
          type: number
        pending_approval_request_id:
          format: uuid
          type: string
        planned_minutes:
          format: integer
          type: integer
        planned_start_at:
          format: timestamp with time zone
          type: string
        primary_image_file_id:
          format: uuid
          type: string
        priority:
          format: character varying
          maxLength: 40
          type: string
        priority_rank:
          format: smallint
          type: integer
        problem_code:
          format: character varying
          maxLength: 80
          type: string
        readiness_score:
          format: numeric
          type: number
        rejected_at:
          format: timestamp with time zone
          type: string
        rejection_reason:
          format: character varying
          maxLength: 250
          type: string
        resolution_due_at:
          format: timestamp with time zone
          type: string
        response_due_at:
          format: timestamp with time zone
          type: string
        row_version:
          format: bigint
          type: integer
        site_code:
          format: character varying
          maxLength: 50
          type: string
        site_id:
          description: >-
            Note:

            This is a Foreign Key to `site_settings.id`.<fk
            table='site_settings' column='id'/>
          format: uuid
          type: string
        sla_breached:
          format: boolean
          type: boolean
        sla_breached_now:
          format: boolean
          type: boolean
        status:
          format: character varying
          maxLength: 60
          type: string
        status_category:
          format: character varying
          maxLength: 20
          type: string
        status_label:
          format: character varying
          maxLength: 150
          type: string
        task_count:
          format: bigint
          type: integer
        title:
          format: character varying
          maxLength: 250
          type: string
        total_cost:
          format: numeric
          type: number
        total_cost_currency_id:
          format: uuid
          type: string
        updated_at:
          format: timestamp with time zone
          type: string
        vendor_cost:
          format: numeric
          type: number
        work_order_number:
          format: character varying
          maxLength: 60
          type: string
        work_order_type:
          format: character varying
          maxLength: 40
          type: string
        work_request_id:
          description: >-
            Note:

            This is a Foreign Key to `work_requests.id`.<fk
            table='work_requests' column='id'/>
          format: uuid
          type: string
        worker_id:
          description: >-
            Note:

            This is a Foreign Key to `technician_workload.worker_id`.<fk
            table='technician_workload' column='worker_id'/>
          format: uuid
          type: string
      type: object

````

## Related topics

- [The work order lifecycle](/work/lifecycle.md)
- [The work order list](/work/work-orders.md)
- [Your first hour](/quickstart.md)
- [Work requests](/work/requests.md)
- [Inside a vendor](/commercial/vendor-detail.md)