> ## 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. # Assets with every field of the records each row points at: custodian, department, location, manufacturer, model, parent asset, site. > 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 /assets_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: /assets_expanded: get: tags: - assets_expanded summary: >- Assets with every field of the records each row points at: custodian, department, location, manufacturer, model, parent asset, site. 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.assets_expanded.id' - $ref: '#/components/parameters/rowFilter.assets_expanded.asset_number' - $ref: '#/components/parameters/rowFilter.assets_expanded.name' - $ref: '#/components/parameters/rowFilter.assets_expanded.serial_number' - $ref: '#/components/parameters/rowFilter.assets_expanded.asset_category_id' - $ref: >- #/components/parameters/rowFilter.assets_expanded.asset_category_code - $ref: '#/components/parameters/rowFilter.assets_expanded.asset_category' - $ref: >- #/components/parameters/rowFilter.assets_expanded.asset_category_ancestor_ids - $ref: >- #/components/parameters/rowFilter.assets_expanded.asset_category_path - $ref: >- #/components/parameters/rowFilter.assets_expanded.asset_category_root_code - $ref: >- #/components/parameters/rowFilter.assets_expanded.asset_category_root - $ref: '#/components/parameters/rowFilter.assets_expanded.asset_class_id' - $ref: '#/components/parameters/rowFilter.assets_expanded.asset_class_code' - $ref: '#/components/parameters/rowFilter.assets_expanded.asset_class' - $ref: >- #/components/parameters/rowFilter.assets_expanded.asset_class_is_default - $ref: '#/components/parameters/rowFilter.assets_expanded.status' - $ref: '#/components/parameters/rowFilter.assets_expanded.status_label' - $ref: '#/components/parameters/rowFilter.assets_expanded.status_category' - $ref: '#/components/parameters/rowFilter.assets_expanded.criticality' - $ref: '#/components/parameters/rowFilter.assets_expanded.criticality_rank' - $ref: >- #/components/parameters/rowFilter.assets_expanded.criticality_response_minutes - $ref: '#/components/parameters/rowFilter.assets_expanded.site_id' - $ref: '#/components/parameters/rowFilter.assets_expanded.site_code' - $ref: '#/components/parameters/rowFilter.assets_expanded.site_name' - $ref: '#/components/parameters/rowFilter.assets_expanded.location_id' - $ref: '#/components/parameters/rowFilter.assets_expanded.location_name' - $ref: '#/components/parameters/rowFilter.assets_expanded.latitude' - $ref: '#/components/parameters/rowFilter.assets_expanded.longitude' - $ref: '#/components/parameters/rowFilter.assets_expanded.parent_asset_id' - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset_number - $ref: '#/components/parameters/rowFilter.assets_expanded.manufacturer' - $ref: '#/components/parameters/rowFilter.assets_expanded.model_code' - $ref: '#/components/parameters/rowFilter.assets_expanded.model_name' - $ref: '#/components/parameters/rowFilter.assets_expanded.purchase_date' - $ref: '#/components/parameters/rowFilter.assets_expanded.installation_date' - $ref: '#/components/parameters/rowFilter.assets_expanded.commissioning_date' - $ref: >- #/components/parameters/rowFilter.assets_expanded.warranty_expires_on - $ref: '#/components/parameters/rowFilter.assets_expanded.health_score' - $ref: '#/components/parameters/rowFilter.assets_expanded.is_retired' - $ref: '#/components/parameters/rowFilter.assets_expanded.custodian_user_id' - $ref: '#/components/parameters/rowFilter.assets_expanded.custodian' - $ref: '#/components/parameters/rowFilter.assets_expanded.custodian_email' - $ref: '#/components/parameters/rowFilter.assets_expanded.custody_since' - $ref: >- #/components/parameters/rowFilter.assets_expanded.primary_image_file_id - $ref: '#/components/parameters/rowFilter.assets_expanded.custom_fields' - $ref: '#/components/parameters/rowFilter.assets_expanded.row_version' - $ref: '#/components/parameters/rowFilter.assets_expanded.created_at' - $ref: '#/components/parameters/rowFilter.assets_expanded.created_by_id' - $ref: '#/components/parameters/rowFilter.assets_expanded.created_by_name' - $ref: '#/components/parameters/rowFilter.assets_expanded.created_source' - $ref: '#/components/parameters/rowFilter.assets_expanded.updated_at' - $ref: '#/components/parameters/rowFilter.assets_expanded.updated_by_id' - $ref: '#/components/parameters/rowFilter.assets_expanded.updated_by_name' - $ref: '#/components/parameters/rowFilter.assets_expanded.search_text' - $ref: '#/components/parameters/rowFilter.assets_expanded.custom_text' - $ref: '#/components/parameters/rowFilter.assets_expanded.search_all' - $ref: '#/components/parameters/rowFilter.assets_expanded.custodian__email' - $ref: >- #/components/parameters/rowFilter.assets_expanded.custodian__username - $ref: >- #/components/parameters/rowFilter.assets_expanded.custodian__sign_in_handle - $ref: '#/components/parameters/rowFilter.assets_expanded.custodian__name' - $ref: '#/components/parameters/rowFilter.assets_expanded.custodian__phone' - $ref: '#/components/parameters/rowFilter.assets_expanded.custodian__status' - $ref: >- #/components/parameters/rowFilter.assets_expanded.custodian__last_login_at - $ref: >- #/components/parameters/rowFilter.assets_expanded.custodian__worker_number - $ref: >- #/components/parameters/rowFilter.assets_expanded.custodian__worker_name - $ref: >- #/components/parameters/rowFilter.assets_expanded.custodian__worker_type - $ref: >- #/components/parameters/rowFilter.assets_expanded.custodian__worker_is_active - $ref: >- #/components/parameters/rowFilter.assets_expanded.custodian__worker_teams - $ref: '#/components/parameters/rowFilter.assets_expanded.department__code' - $ref: '#/components/parameters/rowFilter.assets_expanded.department__name' - $ref: >- #/components/parameters/rowFilter.assets_expanded.department__business_unit_name - $ref: >- #/components/parameters/rowFilter.assets_expanded.department__cost_centre_name - $ref: >- #/components/parameters/rowFilter.assets_expanded.department__manager_name - $ref: >- #/components/parameters/rowFilter.assets_expanded.department__maintenance_manager_name - $ref: >- #/components/parameters/rowFilter.assets_expanded.department__is_active - $ref: >- #/components/parameters/rowFilter.assets_expanded.department__workers - $ref: '#/components/parameters/rowFilter.assets_expanded.department__assets' - $ref: >- #/components/parameters/rowFilter.assets_expanded.location__site_code - $ref: >- #/components/parameters/rowFilter.assets_expanded.location__parent_name - $ref: >- #/components/parameters/rowFilter.assets_expanded.location__location_type - $ref: >- #/components/parameters/rowFilter.assets_expanded.location__level_hint - $ref: '#/components/parameters/rowFilter.assets_expanded.location__code' - $ref: '#/components/parameters/rowFilter.assets_expanded.location__name' - $ref: '#/components/parameters/rowFilter.assets_expanded.location__path' - $ref: '#/components/parameters/rowFilter.assets_expanded.location__depth' - $ref: '#/components/parameters/rowFilter.assets_expanded.location__latitude' - $ref: >- #/components/parameters/rowFilter.assets_expanded.location__longitude - $ref: >- #/components/parameters/rowFilter.assets_expanded.location__is_active - $ref: >- #/components/parameters/rowFilter.assets_expanded.location__allows_direct_filing - $ref: >- #/components/parameters/rowFilter.assets_expanded.location__takes_filing - $ref: >- #/components/parameters/rowFilter.assets_expanded.location__primary_location_head_name - $ref: >- #/components/parameters/rowFilter.assets_expanded.location__alternate_location_heads - $ref: '#/components/parameters/rowFilter.assets_expanded.location__children' - $ref: '#/components/parameters/rowFilter.assets_expanded.location__assets' - $ref: >- #/components/parameters/rowFilter.assets_expanded.location__assets_in_branch - $ref: '#/components/parameters/rowFilter.assets_expanded.manufacturer__code' - $ref: '#/components/parameters/rowFilter.assets_expanded.manufacturer__name' - $ref: >- #/components/parameters/rowFilter.assets_expanded.manufacturer__website - $ref: >- #/components/parameters/rowFilter.assets_expanded.manufacturer__support_email - $ref: >- #/components/parameters/rowFilter.assets_expanded.manufacturer__support_phone - $ref: >- #/components/parameters/rowFilter.assets_expanded.manufacturer__is_active - $ref: >- #/components/parameters/rowFilter.assets_expanded.manufacturer__models - $ref: >- #/components/parameters/rowFilter.assets_expanded.manufacturer__assets - $ref: >- #/components/parameters/rowFilter.assets_expanded.model__manufacturer_name - $ref: >- #/components/parameters/rowFilter.assets_expanded.model__asset_category_name - $ref: '#/components/parameters/rowFilter.assets_expanded.model__code' - $ref: '#/components/parameters/rowFilter.assets_expanded.model__name' - $ref: >- #/components/parameters/rowFilter.assets_expanded.model__expected_life_months - $ref: >- #/components/parameters/rowFilter.assets_expanded.model__specifications - $ref: '#/components/parameters/rowFilter.assets_expanded.model__is_active' - $ref: '#/components/parameters/rowFilter.assets_expanded.model__assets' - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__asset_number - $ref: '#/components/parameters/rowFilter.assets_expanded.parent_asset__name' - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__serial_number - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__asset_category_code - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__asset_category - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__asset_category_ancestor_ids - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__asset_category_path - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__asset_category_root_code - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__asset_category_root - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__asset_class_code - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__asset_class - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__asset_class_is_default - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__status - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__status_label - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__status_category - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__criticality - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__criticality_rank - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__criticality_response_minutes - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__site_code - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__site_name - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__location_name - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__latitude - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__longitude - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__parent_asset_number - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__manufacturer - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__model_code - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__model_name - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__purchase_date - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__installation_date - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__commissioning_date - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__warranty_expires_on - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__health_score - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__is_retired - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__custodian - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__custodian_email - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__custody_since - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__custom_fields - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__created_at - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__created_by_name - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__updated_at - $ref: >- #/components/parameters/rowFilter.assets_expanded.parent_asset__updated_by_name - $ref: '#/components/parameters/rowFilter.assets_expanded.site__code' - $ref: '#/components/parameters/rowFilter.assets_expanded.site__name' - $ref: '#/components/parameters/rowFilter.assets_expanded.site__timezone' - $ref: '#/components/parameters/rowFilter.assets_expanded.site__is_active' - $ref: '#/components/parameters/rowFilter.assets_expanded.site__company_name' - $ref: >- #/components/parameters/rowFilter.assets_expanded.site__business_unit_name - $ref: >- #/components/parameters/rowFilter.assets_expanded.site__business_unit_parent_name - $ref: '#/components/parameters/rowFilter.assets_expanded.site__asset_count' - $ref: '#/components/parameters/rowFilter.assets_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/assets_expanded' type: array application/vnd.pgrst.object+json: schema: items: $ref: '#/components/schemas/assets_expanded' type: array application/vnd.pgrst.object+json;nulls=stripped: schema: items: $ref: '#/components/schemas/assets_expanded' type: array text/csv: schema: items: $ref: '#/components/schemas/assets_expanded' type: array description: OK '206': description: Partial Content components: parameters: rowFilter.assets_expanded.id: in: query name: id required: false schema: type: string rowFilter.assets_expanded.asset_number: in: query name: asset_number required: false schema: type: string rowFilter.assets_expanded.name: in: query name: name required: false schema: type: string rowFilter.assets_expanded.serial_number: in: query name: serial_number required: false schema: type: string rowFilter.assets_expanded.asset_category_id: in: query name: asset_category_id required: false schema: type: string rowFilter.assets_expanded.asset_category_code: in: query name: asset_category_code required: false schema: type: string rowFilter.assets_expanded.asset_category: in: query name: asset_category required: false schema: type: string rowFilter.assets_expanded.asset_category_ancestor_ids: in: query name: asset_category_ancestor_ids required: false schema: type: string rowFilter.assets_expanded.asset_category_path: in: query name: asset_category_path required: false schema: type: string rowFilter.assets_expanded.asset_category_root_code: in: query name: asset_category_root_code required: false schema: type: string rowFilter.assets_expanded.asset_category_root: in: query name: asset_category_root required: false schema: type: string rowFilter.assets_expanded.asset_class_id: in: query name: asset_class_id required: false schema: type: string rowFilter.assets_expanded.asset_class_code: in: query name: asset_class_code required: false schema: type: string rowFilter.assets_expanded.asset_class: in: query name: asset_class required: false schema: type: string rowFilter.assets_expanded.asset_class_is_default: in: query name: asset_class_is_default required: false schema: type: string rowFilter.assets_expanded.status: in: query name: status required: false schema: type: string rowFilter.assets_expanded.status_label: in: query name: status_label required: false schema: type: string rowFilter.assets_expanded.status_category: in: query name: status_category required: false schema: type: string rowFilter.assets_expanded.criticality: in: query name: criticality required: false schema: type: string rowFilter.assets_expanded.criticality_rank: in: query name: criticality_rank required: false schema: type: string rowFilter.assets_expanded.criticality_response_minutes: in: query name: criticality_response_minutes required: false schema: type: string rowFilter.assets_expanded.site_id: in: query name: site_id required: false schema: type: string rowFilter.assets_expanded.site_code: in: query name: site_code required: false schema: type: string rowFilter.assets_expanded.site_name: in: query name: site_name required: false schema: type: string rowFilter.assets_expanded.location_id: in: query name: location_id required: false schema: type: string rowFilter.assets_expanded.location_name: in: query name: location_name required: false schema: type: string rowFilter.assets_expanded.latitude: in: query name: latitude required: false schema: type: string rowFilter.assets_expanded.longitude: in: query name: longitude required: false schema: type: string rowFilter.assets_expanded.parent_asset_id: in: query name: parent_asset_id required: false schema: type: string rowFilter.assets_expanded.parent_asset_number: in: query name: parent_asset_number required: false schema: type: string rowFilter.assets_expanded.manufacturer: in: query name: manufacturer required: false schema: type: string rowFilter.assets_expanded.model_code: in: query name: model_code required: false schema: type: string rowFilter.assets_expanded.model_name: in: query name: model_name required: false schema: type: string rowFilter.assets_expanded.purchase_date: in: query name: purchase_date required: false schema: type: string rowFilter.assets_expanded.installation_date: in: query name: installation_date required: false schema: type: string rowFilter.assets_expanded.commissioning_date: in: query name: commissioning_date required: false schema: type: string rowFilter.assets_expanded.warranty_expires_on: in: query name: warranty_expires_on required: false schema: type: string rowFilter.assets_expanded.health_score: in: query name: health_score required: false schema: type: string rowFilter.assets_expanded.is_retired: in: query name: is_retired required: false schema: type: string rowFilter.assets_expanded.custodian_user_id: in: query name: custodian_user_id required: false schema: type: string rowFilter.assets_expanded.custodian: in: query name: custodian required: false schema: type: string rowFilter.assets_expanded.custodian_email: in: query name: custodian_email required: false schema: type: string rowFilter.assets_expanded.custody_since: in: query name: custody_since required: false schema: type: string rowFilter.assets_expanded.primary_image_file_id: in: query name: primary_image_file_id required: false schema: type: string rowFilter.assets_expanded.custom_fields: in: query name: custom_fields required: false schema: type: string rowFilter.assets_expanded.row_version: in: query name: row_version required: false schema: type: string rowFilter.assets_expanded.created_at: in: query name: created_at required: false schema: type: string rowFilter.assets_expanded.created_by_id: in: query name: created_by_id required: false schema: type: string rowFilter.assets_expanded.created_by_name: in: query name: created_by_name required: false schema: type: string rowFilter.assets_expanded.created_source: in: query name: created_source required: false schema: type: string rowFilter.assets_expanded.updated_at: in: query name: updated_at required: false schema: type: string rowFilter.assets_expanded.updated_by_id: in: query name: updated_by_id required: false schema: type: string rowFilter.assets_expanded.updated_by_name: in: query name: updated_by_name required: false schema: type: string rowFilter.assets_expanded.search_text: in: query name: search_text required: false schema: type: string rowFilter.assets_expanded.custom_text: in: query name: custom_text required: false schema: type: string rowFilter.assets_expanded.search_all: in: query name: search_all required: false schema: type: string rowFilter.assets_expanded.custodian__email: in: query name: custodian__email required: false schema: type: string rowFilter.assets_expanded.custodian__username: in: query name: custodian__username required: false schema: type: string rowFilter.assets_expanded.custodian__sign_in_handle: in: query name: custodian__sign_in_handle required: false schema: type: string rowFilter.assets_expanded.custodian__name: in: query name: custodian__name required: false schema: type: string rowFilter.assets_expanded.custodian__phone: in: query name: custodian__phone required: false schema: type: string rowFilter.assets_expanded.custodian__status: in: query name: custodian__status required: false schema: type: string rowFilter.assets_expanded.custodian__last_login_at: in: query name: custodian__last_login_at required: false schema: type: string rowFilter.assets_expanded.custodian__worker_number: in: query name: custodian__worker_number required: false schema: type: string rowFilter.assets_expanded.custodian__worker_name: in: query name: custodian__worker_name required: false schema: type: string rowFilter.assets_expanded.custodian__worker_type: in: query name: custodian__worker_type required: false schema: type: string rowFilter.assets_expanded.custodian__worker_is_active: in: query name: custodian__worker_is_active required: false schema: type: string rowFilter.assets_expanded.custodian__worker_teams: in: query name: custodian__worker_teams required: false schema: type: string rowFilter.assets_expanded.department__code: in: query name: department__code required: false schema: type: string rowFilter.assets_expanded.department__name: in: query name: department__name required: false schema: type: string rowFilter.assets_expanded.department__business_unit_name: in: query name: department__business_unit_name required: false schema: type: string rowFilter.assets_expanded.department__cost_centre_name: in: query name: department__cost_centre_name required: false schema: type: string rowFilter.assets_expanded.department__manager_name: in: query name: department__manager_name required: false schema: type: string rowFilter.assets_expanded.department__maintenance_manager_name: in: query name: department__maintenance_manager_name required: false schema: type: string rowFilter.assets_expanded.department__is_active: in: query name: department__is_active required: false schema: type: string rowFilter.assets_expanded.department__workers: in: query name: department__workers required: false schema: type: string rowFilter.assets_expanded.department__assets: in: query name: department__assets required: false schema: type: string rowFilter.assets_expanded.location__site_code: in: query name: location__site_code required: false schema: type: string rowFilter.assets_expanded.location__parent_name: in: query name: location__parent_name required: false schema: type: string rowFilter.assets_expanded.location__location_type: in: query name: location__location_type required: false schema: type: string rowFilter.assets_expanded.location__level_hint: in: query name: location__level_hint required: false schema: type: string rowFilter.assets_expanded.location__code: in: query name: location__code required: false schema: type: string rowFilter.assets_expanded.location__name: in: query name: location__name required: false schema: type: string rowFilter.assets_expanded.location__path: in: query name: location__path required: false schema: type: string rowFilter.assets_expanded.location__depth: in: query name: location__depth required: false schema: type: string rowFilter.assets_expanded.location__latitude: in: query name: location__latitude required: false schema: type: string rowFilter.assets_expanded.location__longitude: in: query name: location__longitude required: false schema: type: string rowFilter.assets_expanded.location__is_active: in: query name: location__is_active required: false schema: type: string rowFilter.assets_expanded.location__allows_direct_filing: in: query name: location__allows_direct_filing required: false schema: type: string rowFilter.assets_expanded.location__takes_filing: in: query name: location__takes_filing required: false schema: type: string rowFilter.assets_expanded.location__primary_location_head_name: in: query name: location__primary_location_head_name required: false schema: type: string rowFilter.assets_expanded.location__alternate_location_heads: in: query name: location__alternate_location_heads required: false schema: type: string rowFilter.assets_expanded.location__children: in: query name: location__children required: false schema: type: string rowFilter.assets_expanded.location__assets: in: query name: location__assets required: false schema: type: string rowFilter.assets_expanded.location__assets_in_branch: in: query name: location__assets_in_branch required: false schema: type: string rowFilter.assets_expanded.manufacturer__code: in: query name: manufacturer__code required: false schema: type: string rowFilter.assets_expanded.manufacturer__name: in: query name: manufacturer__name required: false schema: type: string rowFilter.assets_expanded.manufacturer__website: in: query name: manufacturer__website required: false schema: type: string rowFilter.assets_expanded.manufacturer__support_email: in: query name: manufacturer__support_email required: false schema: type: string rowFilter.assets_expanded.manufacturer__support_phone: in: query name: manufacturer__support_phone required: false schema: type: string rowFilter.assets_expanded.manufacturer__is_active: in: query name: manufacturer__is_active required: false schema: type: string rowFilter.assets_expanded.manufacturer__models: in: query name: manufacturer__models required: false schema: type: string rowFilter.assets_expanded.manufacturer__assets: in: query name: manufacturer__assets required: false schema: type: string rowFilter.assets_expanded.model__manufacturer_name: in: query name: model__manufacturer_name required: false schema: type: string rowFilter.assets_expanded.model__asset_category_name: in: query name: model__asset_category_name required: false schema: type: string rowFilter.assets_expanded.model__code: in: query name: model__code required: false schema: type: string rowFilter.assets_expanded.model__name: in: query name: model__name required: false schema: type: string rowFilter.assets_expanded.model__expected_life_months: in: query name: model__expected_life_months required: false schema: type: string rowFilter.assets_expanded.model__specifications: in: query name: model__specifications required: false schema: type: string rowFilter.assets_expanded.model__is_active: in: query name: model__is_active required: false schema: type: string rowFilter.assets_expanded.model__assets: in: query name: model__assets required: false schema: type: string rowFilter.assets_expanded.parent_asset__asset_number: in: query name: parent_asset__asset_number required: false schema: type: string rowFilter.assets_expanded.parent_asset__name: in: query name: parent_asset__name required: false schema: type: string rowFilter.assets_expanded.parent_asset__serial_number: in: query name: parent_asset__serial_number required: false schema: type: string rowFilter.assets_expanded.parent_asset__asset_category_code: in: query name: parent_asset__asset_category_code required: false schema: type: string rowFilter.assets_expanded.parent_asset__asset_category: in: query name: parent_asset__asset_category required: false schema: type: string rowFilter.assets_expanded.parent_asset__asset_category_ancestor_ids: in: query name: parent_asset__asset_category_ancestor_ids required: false schema: type: string rowFilter.assets_expanded.parent_asset__asset_category_path: in: query name: parent_asset__asset_category_path required: false schema: type: string rowFilter.assets_expanded.parent_asset__asset_category_root_code: in: query name: parent_asset__asset_category_root_code required: false schema: type: string rowFilter.assets_expanded.parent_asset__asset_category_root: in: query name: parent_asset__asset_category_root required: false schema: type: string rowFilter.assets_expanded.parent_asset__asset_class_code: in: query name: parent_asset__asset_class_code required: false schema: type: string rowFilter.assets_expanded.parent_asset__asset_class: in: query name: parent_asset__asset_class required: false schema: type: string rowFilter.assets_expanded.parent_asset__asset_class_is_default: in: query name: parent_asset__asset_class_is_default required: false schema: type: string rowFilter.assets_expanded.parent_asset__status: in: query name: parent_asset__status required: false schema: type: string rowFilter.assets_expanded.parent_asset__status_label: in: query name: parent_asset__status_label required: false schema: type: string rowFilter.assets_expanded.parent_asset__status_category: in: query name: parent_asset__status_category required: false schema: type: string rowFilter.assets_expanded.parent_asset__criticality: in: query name: parent_asset__criticality required: false schema: type: string rowFilter.assets_expanded.parent_asset__criticality_rank: in: query name: parent_asset__criticality_rank required: false schema: type: string rowFilter.assets_expanded.parent_asset__criticality_response_minutes: in: query name: parent_asset__criticality_response_minutes required: false schema: type: string rowFilter.assets_expanded.parent_asset__site_code: in: query name: parent_asset__site_code required: false schema: type: string rowFilter.assets_expanded.parent_asset__site_name: in: query name: parent_asset__site_name required: false schema: type: string rowFilter.assets_expanded.parent_asset__location_name: in: query name: parent_asset__location_name required: false schema: type: string rowFilter.assets_expanded.parent_asset__latitude: in: query name: parent_asset__latitude required: false schema: type: string rowFilter.assets_expanded.parent_asset__longitude: in: query name: parent_asset__longitude required: false schema: type: string rowFilter.assets_expanded.parent_asset__parent_asset_number: in: query name: parent_asset__parent_asset_number required: false schema: type: string rowFilter.assets_expanded.parent_asset__manufacturer: in: query name: parent_asset__manufacturer required: false schema: type: string rowFilter.assets_expanded.parent_asset__model_code: in: query name: parent_asset__model_code required: false schema: type: string rowFilter.assets_expanded.parent_asset__model_name: in: query name: parent_asset__model_name required: false schema: type: string rowFilter.assets_expanded.parent_asset__purchase_date: in: query name: parent_asset__purchase_date required: false schema: type: string rowFilter.assets_expanded.parent_asset__installation_date: in: query name: parent_asset__installation_date required: false schema: type: string rowFilter.assets_expanded.parent_asset__commissioning_date: in: query name: parent_asset__commissioning_date required: false schema: type: string rowFilter.assets_expanded.parent_asset__warranty_expires_on: in: query name: parent_asset__warranty_expires_on required: false schema: type: string rowFilter.assets_expanded.parent_asset__health_score: in: query name: parent_asset__health_score required: false schema: type: string rowFilter.assets_expanded.parent_asset__is_retired: in: query name: parent_asset__is_retired required: false schema: type: string rowFilter.assets_expanded.parent_asset__custodian: in: query name: parent_asset__custodian required: false schema: type: string rowFilter.assets_expanded.parent_asset__custodian_email: in: query name: parent_asset__custodian_email required: false schema: type: string rowFilter.assets_expanded.parent_asset__custody_since: in: query name: parent_asset__custody_since required: false schema: type: string rowFilter.assets_expanded.parent_asset__custom_fields: in: query name: parent_asset__custom_fields required: false schema: type: string rowFilter.assets_expanded.parent_asset__created_at: in: query name: parent_asset__created_at required: false schema: type: string rowFilter.assets_expanded.parent_asset__created_by_name: in: query name: parent_asset__created_by_name required: false schema: type: string rowFilter.assets_expanded.parent_asset__updated_at: in: query name: parent_asset__updated_at required: false schema: type: string rowFilter.assets_expanded.parent_asset__updated_by_name: in: query name: parent_asset__updated_by_name required: false schema: type: string rowFilter.assets_expanded.site__code: in: query name: site__code required: false schema: type: string rowFilter.assets_expanded.site__name: in: query name: site__name required: false schema: type: string rowFilter.assets_expanded.site__timezone: in: query name: site__timezone required: false schema: type: string rowFilter.assets_expanded.site__is_active: in: query name: site__is_active required: false schema: type: string rowFilter.assets_expanded.site__company_name: in: query name: site__company_name required: false schema: type: string rowFilter.assets_expanded.site__business_unit_name: in: query name: site__business_unit_name required: false schema: type: string rowFilter.assets_expanded.site__business_unit_parent_name: in: query name: site__business_unit_parent_name required: false schema: type: string rowFilter.assets_expanded.site__asset_count: in: query name: site__asset_count required: false schema: type: string rowFilter.assets_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: assets_expanded: description: >- Assets with every field of the records each row points at: custodian, department, location, manufacturer, model, parent asset, site. 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_category: format: character varying maxLength: 200 type: string asset_category_ancestor_ids: format: uuid[] items: type: string type: array asset_category_code: format: character varying maxLength: 60 type: string asset_category_id: description: >- Note: This is a Foreign Key to `asset_categories.id`. format: uuid type: string asset_category_path: format: text type: string asset_category_root: format: character varying maxLength: 200 type: string asset_category_root_code: format: character varying maxLength: 60 type: string asset_class: format: character varying type: string asset_class_code: format: character varying type: string asset_class_id: format: uuid type: string asset_class_is_default: format: boolean type: boolean asset_number: format: character varying maxLength: 80 type: string commissioning_date: format: date type: string 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 criticality: format: character varying maxLength: 40 type: string criticality_rank: format: smallint type: integer criticality_response_minutes: format: integer type: integer custodian: format: character varying type: string custodian__email: format: public.citext type: string custodian__last_login_at: format: timestamp with time zone type: string custodian__name: format: character varying maxLength: 200 type: string custodian__phone: format: character varying maxLength: 40 type: string custodian__sign_in_handle: format: text type: string custodian__status: format: character varying maxLength: 30 type: string custodian__username: format: public.citext type: string custodian__worker_is_active: format: boolean type: boolean custodian__worker_name: format: character varying maxLength: 200 type: string custodian__worker_number: format: character varying maxLength: 60 type: string custodian__worker_teams: format: jsonb custodian__worker_type: format: character varying maxLength: 150 type: string custodian_email: format: public.citext type: string custodian_user_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string custody_since: format: date type: string custom_fields: format: jsonb custom_text: format: text type: string department__assets: format: bigint type: integer department__business_unit_name: format: character varying maxLength: 200 type: string department__code: format: character varying maxLength: 50 type: string department__cost_centre_name: format: character varying maxLength: 200 type: string department__is_active: format: boolean type: boolean department__maintenance_manager_name: format: character varying maxLength: 200 type: string department__manager_name: format: character varying maxLength: 200 type: string department__name: format: character varying maxLength: 200 type: string department__workers: format: bigint type: integer health_score: format: numeric type: number id: description: |- Note: This is a Primary Key. format: uuid type: string installation_date: format: date type: string is_retired: format: boolean type: boolean latitude: format: numeric type: number 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 location_name: format: character varying maxLength: 200 type: string longitude: format: numeric type: number manufacturer: format: character varying maxLength: 200 type: string manufacturer__assets: format: bigint type: integer manufacturer__code: format: character varying maxLength: 60 type: string manufacturer__is_active: format: boolean type: boolean manufacturer__models: format: bigint type: integer manufacturer__name: format: character varying maxLength: 200 type: string manufacturer__support_email: format: public.citext type: string manufacturer__support_phone: format: character varying maxLength: 40 type: string manufacturer__website: format: character varying maxLength: 250 type: string model__asset_category_name: format: character varying maxLength: 200 type: string model__assets: format: bigint type: integer model__code: format: character varying maxLength: 80 type: string model__expected_life_months: format: integer type: integer model__is_active: format: boolean type: boolean model__manufacturer_name: format: character varying maxLength: 200 type: string model__name: format: character varying maxLength: 200 type: string model__specifications: format: jsonb model_code: format: character varying maxLength: 80 type: string model_name: format: character varying maxLength: 200 type: string name: format: character varying maxLength: 250 type: string parent_asset__asset_category: format: character varying maxLength: 200 type: string parent_asset__asset_category_ancestor_ids: format: uuid[] items: type: string type: array parent_asset__asset_category_code: format: character varying maxLength: 60 type: string parent_asset__asset_category_path: format: text type: string parent_asset__asset_category_root: format: character varying maxLength: 200 type: string parent_asset__asset_category_root_code: format: character varying maxLength: 60 type: string parent_asset__asset_class: format: character varying type: string parent_asset__asset_class_code: format: character varying type: string parent_asset__asset_class_is_default: format: boolean type: boolean parent_asset__asset_number: format: character varying maxLength: 80 type: string parent_asset__commissioning_date: format: date type: string parent_asset__created_at: format: timestamp with time zone type: string parent_asset__created_by_name: format: character varying maxLength: 200 type: string parent_asset__criticality: format: character varying maxLength: 40 type: string parent_asset__criticality_rank: format: smallint type: integer parent_asset__criticality_response_minutes: format: integer type: integer parent_asset__custodian: format: character varying type: string parent_asset__custodian_email: format: public.citext type: string parent_asset__custody_since: format: date type: string parent_asset__custom_fields: format: jsonb parent_asset__health_score: format: numeric type: number parent_asset__installation_date: format: date type: string parent_asset__is_retired: format: boolean type: boolean parent_asset__latitude: format: numeric type: number parent_asset__location_name: format: character varying maxLength: 200 type: string parent_asset__longitude: format: numeric type: number parent_asset__manufacturer: format: character varying maxLength: 200 type: string parent_asset__model_code: format: character varying maxLength: 80 type: string parent_asset__model_name: format: character varying maxLength: 200 type: string parent_asset__name: format: character varying maxLength: 250 type: string parent_asset__parent_asset_number: format: character varying maxLength: 80 type: string parent_asset__purchase_date: format: date type: string parent_asset__serial_number: format: character varying maxLength: 120 type: string parent_asset__site_code: format: character varying maxLength: 50 type: string parent_asset__site_name: format: character varying maxLength: 200 type: string parent_asset__status: format: character varying maxLength: 60 type: string parent_asset__status_category: format: character varying maxLength: 20 type: string parent_asset__status_label: format: text type: string parent_asset__updated_at: format: timestamp with time zone type: string parent_asset__updated_by_name: format: character varying maxLength: 200 type: string parent_asset__warranty_expires_on: format: date type: string parent_asset_id: description: >- Note: This is a Foreign Key to `asset_contracts.asset_id`. format: uuid type: string parent_asset_number: format: character varying maxLength: 80 type: string primary_image_file_id: format: uuid type: string purchase_date: format: date type: string reference_records: format: jsonb row_version: format: bigint type: integer search_all: format: text type: string search_text: format: text type: string serial_number: format: character varying maxLength: 120 type: string 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_code: format: character varying maxLength: 50 type: string site_id: description: >- Note: This is a Foreign Key to `entry_currencies.for_site_id`. format: uuid type: string site_name: format: character varying maxLength: 200 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 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 warranty_expires_on: format: date type: string type: object ````