> ## 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 order labour with every field of the records each row points at: technician, vendor, work order. > Choose this source when one report needs columns from more than one register. Every list, export and dashboard reads the base view instead, which costs none of these joins — and the planner does not remove them when the columns go unnamed, so the two are separate sources on purpose. ## OpenAPI ````yaml /api-reference/openapi.json get /work_order_labour_expanded openapi: 3.0.0 info: description: '' title: >- The only schema PostgREST exposes. 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: My work - name: Sites and locations - name: Assets - name: Asset lifecycle - name: Asset components - name: Work lifecycle - name: Work order execution - name: Work sequencing - name: Maintenance - name: Inspections - name: Checklists - name: Verification - name: Self verification - name: Inventory - name: Inventory detail - name: Parts demand - name: Procurement - name: Vendors and contracts - name: Contracts - name: Amendments - name: Vendor spend forecast - name: Workforce - name: Workforce detail - name: Capacity - name: Dispatch - name: Shutdown - name: Permits - name: Tools - name: Tools on jobs - name: Bookings - name: Calibration history - name: Reliability - name: Sensors and meters - name: Readers - name: Trackers - name: Real-time location - name: Feeds - name: Energy - name: IT assets - name: IT asset software - name: IT asset topology - name: Map - name: Floor plans - name: Labels - name: Lost and found - name: Visitors - name: Root cause analysis - name: Costing - name: Finance - name: Budgets - name: Capex plans - name: FF&E plans - name: Documents - name: Document control - name: Document folders - name: Document tree - name: Knowledge - name: Reports - name: Dashboards - name: Extracts - name: Data exports - name: Audit center - name: Audit feed - name: Activity - name: Conversations - name: Notifications - name: Date reminders - name: Channels - name: Search - name: Copilot - name: Import - name: Bulk jobs - name: File exchange - name: Filing exceptions - name: Files - name: Sync - name: Support - name: API keys - name: Webhooks - name: MCP connections - name: MCP sign-in - name: SCIM provisioning - name: Directory sync - name: Security streams - name: Single sign-on - name: Two-factor sign-in - name: Admin - name: Access - name: Lookups - name: Read models - name: Reference - name: Reference columns - name: Reference entry - name: List views - name: Mapping - name: Numbering - name: Branding - name: Custom fields - name: Form studio - name: Workflows - name: Workflow studio - name: Rules - name: Statuses and transitions - name: Currencies and locales - name: Today - 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: Setup - name: Features - name: Billing - name: Licence - name: Welcome - name: Tray - name: Tenant switch - name: Release - name: Telegram - name: Inbound mail - name: Platform externalDocs: description: PostgREST Documentation url: https://postgrest.org/en/v12/references/api.html paths: /work_order_labour_expanded: get: tags: - Work order execution summary: >- Work order labour with every field of the records each row points at: technician, vendor, work order. description: >- Choose this source when one report needs columns from more than one register. Every list, export and dashboard reads the base view instead, which costs none of these joins — and the planner does not remove them when the columns go unnamed, so the two are separate sources on purpose. parameters: - $ref: '#/components/parameters/rowFilter.work_order_labour_expanded.id' - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order_id - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker_id - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor_id - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.rate_type - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.planned_hours - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.actual_hours - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.hours_variance - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.hourly_rate - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.hourly_rate_currency_id - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.currency_code - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.line_cost - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.is_warranty_covered - $ref: '#/components/parameters/rowFilter.work_order_labour_expanded.notes' - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.row_version - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__vendor_number - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__legal_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__vendor_type - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__is_oem - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__status - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__status_label - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__status_category - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__email - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__phone - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__website - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__payment_terms_days - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__onboarded_on - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__approved_on - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__performance_score - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__usable - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__categories - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__site_count - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__active_contracts - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__best_response_minutes - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__average_rating - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__rating_count - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__open_work_orders - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__warranty_work_orders - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__open_claims - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__is_assignable - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__compliance_expiring - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__warranty_authorisations - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__custom_fields - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__created_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__created_by_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__updated_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.vendor__updated_by_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__work_order_number - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__title - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__description - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__remarks - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__work_order_type - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__work_order_type_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__is_planned - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__is_emergency - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__priority - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__priority_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__priority_rank - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__status - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__status_label - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__status_category - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__is_open - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__allows_technician_edit - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__allows_parts_consumption - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__allows_labour_entry - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__allows_sla_extension - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__origin - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__reported_by_user_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__asset_number - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__asset_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__site_code - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__planned_start_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__planned_end_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__due_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__response_due_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__resolution_due_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__actual_start_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__actual_end_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__actual_duration_minutes - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__closed_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__readiness_score - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__is_ready - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__requires_permit - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__permit_required - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__safety_instructions - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__safety_briefing - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__problem_code - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__failure_code - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__resolution_code - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__resolution_code_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__resolution_notes - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__is_warranty_covered - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__sla_breached - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__sla_source - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__sla_target_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__estimated_duration_minutes - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__total_cost - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__labour_cost - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__parts_cost - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__vendor_cost - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__status_is_terminal - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__assigned_vendor_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__assigned_team_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__vendor_technician - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__vendor_technician_phone - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__assignees - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__cc - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__task_count - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__mandatory_tasks_outstanding - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__custom_fields - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__is_unassigned - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__age_days - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__turnaround_minutes - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__turnaround_running - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__checked_in_minutes - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__checked_in_since - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__is_overdue - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__sla_breached_now - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__created_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__created_by_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__updated_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.work_order__updated_by_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__worker_number - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__worker_type - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__max_concurrent_work_orders - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__is_active - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__open_work_orders - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__active_work_orders - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__overdue_work_orders - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__planned_minutes_outstanding - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__skills - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__email - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__phone - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__user_email - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__user_status - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__employment_status - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__employment_start_date - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__can_travel - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__travel_radius_km - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__track_location - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__site_code - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__site_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__department_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__team_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__is_team_lead - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__availability - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__valid_certifications - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__certifications_expiring - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__certifications_lapsed - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__next_certification_expiry - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__performance_period_start - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__performance_period_end - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__utilisation_rate - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__first_time_fix_rate - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__sla_compliance_rate - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__completed_in_period - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__custom_fields - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__created_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__created_by_name - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__updated_at - $ref: >- #/components/parameters/rowFilter.work_order_labour_expanded.worker__updated_by_name - $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/work_order_labour_expanded' type: array application/vnd.pgrst.object+json: schema: items: $ref: '#/components/schemas/work_order_labour_expanded' type: array application/vnd.pgrst.object+json;nulls=stripped: schema: items: $ref: '#/components/schemas/work_order_labour_expanded' type: array text/csv: schema: items: $ref: '#/components/schemas/work_order_labour_expanded' type: array description: OK '206': description: Partial Content components: parameters: rowFilter.work_order_labour_expanded.id: in: query name: id required: false schema: type: string rowFilter.work_order_labour_expanded.work_order_id: in: query name: work_order_id required: false schema: type: string rowFilter.work_order_labour_expanded.worker_id: in: query name: worker_id required: false schema: type: string rowFilter.work_order_labour_expanded.worker_name: in: query name: worker_name required: false schema: type: string rowFilter.work_order_labour_expanded.vendor_id: in: query name: vendor_id required: false schema: type: string rowFilter.work_order_labour_expanded.vendor_name: in: query name: vendor_name required: false schema: type: string rowFilter.work_order_labour_expanded.rate_type: in: query name: rate_type required: false schema: type: string rowFilter.work_order_labour_expanded.planned_hours: in: query name: planned_hours required: false schema: type: string rowFilter.work_order_labour_expanded.actual_hours: in: query name: actual_hours required: false schema: type: string rowFilter.work_order_labour_expanded.hours_variance: in: query name: hours_variance required: false schema: type: string rowFilter.work_order_labour_expanded.hourly_rate: in: query name: hourly_rate required: false schema: type: string rowFilter.work_order_labour_expanded.hourly_rate_currency_id: in: query name: hourly_rate_currency_id required: false schema: type: string rowFilter.work_order_labour_expanded.currency_code: in: query name: currency_code required: false schema: type: string rowFilter.work_order_labour_expanded.line_cost: in: query name: line_cost required: false schema: type: string rowFilter.work_order_labour_expanded.is_warranty_covered: in: query name: is_warranty_covered required: false schema: type: string rowFilter.work_order_labour_expanded.notes: in: query name: notes required: false schema: type: string rowFilter.work_order_labour_expanded.row_version: in: query name: row_version required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__vendor_number: in: query name: vendor__vendor_number required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__name: in: query name: vendor__name required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__legal_name: in: query name: vendor__legal_name required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__vendor_type: in: query name: vendor__vendor_type required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__is_oem: in: query name: vendor__is_oem required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__status: in: query name: vendor__status required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__status_label: in: query name: vendor__status_label required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__status_category: in: query name: vendor__status_category required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__email: in: query name: vendor__email required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__phone: in: query name: vendor__phone required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__website: in: query name: vendor__website required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__payment_terms_days: in: query name: vendor__payment_terms_days required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__onboarded_on: in: query name: vendor__onboarded_on required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__approved_on: in: query name: vendor__approved_on required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__performance_score: in: query name: vendor__performance_score required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__usable: in: query name: vendor__usable required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__categories: in: query name: vendor__categories required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__site_count: in: query name: vendor__site_count required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__active_contracts: in: query name: vendor__active_contracts required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__best_response_minutes: in: query name: vendor__best_response_minutes required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__average_rating: in: query name: vendor__average_rating required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__rating_count: in: query name: vendor__rating_count required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__open_work_orders: in: query name: vendor__open_work_orders required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__warranty_work_orders: in: query name: vendor__warranty_work_orders required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__open_claims: in: query name: vendor__open_claims required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__is_assignable: in: query name: vendor__is_assignable required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__compliance_expiring: in: query name: vendor__compliance_expiring required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__warranty_authorisations: in: query name: vendor__warranty_authorisations required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__custom_fields: in: query name: vendor__custom_fields required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__created_at: in: query name: vendor__created_at required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__created_by_name: in: query name: vendor__created_by_name required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__updated_at: in: query name: vendor__updated_at required: false schema: type: string rowFilter.work_order_labour_expanded.vendor__updated_by_name: in: query name: vendor__updated_by_name required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__work_order_number: in: query name: work_order__work_order_number required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__title: in: query name: work_order__title required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__description: in: query name: work_order__description required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__remarks: in: query name: work_order__remarks required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__work_order_type: in: query name: work_order__work_order_type required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__work_order_type_name: in: query name: work_order__work_order_type_name required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__is_planned: in: query name: work_order__is_planned required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__is_emergency: in: query name: work_order__is_emergency required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__priority: in: query name: work_order__priority required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__priority_name: in: query name: work_order__priority_name required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__priority_rank: in: query name: work_order__priority_rank required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__status: in: query name: work_order__status required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__status_label: in: query name: work_order__status_label required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__status_category: in: query name: work_order__status_category required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__is_open: in: query name: work_order__is_open required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__allows_technician_edit: in: query name: work_order__allows_technician_edit required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__allows_parts_consumption: in: query name: work_order__allows_parts_consumption required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__allows_labour_entry: in: query name: work_order__allows_labour_entry required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__allows_sla_extension: in: query name: work_order__allows_sla_extension required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__origin: in: query name: work_order__origin required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__reported_by_user_name: in: query name: work_order__reported_by_user_name required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__asset_number: in: query name: work_order__asset_number required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__asset_name: in: query name: work_order__asset_name required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__site_code: in: query name: work_order__site_code required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__planned_start_at: in: query name: work_order__planned_start_at required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__planned_end_at: in: query name: work_order__planned_end_at required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__due_at: in: query name: work_order__due_at required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__response_due_at: in: query name: work_order__response_due_at required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__resolution_due_at: in: query name: work_order__resolution_due_at required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__actual_start_at: in: query name: work_order__actual_start_at required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__actual_end_at: in: query name: work_order__actual_end_at required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__actual_duration_minutes: in: query name: work_order__actual_duration_minutes required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__closed_at: in: query name: work_order__closed_at required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__readiness_score: in: query name: work_order__readiness_score required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__is_ready: in: query name: work_order__is_ready required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__requires_permit: in: query name: work_order__requires_permit required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__permit_required: in: query name: work_order__permit_required required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__safety_instructions: in: query name: work_order__safety_instructions required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__safety_briefing: in: query name: work_order__safety_briefing required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__problem_code: in: query name: work_order__problem_code required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__failure_code: in: query name: work_order__failure_code required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__resolution_code: in: query name: work_order__resolution_code required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__resolution_code_name: in: query name: work_order__resolution_code_name required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__resolution_notes: in: query name: work_order__resolution_notes required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__is_warranty_covered: in: query name: work_order__is_warranty_covered required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__sla_breached: in: query name: work_order__sla_breached required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__sla_source: in: query name: work_order__sla_source required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__sla_target_name: in: query name: work_order__sla_target_name required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__estimated_duration_minutes: in: query name: work_order__estimated_duration_minutes required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__total_cost: in: query name: work_order__total_cost required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__labour_cost: in: query name: work_order__labour_cost required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__parts_cost: in: query name: work_order__parts_cost required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__vendor_cost: in: query name: work_order__vendor_cost required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__status_is_terminal: in: query name: work_order__status_is_terminal required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__assigned_vendor_name: in: query name: work_order__assigned_vendor_name required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__assigned_team_name: in: query name: work_order__assigned_team_name required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__vendor_technician: in: query name: work_order__vendor_technician required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__vendor_technician_phone: in: query name: work_order__vendor_technician_phone required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__assignees: in: query name: work_order__assignees required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__cc: in: query name: work_order__cc required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__task_count: in: query name: work_order__task_count required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__mandatory_tasks_outstanding: in: query name: work_order__mandatory_tasks_outstanding required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__custom_fields: in: query name: work_order__custom_fields required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__is_unassigned: in: query name: work_order__is_unassigned required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__age_days: in: query name: work_order__age_days required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__turnaround_minutes: in: query name: work_order__turnaround_minutes required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__turnaround_running: in: query name: work_order__turnaround_running required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__checked_in_minutes: in: query name: work_order__checked_in_minutes required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__checked_in_since: in: query name: work_order__checked_in_since required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__is_overdue: in: query name: work_order__is_overdue required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__sla_breached_now: in: query name: work_order__sla_breached_now required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__created_at: in: query name: work_order__created_at required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__created_by_name: in: query name: work_order__created_by_name required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__updated_at: in: query name: work_order__updated_at required: false schema: type: string rowFilter.work_order_labour_expanded.work_order__updated_by_name: in: query name: work_order__updated_by_name required: false schema: type: string rowFilter.work_order_labour_expanded.worker__worker_number: in: query name: worker__worker_number required: false schema: type: string rowFilter.work_order_labour_expanded.worker__name: in: query name: worker__name required: false schema: type: string rowFilter.work_order_labour_expanded.worker__worker_type: in: query name: worker__worker_type required: false schema: type: string rowFilter.work_order_labour_expanded.worker__max_concurrent_work_orders: in: query name: worker__max_concurrent_work_orders required: false schema: type: string rowFilter.work_order_labour_expanded.worker__is_active: in: query name: worker__is_active required: false schema: type: string rowFilter.work_order_labour_expanded.worker__open_work_orders: in: query name: worker__open_work_orders required: false schema: type: string rowFilter.work_order_labour_expanded.worker__active_work_orders: in: query name: worker__active_work_orders required: false schema: type: string rowFilter.work_order_labour_expanded.worker__overdue_work_orders: in: query name: worker__overdue_work_orders required: false schema: type: string rowFilter.work_order_labour_expanded.worker__planned_minutes_outstanding: in: query name: worker__planned_minutes_outstanding required: false schema: type: string rowFilter.work_order_labour_expanded.worker__skills: in: query name: worker__skills required: false schema: type: string rowFilter.work_order_labour_expanded.worker__email: in: query name: worker__email required: false schema: type: string rowFilter.work_order_labour_expanded.worker__phone: in: query name: worker__phone required: false schema: type: string rowFilter.work_order_labour_expanded.worker__user_email: in: query name: worker__user_email required: false schema: type: string rowFilter.work_order_labour_expanded.worker__user_status: in: query name: worker__user_status required: false schema: type: string rowFilter.work_order_labour_expanded.worker__employment_status: in: query name: worker__employment_status required: false schema: type: string rowFilter.work_order_labour_expanded.worker__employment_start_date: in: query name: worker__employment_start_date required: false schema: type: string rowFilter.work_order_labour_expanded.worker__can_travel: in: query name: worker__can_travel required: false schema: type: string rowFilter.work_order_labour_expanded.worker__travel_radius_km: in: query name: worker__travel_radius_km required: false schema: type: string rowFilter.work_order_labour_expanded.worker__track_location: in: query name: worker__track_location required: false schema: type: string rowFilter.work_order_labour_expanded.worker__site_code: in: query name: worker__site_code required: false schema: type: string rowFilter.work_order_labour_expanded.worker__site_name: in: query name: worker__site_name required: false schema: type: string rowFilter.work_order_labour_expanded.worker__department_name: in: query name: worker__department_name required: false schema: type: string rowFilter.work_order_labour_expanded.worker__team_name: in: query name: worker__team_name required: false schema: type: string rowFilter.work_order_labour_expanded.worker__is_team_lead: in: query name: worker__is_team_lead required: false schema: type: string rowFilter.work_order_labour_expanded.worker__availability: in: query name: worker__availability required: false schema: type: string rowFilter.work_order_labour_expanded.worker__valid_certifications: in: query name: worker__valid_certifications required: false schema: type: string rowFilter.work_order_labour_expanded.worker__certifications_expiring: in: query name: worker__certifications_expiring required: false schema: type: string rowFilter.work_order_labour_expanded.worker__certifications_lapsed: in: query name: worker__certifications_lapsed required: false schema: type: string rowFilter.work_order_labour_expanded.worker__next_certification_expiry: in: query name: worker__next_certification_expiry required: false schema: type: string rowFilter.work_order_labour_expanded.worker__performance_period_start: in: query name: worker__performance_period_start required: false schema: type: string rowFilter.work_order_labour_expanded.worker__performance_period_end: in: query name: worker__performance_period_end required: false schema: type: string rowFilter.work_order_labour_expanded.worker__utilisation_rate: in: query name: worker__utilisation_rate required: false schema: type: string rowFilter.work_order_labour_expanded.worker__first_time_fix_rate: in: query name: worker__first_time_fix_rate required: false schema: type: string rowFilter.work_order_labour_expanded.worker__sla_compliance_rate: in: query name: worker__sla_compliance_rate required: false schema: type: string rowFilter.work_order_labour_expanded.worker__completed_in_period: in: query name: worker__completed_in_period required: false schema: type: string rowFilter.work_order_labour_expanded.worker__custom_fields: in: query name: worker__custom_fields required: false schema: type: string rowFilter.work_order_labour_expanded.worker__created_at: in: query name: worker__created_at required: false schema: type: string rowFilter.work_order_labour_expanded.worker__created_by_name: in: query name: worker__created_by_name required: false schema: type: string rowFilter.work_order_labour_expanded.worker__updated_at: in: query name: worker__updated_at required: false schema: type: string rowFilter.work_order_labour_expanded.worker__updated_by_name: in: query name: worker__updated_by_name 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: work_order_labour_expanded: description: >- Work order labour with every field of the records each row points at: technician, vendor, work order. Choose this source when one report needs columns from more than one register. Every list, export and dashboard reads the base view instead, which costs none of these joins — and the planner does not remove them when the columns go unnamed, so the two are separate sources on purpose. properties: actual_hours: format: numeric type: number currency_code: format: character varying maxLength: 3 type: string hourly_rate: format: numeric type: number hourly_rate_currency_id: description: >- Note: This is a Foreign Key to `asset_cost_to_keep.currency_id`. format: uuid type: string hours_variance: format: numeric type: number id: description: |- Note: This is a Primary Key. format: uuid type: string is_warranty_covered: format: boolean type: boolean line_cost: format: numeric type: number notes: format: text type: string planned_hours: format: numeric type: number rate_type: format: character varying maxLength: 30 type: string row_version: format: bigint type: integer vendor__active_contracts: format: bigint type: integer vendor__approved_on: format: date type: string vendor__average_rating: format: numeric type: number vendor__best_response_minutes: format: integer type: integer vendor__categories: format: jsonb vendor__compliance_expiring: format: bigint type: integer vendor__created_at: format: timestamp with time zone type: string vendor__created_by_name: format: character varying maxLength: 200 type: string vendor__custom_fields: format: jsonb vendor__email: format: public.citext type: string vendor__is_assignable: format: boolean type: boolean vendor__is_oem: format: boolean type: boolean vendor__legal_name: format: character varying maxLength: 250 type: string vendor__name: format: character varying maxLength: 200 type: string vendor__onboarded_on: format: date type: string vendor__open_claims: format: bigint type: integer vendor__open_work_orders: format: bigint type: integer vendor__payment_terms_days: format: integer type: integer vendor__performance_score: format: numeric type: number vendor__phone: format: character varying maxLength: 40 type: string vendor__rating_count: format: bigint type: integer vendor__site_count: format: bigint type: integer vendor__status: format: character varying maxLength: 60 type: string vendor__status_category: format: character varying maxLength: 20 type: string vendor__status_label: format: text type: string vendor__updated_at: format: timestamp with time zone type: string vendor__updated_by_name: format: character varying maxLength: 200 type: string vendor__usable: format: boolean type: boolean vendor__vendor_number: format: character varying maxLength: 60 type: string vendor__vendor_type: format: character varying maxLength: 40 type: string vendor__warranty_authorisations: format: bigint type: integer vendor__warranty_work_orders: format: bigint type: integer vendor__website: format: character varying maxLength: 250 type: string vendor_id: description: >- Note: This is a Foreign Key to `assignable_vendors.id`. format: uuid type: string vendor_name: format: character varying maxLength: 200 type: string work_order__actual_duration_minutes: format: integer type: integer work_order__actual_end_at: format: timestamp with time zone type: string work_order__actual_start_at: format: timestamp with time zone type: string work_order__age_days: format: integer type: integer work_order__allows_labour_entry: format: boolean type: boolean work_order__allows_parts_consumption: format: boolean type: boolean work_order__allows_sla_extension: format: boolean type: boolean work_order__allows_technician_edit: format: boolean type: boolean work_order__asset_name: format: character varying maxLength: 250 type: string work_order__asset_number: format: character varying maxLength: 80 type: string work_order__assigned_team_name: format: character varying maxLength: 200 type: string work_order__assigned_vendor_name: format: character varying maxLength: 200 type: string work_order__assignees: format: jsonb work_order__cc: format: jsonb work_order__checked_in_minutes: format: integer type: integer work_order__checked_in_since: format: timestamp with time zone type: string work_order__closed_at: format: timestamp with time zone type: string work_order__created_at: format: timestamp with time zone type: string work_order__created_by_name: format: character varying maxLength: 200 type: string work_order__custom_fields: format: jsonb work_order__description: format: text type: string work_order__due_at: format: timestamp with time zone type: string work_order__estimated_duration_minutes: format: integer type: integer work_order__failure_code: format: character varying maxLength: 80 type: string work_order__is_emergency: format: boolean type: boolean work_order__is_open: format: boolean type: boolean work_order__is_overdue: format: boolean type: boolean work_order__is_planned: format: boolean type: boolean work_order__is_ready: format: boolean type: boolean work_order__is_unassigned: format: boolean type: boolean work_order__is_warranty_covered: format: boolean type: boolean work_order__labour_cost: format: numeric type: number work_order__mandatory_tasks_outstanding: format: bigint type: integer work_order__origin: format: character varying maxLength: 30 type: string work_order__parts_cost: format: numeric type: number work_order__permit_required: format: boolean type: boolean work_order__planned_end_at: format: timestamp with time zone type: string work_order__planned_start_at: format: timestamp with time zone type: string work_order__priority: format: character varying maxLength: 40 type: string work_order__priority_name: format: character varying maxLength: 150 type: string work_order__priority_rank: format: smallint type: integer work_order__problem_code: format: character varying maxLength: 80 type: string work_order__readiness_score: format: numeric type: number work_order__remarks: format: text type: string work_order__reported_by_user_name: format: character varying maxLength: 200 type: string work_order__requires_permit: format: boolean type: boolean work_order__resolution_code: format: character varying maxLength: 60 type: string work_order__resolution_code_name: format: character varying maxLength: 200 type: string work_order__resolution_due_at: format: timestamp with time zone type: string work_order__resolution_notes: format: text type: string work_order__response_due_at: format: timestamp with time zone type: string work_order__safety_briefing: format: text type: string work_order__safety_instructions: format: text type: string work_order__site_code: format: character varying maxLength: 50 type: string work_order__sla_breached: format: boolean type: boolean work_order__sla_breached_now: format: boolean type: boolean work_order__sla_source: format: character varying maxLength: 20 type: string work_order__sla_target_name: format: character varying maxLength: 150 type: string work_order__status: format: character varying maxLength: 60 type: string work_order__status_category: format: character varying maxLength: 20 type: string work_order__status_is_terminal: format: boolean type: boolean work_order__status_label: format: text type: string work_order__task_count: format: bigint type: integer work_order__title: format: character varying maxLength: 250 type: string work_order__total_cost: format: numeric type: number work_order__turnaround_minutes: format: integer type: integer work_order__turnaround_running: format: boolean type: boolean work_order__updated_at: format: timestamp with time zone type: string work_order__updated_by_name: format: character varying maxLength: 200 type: string work_order__vendor_cost: format: numeric type: number work_order__vendor_technician: format: character varying maxLength: 120 type: string work_order__vendor_technician_phone: format: character varying maxLength: 40 type: string work_order__work_order_number: format: character varying maxLength: 60 type: string work_order__work_order_type: format: character varying maxLength: 40 type: string work_order__work_order_type_name: format: character varying maxLength: 150 type: string work_order_id: description: >- Note: This is a Foreign Key to `asset_maintenance_plans.next_work_order_id`. format: uuid type: string worker__active_work_orders: format: bigint type: integer worker__availability: format: text type: string worker__can_travel: format: boolean type: boolean worker__certifications_expiring: format: bigint type: integer worker__certifications_lapsed: format: bigint type: integer worker__completed_in_period: format: integer type: integer worker__created_at: format: timestamp with time zone type: string worker__created_by_name: format: character varying maxLength: 200 type: string worker__custom_fields: format: jsonb worker__department_name: format: character varying maxLength: 200 type: string worker__email: format: public.citext type: string worker__employment_start_date: format: date type: string worker__employment_status: format: character varying maxLength: 30 type: string worker__first_time_fix_rate: format: numeric type: number worker__is_active: format: boolean type: boolean worker__is_team_lead: format: boolean type: boolean worker__max_concurrent_work_orders: format: smallint type: integer worker__name: format: character varying maxLength: 200 type: string worker__next_certification_expiry: format: date type: string worker__open_work_orders: format: bigint type: integer worker__overdue_work_orders: format: bigint type: integer worker__performance_period_end: format: date type: string worker__performance_period_start: format: date type: string worker__phone: format: character varying maxLength: 40 type: string worker__planned_minutes_outstanding: format: integer type: integer worker__site_code: format: character varying maxLength: 50 type: string worker__site_name: format: character varying maxLength: 200 type: string worker__skills: format: jsonb worker__sla_compliance_rate: format: numeric type: number worker__team_name: format: character varying maxLength: 200 type: string worker__track_location: format: boolean type: boolean worker__travel_radius_km: format: integer type: integer worker__updated_at: format: timestamp with time zone type: string worker__updated_by_name: format: character varying maxLength: 200 type: string worker__user_email: format: text type: string worker__user_status: format: character varying maxLength: 30 type: string worker__utilisation_rate: format: numeric type: number worker__valid_certifications: format: bigint type: integer worker__worker_number: format: character varying maxLength: 60 type: string worker__worker_type: format: character varying maxLength: 40 type: string worker_id: description: >- Note: This is a Foreign Key to `assignable_workers.id`. format: uuid type: string worker_name: format: character varying maxLength: 200 type: string type: object ```` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.