> ## 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 requests with every field of the records each row points at: asset, duplicate of, location, requested by, site, triaged by. > 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_requests_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: 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: 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: Amendments - name: Asset clone - name: Asset components - name: Asset register - name: Asset transfer - name: Audit feed - name: Billing - name: Bookings - name: Budgets - name: Bulk jobs - name: Calibration history - name: Capex plans - name: Conversations - name: Costing - name: Currency - name: Dashboards - name: Directory sync - name: Document control - name: Document folders - name: Document tree - name: Documents - name: Energy - name: Extracts - name: Features - name: Feeds - name: File exchange - name: Filing exceptions - name: Finance - name: Inbound mail - name: Keys - name: Knowledge - name: Licence - name: List views - name: Locations - name: Mapping - name: Mcp - name: Mcp oauth - name: Mfa - name: Numbering - name: Permits - name: Readers - name: Reference - name: Reference columns - name: Reference entry - name: Release - name: Scim - name: Security streams - name: Self verification - name: Setup - name: Shutdown - name: Sso - name: Telegram - name: Tenant switch - name: The caller's own work - name: The checklist library - name: Tools on a job, and who has them out - name: Tray - name: Vendor spend forecast - name: Vendors and contracts - name: Visitors - name: Work order execution - name: Work sequencing - name: Workforce detail externalDocs: description: PostgREST Documentation url: https://postgrest.org/en/v12/references/api.html paths: /work_requests_expanded: get: tags: - work_requests_expanded summary: >- Work requests with every field of the records each row points at: asset, duplicate of, location, requested by, site, triaged by. 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_requests_expanded.id' - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.request_number - $ref: '#/components/parameters/rowFilter.work_requests_expanded.summary' - $ref: '#/components/parameters/rowFilter.work_requests_expanded.description' - $ref: '#/components/parameters/rowFilter.work_requests_expanded.status' - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.status_label - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.status_category - $ref: '#/components/parameters/rowFilter.work_requests_expanded.source' - $ref: '#/components/parameters/rowFilter.work_requests_expanded.category' - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.work_request_category_id - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.category_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.reported_severity - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.severity_rank - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.suggested_work_order_priority_id - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.suggested_priority_code - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.suggested_priority_name - $ref: '#/components/parameters/rowFilter.work_requests_expanded.asset_id' - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset_number - $ref: '#/components/parameters/rowFilter.work_requests_expanded.asset_name' - $ref: '#/components/parameters/rowFilter.work_requests_expanded.site_id' - $ref: '#/components/parameters/rowFilter.work_requests_expanded.location_id' - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requester_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requested_by_user_id - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.discovered_at - $ref: '#/components/parameters/rowFilter.work_requests_expanded.triaged_at' - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.rejection_reason - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of_work_request_id - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.assigned_worker_id - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.assigned_worker_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.assigned_team_id - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.assigned_team_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.assigned_vendor_id - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.assigned_vendor_name - $ref: '#/components/parameters/rowFilter.work_requests_expanded.cc' - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.work_order_id - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.work_order_number - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.primary_image_file_id - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset_image_file_id - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.custom_fields - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.pending_approval_request_id - $ref: '#/components/parameters/rowFilter.work_requests_expanded.row_version' - $ref: '#/components/parameters/rowFilter.work_requests_expanded.created_at' - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.created_by_id - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.created_by_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.created_source - $ref: '#/components/parameters/rowFilter.work_requests_expanded.updated_at' - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.updated_by_id - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.updated_by_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__asset_number - $ref: '#/components/parameters/rowFilter.work_requests_expanded.asset__name' - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__serial_number - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__asset_category_code - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__asset_category - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__asset_category_ancestor_ids - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__asset_category_path - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__asset_category_root_code - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__asset_category_root - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__asset_class_code - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__asset_class - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__asset_class_is_default - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__status - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__status_label - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__status_category - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__criticality - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__criticality_rank - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__criticality_response_minutes - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__site_code - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__site_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__location_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__latitude - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__longitude - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__parent_asset_number - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__manufacturer - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__model_code - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__model_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__purchase_date - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__installation_date - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__commissioning_date - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__warranty_expires_on - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__health_score - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__is_retired - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__custodian - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__custodian_email - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__custody_since - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__custom_fields - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__created_at - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__created_by_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__updated_at - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.asset__updated_by_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__request_number - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__summary - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__description - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__status - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__status_label - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__status_category - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__source - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__category - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__category_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__reported_severity - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__severity_rank - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__suggested_priority_code - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__suggested_priority_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__asset_number - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__asset_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__requester_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__discovered_at - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__triaged_at - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__rejection_reason - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__assigned_worker_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__assigned_team_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__assigned_vendor_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__cc - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__work_order_number - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__custom_fields - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__created_at - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__created_by_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__updated_at - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.duplicate_of__updated_by_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__site_code - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__parent_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__location_type - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__level_hint - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__code - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__path - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__depth - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__latitude - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__longitude - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__is_active - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__allows_direct_filing - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__takes_filing - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__primary_location_head_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__alternate_location_heads - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__children - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__assets - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.location__assets_in_branch - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requested_by__email - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requested_by__username - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requested_by__sign_in_handle - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requested_by__name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requested_by__phone - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requested_by__status - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requested_by__last_login_at - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requested_by__worker_number - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requested_by__worker_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requested_by__worker_type - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requested_by__worker_is_active - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.requested_by__worker_teams - $ref: '#/components/parameters/rowFilter.work_requests_expanded.site__code' - $ref: '#/components/parameters/rowFilter.work_requests_expanded.site__name' - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.site__timezone - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.site__is_active - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.site__company_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.site__business_unit_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.site__business_unit_parent_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.site__asset_count - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.triaged_by__email - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.triaged_by__username - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.triaged_by__sign_in_handle - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.triaged_by__name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.triaged_by__phone - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.triaged_by__status - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.triaged_by__last_login_at - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.triaged_by__worker_number - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.triaged_by__worker_name - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.triaged_by__worker_type - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.triaged_by__worker_is_active - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.triaged_by__worker_teams - $ref: >- #/components/parameters/rowFilter.work_requests_expanded.reference_records - $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_requests_expanded' type: array application/vnd.pgrst.object+json: schema: items: $ref: '#/components/schemas/work_requests_expanded' type: array application/vnd.pgrst.object+json;nulls=stripped: schema: items: $ref: '#/components/schemas/work_requests_expanded' type: array text/csv: schema: items: $ref: '#/components/schemas/work_requests_expanded' type: array description: OK '206': description: Partial Content components: parameters: rowFilter.work_requests_expanded.id: in: query name: id required: false schema: type: string rowFilter.work_requests_expanded.request_number: in: query name: request_number required: false schema: type: string rowFilter.work_requests_expanded.summary: in: query name: summary required: false schema: type: string rowFilter.work_requests_expanded.description: in: query name: description required: false schema: type: string rowFilter.work_requests_expanded.status: in: query name: status required: false schema: type: string rowFilter.work_requests_expanded.status_label: in: query name: status_label required: false schema: type: string rowFilter.work_requests_expanded.status_category: in: query name: status_category required: false schema: type: string rowFilter.work_requests_expanded.source: in: query name: source required: false schema: type: string rowFilter.work_requests_expanded.category: in: query name: category required: false schema: type: string rowFilter.work_requests_expanded.work_request_category_id: in: query name: work_request_category_id required: false schema: type: string rowFilter.work_requests_expanded.category_name: in: query name: category_name required: false schema: type: string rowFilter.work_requests_expanded.reported_severity: in: query name: reported_severity required: false schema: type: string rowFilter.work_requests_expanded.severity_rank: in: query name: severity_rank required: false schema: type: string rowFilter.work_requests_expanded.suggested_work_order_priority_id: in: query name: suggested_work_order_priority_id required: false schema: type: string rowFilter.work_requests_expanded.suggested_priority_code: in: query name: suggested_priority_code required: false schema: type: string rowFilter.work_requests_expanded.suggested_priority_name: in: query name: suggested_priority_name required: false schema: type: string rowFilter.work_requests_expanded.asset_id: in: query name: asset_id required: false schema: type: string rowFilter.work_requests_expanded.asset_number: in: query name: asset_number required: false schema: type: string rowFilter.work_requests_expanded.asset_name: in: query name: asset_name required: false schema: type: string rowFilter.work_requests_expanded.site_id: in: query name: site_id required: false schema: type: string rowFilter.work_requests_expanded.location_id: in: query name: location_id required: false schema: type: string rowFilter.work_requests_expanded.requester_name: in: query name: requester_name required: false schema: type: string rowFilter.work_requests_expanded.requested_by_user_id: in: query name: requested_by_user_id required: false schema: type: string rowFilter.work_requests_expanded.discovered_at: in: query name: discovered_at required: false schema: type: string rowFilter.work_requests_expanded.triaged_at: in: query name: triaged_at required: false schema: type: string rowFilter.work_requests_expanded.rejection_reason: in: query name: rejection_reason required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of_work_request_id: in: query name: duplicate_of_work_request_id required: false schema: type: string rowFilter.work_requests_expanded.assigned_worker_id: in: query name: assigned_worker_id required: false schema: type: string rowFilter.work_requests_expanded.assigned_worker_name: in: query name: assigned_worker_name required: false schema: type: string rowFilter.work_requests_expanded.assigned_team_id: in: query name: assigned_team_id required: false schema: type: string rowFilter.work_requests_expanded.assigned_team_name: in: query name: assigned_team_name required: false schema: type: string rowFilter.work_requests_expanded.assigned_vendor_id: in: query name: assigned_vendor_id required: false schema: type: string rowFilter.work_requests_expanded.assigned_vendor_name: in: query name: assigned_vendor_name required: false schema: type: string rowFilter.work_requests_expanded.cc: in: query name: cc required: false schema: type: string rowFilter.work_requests_expanded.work_order_id: in: query name: work_order_id required: false schema: type: string rowFilter.work_requests_expanded.work_order_number: in: query name: work_order_number required: false schema: type: string rowFilter.work_requests_expanded.primary_image_file_id: in: query name: primary_image_file_id required: false schema: type: string rowFilter.work_requests_expanded.asset_image_file_id: in: query name: asset_image_file_id required: false schema: type: string rowFilter.work_requests_expanded.custom_fields: in: query name: custom_fields required: false schema: type: string rowFilter.work_requests_expanded.pending_approval_request_id: in: query name: pending_approval_request_id required: false schema: type: string rowFilter.work_requests_expanded.row_version: in: query name: row_version required: false schema: type: string rowFilter.work_requests_expanded.created_at: in: query name: created_at required: false schema: type: string rowFilter.work_requests_expanded.created_by_id: in: query name: created_by_id required: false schema: type: string rowFilter.work_requests_expanded.created_by_name: in: query name: created_by_name required: false schema: type: string rowFilter.work_requests_expanded.created_source: in: query name: created_source required: false schema: type: string rowFilter.work_requests_expanded.updated_at: in: query name: updated_at required: false schema: type: string rowFilter.work_requests_expanded.updated_by_id: in: query name: updated_by_id required: false schema: type: string rowFilter.work_requests_expanded.updated_by_name: in: query name: updated_by_name required: false schema: type: string rowFilter.work_requests_expanded.asset__asset_number: in: query name: asset__asset_number required: false schema: type: string rowFilter.work_requests_expanded.asset__name: in: query name: asset__name required: false schema: type: string rowFilter.work_requests_expanded.asset__serial_number: in: query name: asset__serial_number required: false schema: type: string rowFilter.work_requests_expanded.asset__asset_category_code: in: query name: asset__asset_category_code required: false schema: type: string rowFilter.work_requests_expanded.asset__asset_category: in: query name: asset__asset_category required: false schema: type: string rowFilter.work_requests_expanded.asset__asset_category_ancestor_ids: in: query name: asset__asset_category_ancestor_ids required: false schema: type: string rowFilter.work_requests_expanded.asset__asset_category_path: in: query name: asset__asset_category_path required: false schema: type: string rowFilter.work_requests_expanded.asset__asset_category_root_code: in: query name: asset__asset_category_root_code required: false schema: type: string rowFilter.work_requests_expanded.asset__asset_category_root: in: query name: asset__asset_category_root required: false schema: type: string rowFilter.work_requests_expanded.asset__asset_class_code: in: query name: asset__asset_class_code required: false schema: type: string rowFilter.work_requests_expanded.asset__asset_class: in: query name: asset__asset_class required: false schema: type: string rowFilter.work_requests_expanded.asset__asset_class_is_default: in: query name: asset__asset_class_is_default required: false schema: type: string rowFilter.work_requests_expanded.asset__status: in: query name: asset__status required: false schema: type: string rowFilter.work_requests_expanded.asset__status_label: in: query name: asset__status_label required: false schema: type: string rowFilter.work_requests_expanded.asset__status_category: in: query name: asset__status_category required: false schema: type: string rowFilter.work_requests_expanded.asset__criticality: in: query name: asset__criticality required: false schema: type: string rowFilter.work_requests_expanded.asset__criticality_rank: in: query name: asset__criticality_rank required: false schema: type: string rowFilter.work_requests_expanded.asset__criticality_response_minutes: in: query name: asset__criticality_response_minutes required: false schema: type: string rowFilter.work_requests_expanded.asset__site_code: in: query name: asset__site_code required: false schema: type: string rowFilter.work_requests_expanded.asset__site_name: in: query name: asset__site_name required: false schema: type: string rowFilter.work_requests_expanded.asset__location_name: in: query name: asset__location_name required: false schema: type: string rowFilter.work_requests_expanded.asset__latitude: in: query name: asset__latitude required: false schema: type: string rowFilter.work_requests_expanded.asset__longitude: in: query name: asset__longitude required: false schema: type: string rowFilter.work_requests_expanded.asset__parent_asset_number: in: query name: asset__parent_asset_number required: false schema: type: string rowFilter.work_requests_expanded.asset__manufacturer: in: query name: asset__manufacturer required: false schema: type: string rowFilter.work_requests_expanded.asset__model_code: in: query name: asset__model_code required: false schema: type: string rowFilter.work_requests_expanded.asset__model_name: in: query name: asset__model_name required: false schema: type: string rowFilter.work_requests_expanded.asset__purchase_date: in: query name: asset__purchase_date required: false schema: type: string rowFilter.work_requests_expanded.asset__installation_date: in: query name: asset__installation_date required: false schema: type: string rowFilter.work_requests_expanded.asset__commissioning_date: in: query name: asset__commissioning_date required: false schema: type: string rowFilter.work_requests_expanded.asset__warranty_expires_on: in: query name: asset__warranty_expires_on required: false schema: type: string rowFilter.work_requests_expanded.asset__health_score: in: query name: asset__health_score required: false schema: type: string rowFilter.work_requests_expanded.asset__is_retired: in: query name: asset__is_retired required: false schema: type: string rowFilter.work_requests_expanded.asset__custodian: in: query name: asset__custodian required: false schema: type: string rowFilter.work_requests_expanded.asset__custodian_email: in: query name: asset__custodian_email required: false schema: type: string rowFilter.work_requests_expanded.asset__custody_since: in: query name: asset__custody_since required: false schema: type: string rowFilter.work_requests_expanded.asset__custom_fields: in: query name: asset__custom_fields required: false schema: type: string rowFilter.work_requests_expanded.asset__created_at: in: query name: asset__created_at required: false schema: type: string rowFilter.work_requests_expanded.asset__created_by_name: in: query name: asset__created_by_name required: false schema: type: string rowFilter.work_requests_expanded.asset__updated_at: in: query name: asset__updated_at required: false schema: type: string rowFilter.work_requests_expanded.asset__updated_by_name: in: query name: asset__updated_by_name required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__request_number: in: query name: duplicate_of__request_number required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__summary: in: query name: duplicate_of__summary required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__description: in: query name: duplicate_of__description required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__status: in: query name: duplicate_of__status required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__status_label: in: query name: duplicate_of__status_label required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__status_category: in: query name: duplicate_of__status_category required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__source: in: query name: duplicate_of__source required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__category: in: query name: duplicate_of__category required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__category_name: in: query name: duplicate_of__category_name required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__reported_severity: in: query name: duplicate_of__reported_severity required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__severity_rank: in: query name: duplicate_of__severity_rank required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__suggested_priority_code: in: query name: duplicate_of__suggested_priority_code required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__suggested_priority_name: in: query name: duplicate_of__suggested_priority_name required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__asset_number: in: query name: duplicate_of__asset_number required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__asset_name: in: query name: duplicate_of__asset_name required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__requester_name: in: query name: duplicate_of__requester_name required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__discovered_at: in: query name: duplicate_of__discovered_at required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__triaged_at: in: query name: duplicate_of__triaged_at required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__rejection_reason: in: query name: duplicate_of__rejection_reason required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__assigned_worker_name: in: query name: duplicate_of__assigned_worker_name required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__assigned_team_name: in: query name: duplicate_of__assigned_team_name required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__assigned_vendor_name: in: query name: duplicate_of__assigned_vendor_name required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__cc: in: query name: duplicate_of__cc required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__work_order_number: in: query name: duplicate_of__work_order_number required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__custom_fields: in: query name: duplicate_of__custom_fields required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__created_at: in: query name: duplicate_of__created_at required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__created_by_name: in: query name: duplicate_of__created_by_name required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__updated_at: in: query name: duplicate_of__updated_at required: false schema: type: string rowFilter.work_requests_expanded.duplicate_of__updated_by_name: in: query name: duplicate_of__updated_by_name required: false schema: type: string rowFilter.work_requests_expanded.location__site_code: in: query name: location__site_code required: false schema: type: string rowFilter.work_requests_expanded.location__parent_name: in: query name: location__parent_name required: false schema: type: string rowFilter.work_requests_expanded.location__location_type: in: query name: location__location_type required: false schema: type: string rowFilter.work_requests_expanded.location__level_hint: in: query name: location__level_hint required: false schema: type: string rowFilter.work_requests_expanded.location__code: in: query name: location__code required: false schema: type: string rowFilter.work_requests_expanded.location__name: in: query name: location__name required: false schema: type: string rowFilter.work_requests_expanded.location__path: in: query name: location__path required: false schema: type: string rowFilter.work_requests_expanded.location__depth: in: query name: location__depth required: false schema: type: string rowFilter.work_requests_expanded.location__latitude: in: query name: location__latitude required: false schema: type: string rowFilter.work_requests_expanded.location__longitude: in: query name: location__longitude required: false schema: type: string rowFilter.work_requests_expanded.location__is_active: in: query name: location__is_active required: false schema: type: string rowFilter.work_requests_expanded.location__allows_direct_filing: in: query name: location__allows_direct_filing required: false schema: type: string rowFilter.work_requests_expanded.location__takes_filing: in: query name: location__takes_filing required: false schema: type: string rowFilter.work_requests_expanded.location__primary_location_head_name: in: query name: location__primary_location_head_name required: false schema: type: string rowFilter.work_requests_expanded.location__alternate_location_heads: in: query name: location__alternate_location_heads required: false schema: type: string rowFilter.work_requests_expanded.location__children: in: query name: location__children required: false schema: type: string rowFilter.work_requests_expanded.location__assets: in: query name: location__assets required: false schema: type: string rowFilter.work_requests_expanded.location__assets_in_branch: in: query name: location__assets_in_branch required: false schema: type: string rowFilter.work_requests_expanded.requested_by__email: in: query name: requested_by__email required: false schema: type: string rowFilter.work_requests_expanded.requested_by__username: in: query name: requested_by__username required: false schema: type: string rowFilter.work_requests_expanded.requested_by__sign_in_handle: in: query name: requested_by__sign_in_handle required: false schema: type: string rowFilter.work_requests_expanded.requested_by__name: in: query name: requested_by__name required: false schema: type: string rowFilter.work_requests_expanded.requested_by__phone: in: query name: requested_by__phone required: false schema: type: string rowFilter.work_requests_expanded.requested_by__status: in: query name: requested_by__status required: false schema: type: string rowFilter.work_requests_expanded.requested_by__last_login_at: in: query name: requested_by__last_login_at required: false schema: type: string rowFilter.work_requests_expanded.requested_by__worker_number: in: query name: requested_by__worker_number required: false schema: type: string rowFilter.work_requests_expanded.requested_by__worker_name: in: query name: requested_by__worker_name required: false schema: type: string rowFilter.work_requests_expanded.requested_by__worker_type: in: query name: requested_by__worker_type required: false schema: type: string rowFilter.work_requests_expanded.requested_by__worker_is_active: in: query name: requested_by__worker_is_active required: false schema: type: string rowFilter.work_requests_expanded.requested_by__worker_teams: in: query name: requested_by__worker_teams required: false schema: type: string rowFilter.work_requests_expanded.site__code: in: query name: site__code required: false schema: type: string rowFilter.work_requests_expanded.site__name: in: query name: site__name required: false schema: type: string rowFilter.work_requests_expanded.site__timezone: in: query name: site__timezone required: false schema: type: string rowFilter.work_requests_expanded.site__is_active: in: query name: site__is_active required: false schema: type: string rowFilter.work_requests_expanded.site__company_name: in: query name: site__company_name required: false schema: type: string rowFilter.work_requests_expanded.site__business_unit_name: in: query name: site__business_unit_name required: false schema: type: string rowFilter.work_requests_expanded.site__business_unit_parent_name: in: query name: site__business_unit_parent_name required: false schema: type: string rowFilter.work_requests_expanded.site__asset_count: in: query name: site__asset_count required: false schema: type: string rowFilter.work_requests_expanded.triaged_by__email: in: query name: triaged_by__email required: false schema: type: string rowFilter.work_requests_expanded.triaged_by__username: in: query name: triaged_by__username required: false schema: type: string rowFilter.work_requests_expanded.triaged_by__sign_in_handle: in: query name: triaged_by__sign_in_handle required: false schema: type: string rowFilter.work_requests_expanded.triaged_by__name: in: query name: triaged_by__name required: false schema: type: string rowFilter.work_requests_expanded.triaged_by__phone: in: query name: triaged_by__phone required: false schema: type: string rowFilter.work_requests_expanded.triaged_by__status: in: query name: triaged_by__status required: false schema: type: string rowFilter.work_requests_expanded.triaged_by__last_login_at: in: query name: triaged_by__last_login_at required: false schema: type: string rowFilter.work_requests_expanded.triaged_by__worker_number: in: query name: triaged_by__worker_number required: false schema: type: string rowFilter.work_requests_expanded.triaged_by__worker_name: in: query name: triaged_by__worker_name required: false schema: type: string rowFilter.work_requests_expanded.triaged_by__worker_type: in: query name: triaged_by__worker_type required: false schema: type: string rowFilter.work_requests_expanded.triaged_by__worker_is_active: in: query name: triaged_by__worker_is_active required: false schema: type: string rowFilter.work_requests_expanded.triaged_by__worker_teams: in: query name: triaged_by__worker_teams required: false schema: type: string rowFilter.work_requests_expanded.reference_records: in: query name: reference_records 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_requests_expanded: description: >- Work requests with every field of the records each row points at: asset, duplicate of, location, requested by, site, triaged by. 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: asset__asset_category: format: character varying maxLength: 200 type: string asset__asset_category_ancestor_ids: format: uuid[] items: type: string type: array asset__asset_category_code: format: character varying maxLength: 60 type: string asset__asset_category_path: format: text type: string asset__asset_category_root: format: character varying maxLength: 200 type: string asset__asset_category_root_code: format: character varying maxLength: 60 type: string asset__asset_class: format: character varying type: string asset__asset_class_code: format: character varying type: string asset__asset_class_is_default: format: boolean type: boolean asset__asset_number: format: character varying maxLength: 80 type: string asset__commissioning_date: format: date type: string asset__created_at: format: timestamp with time zone type: string asset__created_by_name: format: character varying maxLength: 200 type: string asset__criticality: format: character varying maxLength: 40 type: string asset__criticality_rank: format: smallint type: integer asset__criticality_response_minutes: format: integer type: integer asset__custodian: format: character varying type: string asset__custodian_email: format: public.citext type: string asset__custody_since: format: date type: string asset__custom_fields: format: jsonb asset__health_score: format: numeric type: number asset__installation_date: format: date type: string asset__is_retired: format: boolean type: boolean asset__latitude: format: numeric type: number asset__location_name: format: character varying maxLength: 200 type: string asset__longitude: format: numeric type: number asset__manufacturer: format: character varying maxLength: 200 type: string asset__model_code: format: character varying maxLength: 80 type: string asset__model_name: format: character varying maxLength: 200 type: string asset__name: format: character varying maxLength: 250 type: string asset__parent_asset_number: format: character varying maxLength: 80 type: string asset__purchase_date: format: date type: string asset__serial_number: format: character varying maxLength: 120 type: string asset__site_code: format: character varying maxLength: 50 type: string asset__site_name: format: character varying maxLength: 200 type: string asset__status: format: character varying maxLength: 60 type: string asset__status_category: format: character varying maxLength: 20 type: string asset__status_label: format: text type: string asset__updated_at: format: timestamp with time zone type: string asset__updated_by_name: format: character varying maxLength: 200 type: string asset__warranty_expires_on: format: date type: string asset_id: description: >- Note: This is a Foreign Key to `asset_contracts.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_team_id: description: |- Note: This is a Foreign Key to `teams.id`. format: uuid type: string assigned_team_name: format: character varying maxLength: 200 type: string assigned_vendor_id: description: >- Note: This is a Foreign Key to `assignable_vendors.id`. format: uuid type: string assigned_vendor_name: format: character varying maxLength: 200 type: string assigned_worker_id: description: >- Note: This is a Foreign Key to `assignable_workers.id`. format: uuid type: string assigned_worker_name: format: character varying maxLength: 200 type: string category: format: character varying maxLength: 60 type: string category_name: format: character varying maxLength: 200 type: string cc: format: jsonb created_at: format: timestamp with time zone type: string created_by_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string created_by_name: format: character varying maxLength: 200 type: string created_source: format: text type: string custom_fields: format: jsonb description: format: text type: string discovered_at: format: timestamp with time zone type: string duplicate_of__asset_name: format: character varying maxLength: 250 type: string duplicate_of__asset_number: format: character varying maxLength: 80 type: string duplicate_of__assigned_team_name: format: character varying maxLength: 200 type: string duplicate_of__assigned_vendor_name: format: character varying maxLength: 200 type: string duplicate_of__assigned_worker_name: format: character varying maxLength: 200 type: string duplicate_of__category: format: character varying maxLength: 60 type: string duplicate_of__category_name: format: character varying maxLength: 200 type: string duplicate_of__cc: format: jsonb duplicate_of__created_at: format: timestamp with time zone type: string duplicate_of__created_by_name: format: character varying maxLength: 200 type: string duplicate_of__custom_fields: format: jsonb duplicate_of__description: format: text type: string duplicate_of__discovered_at: format: timestamp with time zone type: string duplicate_of__rejection_reason: format: text type: string duplicate_of__reported_severity: format: character varying maxLength: 20 type: string duplicate_of__request_number: format: character varying maxLength: 60 type: string duplicate_of__requester_name: format: character varying maxLength: 200 type: string duplicate_of__severity_rank: format: integer type: integer duplicate_of__source: format: character varying maxLength: 40 type: string duplicate_of__status: format: character varying maxLength: 60 type: string duplicate_of__status_category: format: character varying maxLength: 20 type: string duplicate_of__status_label: format: text type: string duplicate_of__suggested_priority_code: format: character varying maxLength: 40 type: string duplicate_of__suggested_priority_name: format: character varying maxLength: 150 type: string duplicate_of__summary: format: character varying maxLength: 250 type: string duplicate_of__triaged_at: format: timestamp with time zone type: string duplicate_of__updated_at: format: timestamp with time zone type: string duplicate_of__updated_by_name: format: character varying maxLength: 200 type: string duplicate_of__work_order_number: format: character varying maxLength: 60 type: string duplicate_of_work_request_id: description: >- Note: This is a Foreign Key to `work_requests.id`. format: uuid type: string id: description: |- Note: This is a Primary Key. format: uuid type: string location__allows_direct_filing: format: boolean type: boolean location__alternate_location_heads: format: jsonb location__assets: format: bigint type: integer location__assets_in_branch: format: bigint type: integer location__children: format: bigint type: integer location__code: format: character varying maxLength: 80 type: string location__depth: format: smallint type: integer location__is_active: format: boolean type: boolean location__latitude: format: numeric type: number location__level_hint: format: smallint type: integer location__location_type: format: character varying maxLength: 150 type: string location__longitude: format: numeric type: number location__name: format: character varying maxLength: 200 type: string location__parent_name: format: character varying maxLength: 200 type: string location__path: format: text type: string location__primary_location_head_name: format: character varying maxLength: 200 type: string location__site_code: format: character varying maxLength: 50 type: string location__takes_filing: format: boolean type: boolean location_id: description: >- Note: This is a Foreign Key to `location_settings.id`. format: uuid type: string pending_approval_request_id: format: uuid type: string primary_image_file_id: format: uuid type: string reference_records: format: jsonb rejection_reason: format: text type: string reported_severity: format: character varying maxLength: 20 type: string request_number: format: character varying maxLength: 60 type: string requested_by__email: format: public.citext type: string requested_by__last_login_at: format: timestamp with time zone type: string requested_by__name: format: character varying maxLength: 200 type: string requested_by__phone: format: character varying maxLength: 40 type: string requested_by__sign_in_handle: format: text type: string requested_by__status: format: character varying maxLength: 30 type: string requested_by__username: format: public.citext type: string requested_by__worker_is_active: format: boolean type: boolean requested_by__worker_name: format: character varying maxLength: 200 type: string requested_by__worker_number: format: character varying maxLength: 60 type: string requested_by__worker_teams: format: jsonb requested_by__worker_type: format: character varying maxLength: 150 type: string requested_by_user_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string requester_name: format: character varying maxLength: 200 type: string row_version: format: bigint type: integer severity_rank: format: integer type: integer site__asset_count: format: bigint type: integer site__business_unit_name: format: character varying maxLength: 200 type: string site__business_unit_parent_name: format: character varying maxLength: 200 type: string site__code: format: character varying maxLength: 50 type: string site__company_name: format: character varying maxLength: 200 type: string site__is_active: format: boolean type: boolean site__name: format: character varying maxLength: 200 type: string site__timezone: format: character varying maxLength: 100 type: string site_id: description: >- Note: This is a Foreign Key to `entry_currencies.for_site_id`. format: uuid type: string source: format: character varying maxLength: 40 type: string status: format: character varying maxLength: 60 type: string status_category: format: character varying maxLength: 20 type: string status_label: format: text type: string suggested_priority_code: format: character varying maxLength: 40 type: string suggested_priority_name: format: character varying maxLength: 150 type: string suggested_work_order_priority_id: description: >- Note: This is a Foreign Key to `request_severity_priorities.work_order_priority_id`. format: uuid type: string summary: format: character varying maxLength: 250 type: string triaged_at: format: timestamp with time zone type: string triaged_by__email: format: public.citext type: string triaged_by__last_login_at: format: timestamp with time zone type: string triaged_by__name: format: character varying maxLength: 200 type: string triaged_by__phone: format: character varying maxLength: 40 type: string triaged_by__sign_in_handle: format: text type: string triaged_by__status: format: character varying maxLength: 30 type: string triaged_by__username: format: public.citext type: string triaged_by__worker_is_active: format: boolean type: boolean triaged_by__worker_name: format: character varying maxLength: 200 type: string triaged_by__worker_number: format: character varying maxLength: 60 type: string triaged_by__worker_teams: format: jsonb triaged_by__worker_type: format: character varying maxLength: 150 type: string updated_at: format: timestamp with time zone type: string updated_by_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string updated_by_name: format: character varying maxLength: 200 type: string work_order_id: format: uuid type: string work_order_number: format: character varying maxLength: 60 type: string work_request_category_id: description: >- Note: This is a Foreign Key to `request_category_settings.id`. format: uuid type: string type: object ````