> ## 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. # Found items with every field of the records each row points at: found at, found by, matched report, site, stored at. > 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 /found_items_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: /found_items_expanded: get: tags: - found_items_expanded summary: >- Found items with every field of the records each row points at: found at, found by, matched report, site, stored at. 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.found_items_expanded.id' - $ref: '#/components/parameters/rowFilter.found_items_expanded.reference' - $ref: '#/components/parameters/rowFilter.found_items_expanded.status' - $ref: '#/components/parameters/rowFilter.found_items_expanded.site_id' - $ref: '#/components/parameters/rowFilter.found_items_expanded.site_code' - $ref: '#/components/parameters/rowFilter.found_items_expanded.site_name' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_location_id - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_location_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_location_detail - $ref: '#/components/parameters/rowFilter.found_items_expanded.found_at' - $ref: '#/components/parameters/rowFilter.found_items_expanded.handed_in_at' - $ref: '#/components/parameters/rowFilter.found_items_expanded.found_by_name' - $ref: '#/components/parameters/rowFilter.found_items_expanded.found_by_kind' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by_phone - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by_user_id - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_found_category_id - $ref: '#/components/parameters/rowFilter.found_items_expanded.category' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.requires_signature - $ref: >- #/components/parameters/rowFilter.found_items_expanded.item_description - $ref: '#/components/parameters/rowFilter.found_items_expanded.brand' - $ref: '#/components/parameters/rowFilter.found_items_expanded.colour' - $ref: '#/components/parameters/rowFilter.found_items_expanded.serial_number' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.distinguishing_marks - $ref: '#/components/parameters/rowFilter.found_items_expanded.quantity' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.estimated_value - $ref: >- #/components/parameters/rowFilter.found_items_expanded.estimated_value_currency_id - $ref: '#/components/parameters/rowFilter.found_items_expanded.is_valuable' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location_id - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_detail - $ref: >- #/components/parameters/rowFilter.found_items_expanded.stored_by_user_id - $ref: '#/components/parameters/rowFilter.found_items_expanded.stored_by' - $ref: '#/components/parameters/rowFilter.found_items_expanded.hold_until' - $ref: '#/components/parameters/rowFilter.found_items_expanded.days_held' - $ref: '#/components/parameters/rowFilter.found_items_expanded.hold_expired' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report_id - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_reference - $ref: '#/components/parameters/rowFilter.found_items_expanded.owner_name' - $ref: '#/components/parameters/rowFilter.found_items_expanded.owner_phone' - $ref: '#/components/parameters/rowFilter.found_items_expanded.owner_email' - $ref: '#/components/parameters/rowFilter.found_items_expanded.matched_at' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.matched_by_user_id - $ref: '#/components/parameters/rowFilter.found_items_expanded.match_notes' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.collected_by_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.collected_by_id_type - $ref: >- #/components/parameters/rowFilter.found_items_expanded.collected_by_id_number - $ref: >- #/components/parameters/rowFilter.found_items_expanded.collected_by_signature - $ref: >- #/components/parameters/rowFilter.found_items_expanded.collection_signed - $ref: '#/components/parameters/rowFilter.found_items_expanded.collected_at' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.released_by_user_id - $ref: '#/components/parameters/rowFilter.found_items_expanded.released_by' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.collection_notes - $ref: '#/components/parameters/rowFilter.found_items_expanded.disposed_at' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.disposal_method - $ref: >- #/components/parameters/rowFilter.found_items_expanded.disposal_notes - $ref: '#/components/parameters/rowFilter.found_items_expanded.notes' - $ref: '#/components/parameters/rowFilter.found_items_expanded.standing' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.primary_image_file_id - $ref: '#/components/parameters/rowFilter.found_items_expanded.custom_fields' - $ref: '#/components/parameters/rowFilter.found_items_expanded.row_version' - $ref: '#/components/parameters/rowFilter.found_items_expanded.created_at' - $ref: '#/components/parameters/rowFilter.found_items_expanded.created_by_id' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.created_by_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.created_source - $ref: '#/components/parameters/rowFilter.found_items_expanded.updated_at' - $ref: '#/components/parameters/rowFilter.found_items_expanded.updated_by_id' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.updated_by_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by__email - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by__username - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by__sign_in_handle - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by__name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by__phone - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by__status - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by__last_login_at - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by__worker_number - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by__worker_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by__worker_type - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by__worker_is_active - $ref: >- #/components/parameters/rowFilter.found_items_expanded.found_by__worker_teams - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__site_code - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__parent_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__location_type - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__level_hint - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__code - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__path - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__depth - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__latitude - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__longitude - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__is_active - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__allows_direct_filing - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__takes_filing - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__primary_location_head_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__alternate_location_heads - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__children - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__assets - $ref: >- #/components/parameters/rowFilter.found_items_expanded.location__assets_in_branch - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__reference - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__status - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__site_code - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__site_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__location_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__last_seen_detail - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__lost_at - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__reported_at - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__reported_by - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__owner_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__owner_kind - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__owner_id_type - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__owner_id_number - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__owner_phone - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__owner_email - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__category - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__item_description - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__brand - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__colour - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__serial_number - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__distinguishing_marks - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__estimated_value - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__cctv_available - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__cctv_camera - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__cctv_from - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__cctv_to - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__cctv_reviewed - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__cctv_findings - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__notes - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__matched_at - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__closed_at - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__closure_notes - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__found_reference - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__found_description - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__found_storage_detail - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__collected_at - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__collected_by_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__standing - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__custom_fields - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__created_at - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__created_by_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__updated_at - $ref: >- #/components/parameters/rowFilter.found_items_expanded.lost_item_report__updated_by_name - $ref: '#/components/parameters/rowFilter.found_items_expanded.site__code' - $ref: '#/components/parameters/rowFilter.found_items_expanded.site__name' - $ref: >- #/components/parameters/rowFilter.found_items_expanded.site__timezone - $ref: >- #/components/parameters/rowFilter.found_items_expanded.site__is_active - $ref: >- #/components/parameters/rowFilter.found_items_expanded.site__company_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.site__business_unit_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.site__business_unit_parent_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.site__asset_count - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__site_code - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__parent_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__location_type - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__level_hint - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__code - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__path - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__depth - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__latitude - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__longitude - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__is_active - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__allows_direct_filing - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__takes_filing - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__primary_location_head_name - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__alternate_location_heads - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__children - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__assets - $ref: >- #/components/parameters/rowFilter.found_items_expanded.storage_location__assets_in_branch - $ref: >- #/components/parameters/rowFilter.found_items_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/found_items_expanded' type: array application/vnd.pgrst.object+json: schema: items: $ref: '#/components/schemas/found_items_expanded' type: array application/vnd.pgrst.object+json;nulls=stripped: schema: items: $ref: '#/components/schemas/found_items_expanded' type: array text/csv: schema: items: $ref: '#/components/schemas/found_items_expanded' type: array description: OK '206': description: Partial Content components: parameters: rowFilter.found_items_expanded.id: in: query name: id required: false schema: type: string rowFilter.found_items_expanded.reference: in: query name: reference required: false schema: type: string rowFilter.found_items_expanded.status: in: query name: status required: false schema: type: string rowFilter.found_items_expanded.site_id: in: query name: site_id required: false schema: type: string rowFilter.found_items_expanded.site_code: in: query name: site_code required: false schema: type: string rowFilter.found_items_expanded.site_name: in: query name: site_name required: false schema: type: string rowFilter.found_items_expanded.found_location_id: in: query name: found_location_id required: false schema: type: string rowFilter.found_items_expanded.found_location_name: in: query name: found_location_name required: false schema: type: string rowFilter.found_items_expanded.found_location_detail: in: query name: found_location_detail required: false schema: type: string rowFilter.found_items_expanded.found_at: in: query name: found_at required: false schema: type: string rowFilter.found_items_expanded.handed_in_at: in: query name: handed_in_at required: false schema: type: string rowFilter.found_items_expanded.found_by_name: in: query name: found_by_name required: false schema: type: string rowFilter.found_items_expanded.found_by_kind: in: query name: found_by_kind required: false schema: type: string rowFilter.found_items_expanded.found_by_phone: in: query name: found_by_phone required: false schema: type: string rowFilter.found_items_expanded.found_by_user_id: in: query name: found_by_user_id required: false schema: type: string rowFilter.found_items_expanded.lost_found_category_id: in: query name: lost_found_category_id required: false schema: type: string rowFilter.found_items_expanded.category: in: query name: category required: false schema: type: string rowFilter.found_items_expanded.requires_signature: in: query name: requires_signature required: false schema: type: string rowFilter.found_items_expanded.item_description: in: query name: item_description required: false schema: type: string rowFilter.found_items_expanded.brand: in: query name: brand required: false schema: type: string rowFilter.found_items_expanded.colour: in: query name: colour required: false schema: type: string rowFilter.found_items_expanded.serial_number: in: query name: serial_number required: false schema: type: string rowFilter.found_items_expanded.distinguishing_marks: in: query name: distinguishing_marks required: false schema: type: string rowFilter.found_items_expanded.quantity: in: query name: quantity required: false schema: type: string rowFilter.found_items_expanded.estimated_value: in: query name: estimated_value required: false schema: type: string rowFilter.found_items_expanded.estimated_value_currency_id: in: query name: estimated_value_currency_id required: false schema: type: string rowFilter.found_items_expanded.is_valuable: in: query name: is_valuable required: false schema: type: string rowFilter.found_items_expanded.storage_location_id: in: query name: storage_location_id required: false schema: type: string rowFilter.found_items_expanded.storage_location_name: in: query name: storage_location_name required: false schema: type: string rowFilter.found_items_expanded.storage_detail: in: query name: storage_detail required: false schema: type: string rowFilter.found_items_expanded.stored_by_user_id: in: query name: stored_by_user_id required: false schema: type: string rowFilter.found_items_expanded.stored_by: in: query name: stored_by required: false schema: type: string rowFilter.found_items_expanded.hold_until: in: query name: hold_until required: false schema: type: string rowFilter.found_items_expanded.days_held: in: query name: days_held required: false schema: type: string rowFilter.found_items_expanded.hold_expired: in: query name: hold_expired required: false schema: type: string rowFilter.found_items_expanded.lost_item_report_id: in: query name: lost_item_report_id required: false schema: type: string rowFilter.found_items_expanded.lost_reference: in: query name: lost_reference required: false schema: type: string rowFilter.found_items_expanded.owner_name: in: query name: owner_name required: false schema: type: string rowFilter.found_items_expanded.owner_phone: in: query name: owner_phone required: false schema: type: string rowFilter.found_items_expanded.owner_email: in: query name: owner_email required: false schema: type: string rowFilter.found_items_expanded.matched_at: in: query name: matched_at required: false schema: type: string rowFilter.found_items_expanded.matched_by_user_id: in: query name: matched_by_user_id required: false schema: type: string rowFilter.found_items_expanded.match_notes: in: query name: match_notes required: false schema: type: string rowFilter.found_items_expanded.collected_by_name: in: query name: collected_by_name required: false schema: type: string rowFilter.found_items_expanded.collected_by_id_type: in: query name: collected_by_id_type required: false schema: type: string rowFilter.found_items_expanded.collected_by_id_number: in: query name: collected_by_id_number required: false schema: type: string rowFilter.found_items_expanded.collected_by_signature: in: query name: collected_by_signature required: false schema: type: string rowFilter.found_items_expanded.collection_signed: in: query name: collection_signed required: false schema: type: string rowFilter.found_items_expanded.collected_at: in: query name: collected_at required: false schema: type: string rowFilter.found_items_expanded.released_by_user_id: in: query name: released_by_user_id required: false schema: type: string rowFilter.found_items_expanded.released_by: in: query name: released_by required: false schema: type: string rowFilter.found_items_expanded.collection_notes: in: query name: collection_notes required: false schema: type: string rowFilter.found_items_expanded.disposed_at: in: query name: disposed_at required: false schema: type: string rowFilter.found_items_expanded.disposal_method: in: query name: disposal_method required: false schema: type: string rowFilter.found_items_expanded.disposal_notes: in: query name: disposal_notes required: false schema: type: string rowFilter.found_items_expanded.notes: in: query name: notes required: false schema: type: string rowFilter.found_items_expanded.standing: in: query name: standing required: false schema: type: string rowFilter.found_items_expanded.primary_image_file_id: in: query name: primary_image_file_id required: false schema: type: string rowFilter.found_items_expanded.custom_fields: in: query name: custom_fields required: false schema: type: string rowFilter.found_items_expanded.row_version: in: query name: row_version required: false schema: type: string rowFilter.found_items_expanded.created_at: in: query name: created_at required: false schema: type: string rowFilter.found_items_expanded.created_by_id: in: query name: created_by_id required: false schema: type: string rowFilter.found_items_expanded.created_by_name: in: query name: created_by_name required: false schema: type: string rowFilter.found_items_expanded.created_source: in: query name: created_source required: false schema: type: string rowFilter.found_items_expanded.updated_at: in: query name: updated_at required: false schema: type: string rowFilter.found_items_expanded.updated_by_id: in: query name: updated_by_id required: false schema: type: string rowFilter.found_items_expanded.updated_by_name: in: query name: updated_by_name required: false schema: type: string rowFilter.found_items_expanded.found_by__email: in: query name: found_by__email required: false schema: type: string rowFilter.found_items_expanded.found_by__username: in: query name: found_by__username required: false schema: type: string rowFilter.found_items_expanded.found_by__sign_in_handle: in: query name: found_by__sign_in_handle required: false schema: type: string rowFilter.found_items_expanded.found_by__name: in: query name: found_by__name required: false schema: type: string rowFilter.found_items_expanded.found_by__phone: in: query name: found_by__phone required: false schema: type: string rowFilter.found_items_expanded.found_by__status: in: query name: found_by__status required: false schema: type: string rowFilter.found_items_expanded.found_by__last_login_at: in: query name: found_by__last_login_at required: false schema: type: string rowFilter.found_items_expanded.found_by__worker_number: in: query name: found_by__worker_number required: false schema: type: string rowFilter.found_items_expanded.found_by__worker_name: in: query name: found_by__worker_name required: false schema: type: string rowFilter.found_items_expanded.found_by__worker_type: in: query name: found_by__worker_type required: false schema: type: string rowFilter.found_items_expanded.found_by__worker_is_active: in: query name: found_by__worker_is_active required: false schema: type: string rowFilter.found_items_expanded.found_by__worker_teams: in: query name: found_by__worker_teams required: false schema: type: string rowFilter.found_items_expanded.location__site_code: in: query name: location__site_code required: false schema: type: string rowFilter.found_items_expanded.location__parent_name: in: query name: location__parent_name required: false schema: type: string rowFilter.found_items_expanded.location__location_type: in: query name: location__location_type required: false schema: type: string rowFilter.found_items_expanded.location__level_hint: in: query name: location__level_hint required: false schema: type: string rowFilter.found_items_expanded.location__code: in: query name: location__code required: false schema: type: string rowFilter.found_items_expanded.location__name: in: query name: location__name required: false schema: type: string rowFilter.found_items_expanded.location__path: in: query name: location__path required: false schema: type: string rowFilter.found_items_expanded.location__depth: in: query name: location__depth required: false schema: type: string rowFilter.found_items_expanded.location__latitude: in: query name: location__latitude required: false schema: type: string rowFilter.found_items_expanded.location__longitude: in: query name: location__longitude required: false schema: type: string rowFilter.found_items_expanded.location__is_active: in: query name: location__is_active required: false schema: type: string rowFilter.found_items_expanded.location__allows_direct_filing: in: query name: location__allows_direct_filing required: false schema: type: string rowFilter.found_items_expanded.location__takes_filing: in: query name: location__takes_filing required: false schema: type: string rowFilter.found_items_expanded.location__primary_location_head_name: in: query name: location__primary_location_head_name required: false schema: type: string rowFilter.found_items_expanded.location__alternate_location_heads: in: query name: location__alternate_location_heads required: false schema: type: string rowFilter.found_items_expanded.location__children: in: query name: location__children required: false schema: type: string rowFilter.found_items_expanded.location__assets: in: query name: location__assets required: false schema: type: string rowFilter.found_items_expanded.location__assets_in_branch: in: query name: location__assets_in_branch required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__reference: in: query name: lost_item_report__reference required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__status: in: query name: lost_item_report__status required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__site_code: in: query name: lost_item_report__site_code required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__site_name: in: query name: lost_item_report__site_name required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__location_name: in: query name: lost_item_report__location_name required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__last_seen_detail: in: query name: lost_item_report__last_seen_detail required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__lost_at: in: query name: lost_item_report__lost_at required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__reported_at: in: query name: lost_item_report__reported_at required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__reported_by: in: query name: lost_item_report__reported_by required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__owner_name: in: query name: lost_item_report__owner_name required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__owner_kind: in: query name: lost_item_report__owner_kind required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__owner_id_type: in: query name: lost_item_report__owner_id_type required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__owner_id_number: in: query name: lost_item_report__owner_id_number required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__owner_phone: in: query name: lost_item_report__owner_phone required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__owner_email: in: query name: lost_item_report__owner_email required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__category: in: query name: lost_item_report__category required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__item_description: in: query name: lost_item_report__item_description required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__brand: in: query name: lost_item_report__brand required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__colour: in: query name: lost_item_report__colour required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__serial_number: in: query name: lost_item_report__serial_number required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__distinguishing_marks: in: query name: lost_item_report__distinguishing_marks required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__estimated_value: in: query name: lost_item_report__estimated_value required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__cctv_available: in: query name: lost_item_report__cctv_available required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__cctv_camera: in: query name: lost_item_report__cctv_camera required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__cctv_from: in: query name: lost_item_report__cctv_from required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__cctv_to: in: query name: lost_item_report__cctv_to required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__cctv_reviewed: in: query name: lost_item_report__cctv_reviewed required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__cctv_findings: in: query name: lost_item_report__cctv_findings required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__notes: in: query name: lost_item_report__notes required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__matched_at: in: query name: lost_item_report__matched_at required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__closed_at: in: query name: lost_item_report__closed_at required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__closure_notes: in: query name: lost_item_report__closure_notes required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__found_reference: in: query name: lost_item_report__found_reference required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__found_description: in: query name: lost_item_report__found_description required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__found_storage_detail: in: query name: lost_item_report__found_storage_detail required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__collected_at: in: query name: lost_item_report__collected_at required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__collected_by_name: in: query name: lost_item_report__collected_by_name required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__standing: in: query name: lost_item_report__standing required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__custom_fields: in: query name: lost_item_report__custom_fields required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__created_at: in: query name: lost_item_report__created_at required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__created_by_name: in: query name: lost_item_report__created_by_name required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__updated_at: in: query name: lost_item_report__updated_at required: false schema: type: string rowFilter.found_items_expanded.lost_item_report__updated_by_name: in: query name: lost_item_report__updated_by_name required: false schema: type: string rowFilter.found_items_expanded.site__code: in: query name: site__code required: false schema: type: string rowFilter.found_items_expanded.site__name: in: query name: site__name required: false schema: type: string rowFilter.found_items_expanded.site__timezone: in: query name: site__timezone required: false schema: type: string rowFilter.found_items_expanded.site__is_active: in: query name: site__is_active required: false schema: type: string rowFilter.found_items_expanded.site__company_name: in: query name: site__company_name required: false schema: type: string rowFilter.found_items_expanded.site__business_unit_name: in: query name: site__business_unit_name required: false schema: type: string rowFilter.found_items_expanded.site__business_unit_parent_name: in: query name: site__business_unit_parent_name required: false schema: type: string rowFilter.found_items_expanded.site__asset_count: in: query name: site__asset_count required: false schema: type: string rowFilter.found_items_expanded.storage_location__site_code: in: query name: storage_location__site_code required: false schema: type: string rowFilter.found_items_expanded.storage_location__parent_name: in: query name: storage_location__parent_name required: false schema: type: string rowFilter.found_items_expanded.storage_location__location_type: in: query name: storage_location__location_type required: false schema: type: string rowFilter.found_items_expanded.storage_location__level_hint: in: query name: storage_location__level_hint required: false schema: type: string rowFilter.found_items_expanded.storage_location__code: in: query name: storage_location__code required: false schema: type: string rowFilter.found_items_expanded.storage_location__name: in: query name: storage_location__name required: false schema: type: string rowFilter.found_items_expanded.storage_location__path: in: query name: storage_location__path required: false schema: type: string rowFilter.found_items_expanded.storage_location__depth: in: query name: storage_location__depth required: false schema: type: string rowFilter.found_items_expanded.storage_location__latitude: in: query name: storage_location__latitude required: false schema: type: string rowFilter.found_items_expanded.storage_location__longitude: in: query name: storage_location__longitude required: false schema: type: string rowFilter.found_items_expanded.storage_location__is_active: in: query name: storage_location__is_active required: false schema: type: string rowFilter.found_items_expanded.storage_location__allows_direct_filing: in: query name: storage_location__allows_direct_filing required: false schema: type: string rowFilter.found_items_expanded.storage_location__takes_filing: in: query name: storage_location__takes_filing required: false schema: type: string rowFilter.found_items_expanded.storage_location__primary_location_head_name: in: query name: storage_location__primary_location_head_name required: false schema: type: string rowFilter.found_items_expanded.storage_location__alternate_location_heads: in: query name: storage_location__alternate_location_heads required: false schema: type: string rowFilter.found_items_expanded.storage_location__children: in: query name: storage_location__children required: false schema: type: string rowFilter.found_items_expanded.storage_location__assets: in: query name: storage_location__assets required: false schema: type: string rowFilter.found_items_expanded.storage_location__assets_in_branch: in: query name: storage_location__assets_in_branch required: false schema: type: string rowFilter.found_items_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: found_items_expanded: description: >- Found items with every field of the records each row points at: found at, found by, matched report, site, stored at. 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: brand: format: character varying maxLength: 80 type: string category: format: character varying maxLength: 150 type: string collected_at: format: timestamp with time zone type: string collected_by_id_number: format: character varying maxLength: 60 type: string collected_by_id_type: format: character varying maxLength: 30 type: string collected_by_name: format: character varying maxLength: 150 type: string collected_by_signature: format: jsonb collection_notes: format: text type: string collection_signed: format: boolean type: boolean colour: format: character varying maxLength: 40 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 custom_fields: format: jsonb days_held: format: integer type: integer disposal_method: format: character varying maxLength: 30 type: string disposal_notes: format: text type: string disposed_at: format: timestamp with time zone type: string distinguishing_marks: format: text type: string estimated_value: format: numeric type: number estimated_value_currency_id: description: >- Note: This is a Foreign Key to `asset_cost_to_keep.currency_id`. format: uuid type: string found_at: format: timestamp with time zone type: string found_by__email: format: public.citext type: string found_by__last_login_at: format: timestamp with time zone type: string found_by__name: format: character varying maxLength: 200 type: string found_by__phone: format: character varying maxLength: 40 type: string found_by__sign_in_handle: format: text type: string found_by__status: format: character varying maxLength: 30 type: string found_by__username: format: public.citext type: string found_by__worker_is_active: format: boolean type: boolean found_by__worker_name: format: character varying maxLength: 200 type: string found_by__worker_number: format: character varying maxLength: 60 type: string found_by__worker_teams: format: jsonb found_by__worker_type: format: character varying maxLength: 150 type: string found_by_kind: format: character varying maxLength: 20 type: string found_by_name: format: character varying maxLength: 150 type: string found_by_phone: format: character varying maxLength: 40 type: string found_by_user_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string found_location_detail: format: character varying maxLength: 200 type: string found_location_id: description: >- Note: This is a Foreign Key to `location_settings.id`. format: uuid type: string found_location_name: format: character varying maxLength: 200 type: string handed_in_at: format: timestamp with time zone type: string hold_expired: format: boolean type: boolean hold_until: format: date type: string id: description: |- Note: This is a Primary Key. format: uuid type: string is_valuable: format: boolean type: boolean item_description: format: text 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 lost_found_category_id: description: >- Note: This is a Foreign Key to `lost_found_categories.id`. format: uuid type: string lost_item_report__brand: format: character varying maxLength: 80 type: string lost_item_report__category: format: character varying maxLength: 150 type: string lost_item_report__cctv_available: format: boolean type: boolean lost_item_report__cctv_camera: format: character varying maxLength: 120 type: string lost_item_report__cctv_findings: format: text type: string lost_item_report__cctv_from: format: timestamp with time zone type: string lost_item_report__cctv_reviewed: format: boolean type: boolean lost_item_report__cctv_to: format: timestamp with time zone type: string lost_item_report__closed_at: format: timestamp with time zone type: string lost_item_report__closure_notes: format: text type: string lost_item_report__collected_at: format: timestamp with time zone type: string lost_item_report__collected_by_name: format: character varying maxLength: 150 type: string lost_item_report__colour: format: character varying maxLength: 40 type: string lost_item_report__created_at: format: timestamp with time zone type: string lost_item_report__created_by_name: format: character varying maxLength: 200 type: string lost_item_report__custom_fields: format: jsonb lost_item_report__distinguishing_marks: format: text type: string lost_item_report__estimated_value: format: numeric type: number lost_item_report__found_description: format: text type: string lost_item_report__found_reference: format: character varying maxLength: 40 type: string lost_item_report__found_storage_detail: format: character varying maxLength: 200 type: string lost_item_report__item_description: format: text type: string lost_item_report__last_seen_detail: format: character varying maxLength: 200 type: string lost_item_report__location_name: format: character varying maxLength: 200 type: string lost_item_report__lost_at: format: timestamp with time zone type: string lost_item_report__matched_at: format: timestamp with time zone type: string lost_item_report__notes: format: text type: string lost_item_report__owner_email: format: character varying maxLength: 255 type: string lost_item_report__owner_id_number: format: character varying maxLength: 60 type: string lost_item_report__owner_id_type: format: character varying maxLength: 30 type: string lost_item_report__owner_kind: format: character varying maxLength: 20 type: string lost_item_report__owner_name: format: character varying maxLength: 150 type: string lost_item_report__owner_phone: format: character varying maxLength: 40 type: string lost_item_report__reference: format: character varying maxLength: 40 type: string lost_item_report__reported_at: format: timestamp with time zone type: string lost_item_report__reported_by: format: character varying maxLength: 200 type: string lost_item_report__serial_number: format: character varying maxLength: 80 type: string lost_item_report__site_code: format: character varying maxLength: 50 type: string lost_item_report__site_name: format: character varying maxLength: 200 type: string lost_item_report__standing: format: text type: string lost_item_report__status: format: character varying maxLength: 20 type: string lost_item_report__updated_at: format: timestamp with time zone type: string lost_item_report__updated_by_name: format: character varying maxLength: 200 type: string lost_item_report_id: description: >- Note: This is a Foreign Key to `lost_item_reports.id`. format: uuid type: string lost_reference: format: character varying maxLength: 40 type: string match_notes: format: text type: string matched_at: format: timestamp with time zone type: string matched_by_user_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string notes: format: text type: string owner_email: format: character varying maxLength: 255 type: string owner_name: format: character varying maxLength: 150 type: string owner_phone: format: character varying maxLength: 40 type: string primary_image_file_id: format: uuid type: string quantity: format: integer type: integer reference: format: character varying maxLength: 40 type: string reference_records: format: jsonb released_by: format: character varying maxLength: 200 type: string released_by_user_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string requires_signature: format: boolean type: boolean row_version: format: bigint type: integer serial_number: format: character varying maxLength: 80 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 standing: format: text type: string status: format: character varying maxLength: 20 type: string storage_detail: format: character varying maxLength: 200 type: string storage_location__allows_direct_filing: format: boolean type: boolean storage_location__alternate_location_heads: format: jsonb storage_location__assets: format: bigint type: integer storage_location__assets_in_branch: format: bigint type: integer storage_location__children: format: bigint type: integer storage_location__code: format: character varying maxLength: 80 type: string storage_location__depth: format: smallint type: integer storage_location__is_active: format: boolean type: boolean storage_location__latitude: format: numeric type: number storage_location__level_hint: format: smallint type: integer storage_location__location_type: format: character varying maxLength: 150 type: string storage_location__longitude: format: numeric type: number storage_location__name: format: character varying maxLength: 200 type: string storage_location__parent_name: format: character varying maxLength: 200 type: string storage_location__path: format: text type: string storage_location__primary_location_head_name: format: character varying maxLength: 200 type: string storage_location__site_code: format: character varying maxLength: 50 type: string storage_location__takes_filing: format: boolean type: boolean storage_location_id: description: >- Note: This is a Foreign Key to `location_settings.id`. format: uuid type: string storage_location_name: format: character varying maxLength: 200 type: string stored_by: format: character varying maxLength: 200 type: string stored_by_user_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid 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 type: object ````