> ## 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.

# Lost item reports with every field of the records each row points at: location, owner, reported by, 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 /lost_item_reports_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:
  /lost_item_reports_expanded:
    get:
      tags:
        - lost_item_reports_expanded
      summary: >-
        Lost item reports with every field of the records each row points at:
        location, owner, reported by, 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.lost_item_reports_expanded.id'
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reference
        - $ref: '#/components/parameters/rowFilter.lost_item_reports_expanded.status'
        - $ref: '#/components/parameters/rowFilter.lost_item_reports_expanded.site_id'
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.site_code
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.site_name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location_id
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location_name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.last_seen_detail
        - $ref: '#/components/parameters/rowFilter.lost_item_reports_expanded.lost_at'
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_at
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by_user_id
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner_name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner_kind
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner_id_type
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner_id_number
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner_phone
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner_email
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner_user_id
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.lost_found_category_id
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.category
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.item_description
        - $ref: '#/components/parameters/rowFilter.lost_item_reports_expanded.brand'
        - $ref: '#/components/parameters/rowFilter.lost_item_reports_expanded.colour'
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.serial_number
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.distinguishing_marks
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.estimated_value
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.estimated_value_currency_id
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.cctv_available
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.cctv_camera
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.cctv_from
        - $ref: '#/components/parameters/rowFilter.lost_item_reports_expanded.cctv_to'
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.cctv_reviewed
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.cctv_findings
        - $ref: '#/components/parameters/rowFilter.lost_item_reports_expanded.notes'
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.matched_at
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.closed_at
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.closure_notes
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.found_item_id
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.found_reference
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.found_description
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.found_storage_detail
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.collected_at
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.collected_by_name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.standing
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.primary_image_file_id
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.custom_fields
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.row_version
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.created_at
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.created_by_id
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.created_by_name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.created_source
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.updated_at
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.updated_by_id
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.updated_by_name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__site_code
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__parent_name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__location_type
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__level_hint
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__code
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__path
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__depth
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__latitude
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__longitude
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__is_active
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__allows_direct_filing
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__takes_filing
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__primary_location_head_name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__alternate_location_heads
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__children
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__assets
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.location__assets_in_branch
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner__email
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner__username
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner__sign_in_handle
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner__name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner__phone
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner__status
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner__last_login_at
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner__worker_number
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner__worker_name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner__worker_type
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner__worker_is_active
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.owner__worker_teams
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by__email
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by__username
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by__sign_in_handle
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by__name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by__phone
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by__status
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by__last_login_at
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by__worker_number
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by__worker_name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by__worker_type
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by__worker_is_active
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.reported_by__worker_teams
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.site__code
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.site__name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.site__timezone
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.site__is_active
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.site__company_name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.site__business_unit_name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.site__business_unit_parent_name
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_expanded.site__asset_count
        - $ref: >-
            #/components/parameters/rowFilter.lost_item_reports_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/lost_item_reports_expanded'
                type: array
            application/vnd.pgrst.object+json:
              schema:
                items:
                  $ref: '#/components/schemas/lost_item_reports_expanded'
                type: array
            application/vnd.pgrst.object+json;nulls=stripped:
              schema:
                items:
                  $ref: '#/components/schemas/lost_item_reports_expanded'
                type: array
            text/csv:
              schema:
                items:
                  $ref: '#/components/schemas/lost_item_reports_expanded'
                type: array
          description: OK
        '206':
          description: Partial Content
components:
  parameters:
    rowFilter.lost_item_reports_expanded.id:
      in: query
      name: id
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reference:
      in: query
      name: reference
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.status:
      in: query
      name: status
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.site_id:
      in: query
      name: site_id
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.site_code:
      in: query
      name: site_code
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.site_name:
      in: query
      name: site_name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location_id:
      in: query
      name: location_id
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location_name:
      in: query
      name: location_name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.last_seen_detail:
      in: query
      name: last_seen_detail
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.lost_at:
      in: query
      name: lost_at
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_at:
      in: query
      name: reported_at
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by_user_id:
      in: query
      name: reported_by_user_id
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by:
      in: query
      name: reported_by
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner_name:
      in: query
      name: owner_name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner_kind:
      in: query
      name: owner_kind
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner_id_type:
      in: query
      name: owner_id_type
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner_id_number:
      in: query
      name: owner_id_number
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner_phone:
      in: query
      name: owner_phone
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner_email:
      in: query
      name: owner_email
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner_user_id:
      in: query
      name: owner_user_id
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.lost_found_category_id:
      in: query
      name: lost_found_category_id
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.category:
      in: query
      name: category
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.item_description:
      in: query
      name: item_description
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.brand:
      in: query
      name: brand
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.colour:
      in: query
      name: colour
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.serial_number:
      in: query
      name: serial_number
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.distinguishing_marks:
      in: query
      name: distinguishing_marks
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.estimated_value:
      in: query
      name: estimated_value
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.estimated_value_currency_id:
      in: query
      name: estimated_value_currency_id
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.cctv_available:
      in: query
      name: cctv_available
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.cctv_camera:
      in: query
      name: cctv_camera
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.cctv_from:
      in: query
      name: cctv_from
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.cctv_to:
      in: query
      name: cctv_to
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.cctv_reviewed:
      in: query
      name: cctv_reviewed
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.cctv_findings:
      in: query
      name: cctv_findings
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.notes:
      in: query
      name: notes
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.matched_at:
      in: query
      name: matched_at
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.closed_at:
      in: query
      name: closed_at
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.closure_notes:
      in: query
      name: closure_notes
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.found_item_id:
      in: query
      name: found_item_id
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.found_reference:
      in: query
      name: found_reference
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.found_description:
      in: query
      name: found_description
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.found_storage_detail:
      in: query
      name: found_storage_detail
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.collected_at:
      in: query
      name: collected_at
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.collected_by_name:
      in: query
      name: collected_by_name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.standing:
      in: query
      name: standing
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.primary_image_file_id:
      in: query
      name: primary_image_file_id
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.custom_fields:
      in: query
      name: custom_fields
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.row_version:
      in: query
      name: row_version
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.created_at:
      in: query
      name: created_at
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.created_by_id:
      in: query
      name: created_by_id
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.created_by_name:
      in: query
      name: created_by_name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.created_source:
      in: query
      name: created_source
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.updated_at:
      in: query
      name: updated_at
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.updated_by_id:
      in: query
      name: updated_by_id
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.updated_by_name:
      in: query
      name: updated_by_name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__site_code:
      in: query
      name: location__site_code
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__parent_name:
      in: query
      name: location__parent_name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__location_type:
      in: query
      name: location__location_type
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__level_hint:
      in: query
      name: location__level_hint
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__code:
      in: query
      name: location__code
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__name:
      in: query
      name: location__name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__path:
      in: query
      name: location__path
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__depth:
      in: query
      name: location__depth
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__latitude:
      in: query
      name: location__latitude
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__longitude:
      in: query
      name: location__longitude
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__is_active:
      in: query
      name: location__is_active
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__allows_direct_filing:
      in: query
      name: location__allows_direct_filing
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__takes_filing:
      in: query
      name: location__takes_filing
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__primary_location_head_name:
      in: query
      name: location__primary_location_head_name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__alternate_location_heads:
      in: query
      name: location__alternate_location_heads
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__children:
      in: query
      name: location__children
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__assets:
      in: query
      name: location__assets
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.location__assets_in_branch:
      in: query
      name: location__assets_in_branch
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner__email:
      in: query
      name: owner__email
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner__username:
      in: query
      name: owner__username
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner__sign_in_handle:
      in: query
      name: owner__sign_in_handle
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner__name:
      in: query
      name: owner__name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner__phone:
      in: query
      name: owner__phone
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner__status:
      in: query
      name: owner__status
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner__last_login_at:
      in: query
      name: owner__last_login_at
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner__worker_number:
      in: query
      name: owner__worker_number
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner__worker_name:
      in: query
      name: owner__worker_name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner__worker_type:
      in: query
      name: owner__worker_type
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner__worker_is_active:
      in: query
      name: owner__worker_is_active
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.owner__worker_teams:
      in: query
      name: owner__worker_teams
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by__email:
      in: query
      name: reported_by__email
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by__username:
      in: query
      name: reported_by__username
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by__sign_in_handle:
      in: query
      name: reported_by__sign_in_handle
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by__name:
      in: query
      name: reported_by__name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by__phone:
      in: query
      name: reported_by__phone
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by__status:
      in: query
      name: reported_by__status
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by__last_login_at:
      in: query
      name: reported_by__last_login_at
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by__worker_number:
      in: query
      name: reported_by__worker_number
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by__worker_name:
      in: query
      name: reported_by__worker_name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by__worker_type:
      in: query
      name: reported_by__worker_type
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by__worker_is_active:
      in: query
      name: reported_by__worker_is_active
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.reported_by__worker_teams:
      in: query
      name: reported_by__worker_teams
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.site__code:
      in: query
      name: site__code
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.site__name:
      in: query
      name: site__name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.site__timezone:
      in: query
      name: site__timezone
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.site__is_active:
      in: query
      name: site__is_active
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.site__company_name:
      in: query
      name: site__company_name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.site__business_unit_name:
      in: query
      name: site__business_unit_name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.site__business_unit_parent_name:
      in: query
      name: site__business_unit_parent_name
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_expanded.site__asset_count:
      in: query
      name: site__asset_count
      required: false
      schema:
        type: string
    rowFilter.lost_item_reports_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:
    lost_item_reports_expanded:
      description: >-
        Lost item reports with every field of the records each row points at:
        location, owner, reported by, 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:
        brand:
          format: character varying
          maxLength: 80
          type: string
        category:
          format: character varying
          maxLength: 150
          type: string
        cctv_available:
          format: boolean
          type: boolean
        cctv_camera:
          format: character varying
          maxLength: 120
          type: string
        cctv_findings:
          format: text
          type: string
        cctv_from:
          format: timestamp with time zone
          type: string
        cctv_reviewed:
          format: boolean
          type: boolean
        cctv_to:
          format: timestamp with time zone
          type: string
        closed_at:
          format: timestamp with time zone
          type: string
        closure_notes:
          format: text
          type: string
        collected_at:
          format: timestamp with time zone
          type: string
        collected_by_name:
          format: character varying
          maxLength: 150
          type: string
        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`.<fk
            table='capex_invite_candidates' column='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
        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`.<fk
            table='asset_cost_to_keep' column='currency_id'/>
          format: uuid
          type: string
        found_description:
          format: text
          type: string
        found_item_id:
          description: |-
            Note:
            This is a Primary Key.<pk/>
          format: uuid
          type: string
        found_reference:
          format: character varying
          maxLength: 40
          type: string
        found_storage_detail:
          format: character varying
          maxLength: 200
          type: string
        id:
          description: |-
            Note:
            This is a Primary Key.<pk/>
          format: uuid
          type: string
        item_description:
          format: text
          type: string
        last_seen_detail:
          format: character varying
          maxLength: 200
          type: string
        location__allows_direct_filing:
          format: boolean
          type: boolean
        location__alternate_location_heads:
          format: jsonb
        location__assets:
          format: bigint
          type: integer
        location__assets_in_branch:
          format: bigint
          type: integer
        location__children:
          format: bigint
          type: integer
        location__code:
          format: character varying
          maxLength: 80
          type: string
        location__depth:
          format: smallint
          type: integer
        location__is_active:
          format: boolean
          type: boolean
        location__latitude:
          format: numeric
          type: number
        location__level_hint:
          format: smallint
          type: integer
        location__location_type:
          format: character varying
          maxLength: 150
          type: string
        location__longitude:
          format: numeric
          type: number
        location__name:
          format: character varying
          maxLength: 200
          type: string
        location__parent_name:
          format: character varying
          maxLength: 200
          type: string
        location__path:
          format: text
          type: string
        location__primary_location_head_name:
          format: character varying
          maxLength: 200
          type: string
        location__site_code:
          format: character varying
          maxLength: 50
          type: string
        location__takes_filing:
          format: boolean
          type: boolean
        location_id:
          description: >-
            Note:

            This is a Foreign Key to `location_settings.id`.<fk
            table='location_settings' column='id'/>
          format: uuid
          type: string
        location_name:
          format: character varying
          maxLength: 200
          type: string
        lost_at:
          format: timestamp with time zone
          type: string
        lost_found_category_id:
          description: >-
            Note:

            This is a Foreign Key to `lost_found_categories.id`.<fk
            table='lost_found_categories' column='id'/>
          format: uuid
          type: string
        matched_at:
          format: timestamp with time zone
          type: string
        notes:
          format: text
          type: string
        owner__email:
          format: public.citext
          type: string
        owner__last_login_at:
          format: timestamp with time zone
          type: string
        owner__name:
          format: character varying
          maxLength: 200
          type: string
        owner__phone:
          format: character varying
          maxLength: 40
          type: string
        owner__sign_in_handle:
          format: text
          type: string
        owner__status:
          format: character varying
          maxLength: 30
          type: string
        owner__username:
          format: public.citext
          type: string
        owner__worker_is_active:
          format: boolean
          type: boolean
        owner__worker_name:
          format: character varying
          maxLength: 200
          type: string
        owner__worker_number:
          format: character varying
          maxLength: 60
          type: string
        owner__worker_teams:
          format: jsonb
        owner__worker_type:
          format: character varying
          maxLength: 150
          type: string
        owner_email:
          format: character varying
          maxLength: 255
          type: string
        owner_id_number:
          format: character varying
          maxLength: 60
          type: string
        owner_id_type:
          format: character varying
          maxLength: 30
          type: string
        owner_kind:
          format: character varying
          maxLength: 20
          type: string
        owner_name:
          format: character varying
          maxLength: 150
          type: string
        owner_phone:
          format: character varying
          maxLength: 40
          type: string
        owner_user_id:
          description: >-
            Note:

            This is a Foreign Key to `capex_invite_candidates.id`.<fk
            table='capex_invite_candidates' column='id'/>
          format: uuid
          type: string
        primary_image_file_id:
          format: uuid
          type: string
        reference:
          format: character varying
          maxLength: 40
          type: string
        reference_records:
          format: jsonb
        reported_at:
          format: timestamp with time zone
          type: string
        reported_by:
          format: character varying
          maxLength: 200
          type: string
        reported_by__email:
          format: public.citext
          type: string
        reported_by__last_login_at:
          format: timestamp with time zone
          type: string
        reported_by__name:
          format: character varying
          maxLength: 200
          type: string
        reported_by__phone:
          format: character varying
          maxLength: 40
          type: string
        reported_by__sign_in_handle:
          format: text
          type: string
        reported_by__status:
          format: character varying
          maxLength: 30
          type: string
        reported_by__username:
          format: public.citext
          type: string
        reported_by__worker_is_active:
          format: boolean
          type: boolean
        reported_by__worker_name:
          format: character varying
          maxLength: 200
          type: string
        reported_by__worker_number:
          format: character varying
          maxLength: 60
          type: string
        reported_by__worker_teams:
          format: jsonb
        reported_by__worker_type:
          format: character varying
          maxLength: 150
          type: string
        reported_by_user_id:
          description: >-
            Note:

            This is a Foreign Key to `capex_invite_candidates.id`.<fk
            table='capex_invite_candidates' column='id'/>
          format: uuid
          type: string
        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`.<fk
            table='entry_currencies' column='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
        updated_at:
          format: timestamp with time zone
          type: string
        updated_by_id:
          description: >-
            Note:

            This is a Foreign Key to `capex_invite_candidates.id`.<fk
            table='capex_invite_candidates' column='id'/>
          format: uuid
          type: string
        updated_by_name:
          format: character varying
          maxLength: 200
          type: string
      type: object

````