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

# Saved reports the caller may open: their own, their roles' and sites', and the organisation's.

> Which audience a report has is about whose register it is in, never about what it may show.



## OpenAPI

````yaml /api-reference/openapi.json patch /report_definitions
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:
  /report_definitions:
    patch:
      tags:
        - Reports
      summary: >-
        Saved reports the caller may open: their own, their roles' and sites',
        and the organisation's.
      description: >-
        Which audience a report has is about whose register it is in, never
        about what it may show.
      parameters:
        - $ref: '#/components/parameters/rowFilter.report_definitions.id'
        - $ref: '#/components/parameters/rowFilter.report_definitions.code'
        - $ref: '#/components/parameters/rowFilter.report_definitions.name'
        - $ref: '#/components/parameters/rowFilter.report_definitions.description'
        - $ref: '#/components/parameters/rowFilter.report_definitions.category'
        - $ref: '#/components/parameters/rowFilter.report_definitions.source_view'
        - $ref: >-
            #/components/parameters/rowFilter.report_definitions.filter_expression
        - $ref: '#/components/parameters/rowFilter.report_definitions.columns'
        - $ref: '#/components/parameters/rowFilter.report_definitions.order_by'
        - $ref: '#/components/parameters/rowFilter.report_definitions.row_limit'
        - $ref: '#/components/parameters/rowFilter.report_definitions.pivot_rows'
        - $ref: '#/components/parameters/rowFilter.report_definitions.pivot_column'
        - $ref: '#/components/parameters/rowFilter.report_definitions.pivot_measures'
        - $ref: '#/components/parameters/rowFilter.report_definitions.pivot_limit'
        - $ref: '#/components/parameters/rowFilter.report_definitions.show_subtotals'
        - $ref: '#/components/parameters/rowFilter.report_definitions.show_totals'
        - $ref: '#/components/parameters/rowFilter.report_definitions.chart_type'
        - $ref: '#/components/parameters/rowFilter.report_definitions.visibility'
        - $ref: '#/components/parameters/rowFilter.report_definitions.status'
        - $ref: '#/components/parameters/rowFilter.report_definitions.is_active'
        - $ref: '#/components/parameters/rowFilter.report_definitions.last_run_at'
        - $ref: '#/components/parameters/rowFilter.report_definitions.run_count'
        - $ref: '#/components/parameters/rowFilter.report_definitions.created_by'
        - $ref: '#/components/parameters/rowFilter.report_definitions.created_at'
        - $ref: '#/components/parameters/rowFilter.report_definitions.updated_at'
        - $ref: '#/components/parameters/rowFilter.report_definitions.mine'
        - $ref: >-
            #/components/parameters/rowFilter.report_definitions.is_organization_wide
        - $ref: '#/components/parameters/rowFilter.report_definitions.shared_with_me'
        - $ref: '#/components/parameters/rowFilter.report_definitions.shared_with'
        - $ref: '#/components/parameters/rowFilter.report_definitions.shared_role_ids'
        - $ref: '#/components/parameters/rowFilter.report_definitions.shared_site_ids'
        - $ref: '#/components/parameters/rowFilter.report_definitions.author_name'
        - $ref: '#/components/parameters/rowFilter.report_definitions.schedules'
        - $ref: '#/components/parameters/preferReturn'
      requestBody:
        $ref: '#/components/requestBodies/report_definitions'
      responses:
        '204':
          description: No Content
components:
  parameters:
    rowFilter.report_definitions.id:
      in: query
      name: id
      required: false
      schema:
        type: string
    rowFilter.report_definitions.code:
      in: query
      name: code
      required: false
      schema:
        type: string
    rowFilter.report_definitions.name:
      in: query
      name: name
      required: false
      schema:
        type: string
    rowFilter.report_definitions.description:
      in: query
      name: description
      required: false
      schema:
        type: string
    rowFilter.report_definitions.category:
      in: query
      name: category
      required: false
      schema:
        type: string
    rowFilter.report_definitions.source_view:
      in: query
      name: source_view
      required: false
      schema:
        type: string
    rowFilter.report_definitions.filter_expression:
      in: query
      name: filter_expression
      required: false
      schema:
        type: string
    rowFilter.report_definitions.columns:
      in: query
      name: columns
      required: false
      schema:
        type: string
    rowFilter.report_definitions.order_by:
      in: query
      name: order_by
      required: false
      schema:
        type: string
    rowFilter.report_definitions.row_limit:
      in: query
      name: row_limit
      required: false
      schema:
        type: string
    rowFilter.report_definitions.pivot_rows:
      in: query
      name: pivot_rows
      required: false
      schema:
        type: string
    rowFilter.report_definitions.pivot_column:
      in: query
      name: pivot_column
      required: false
      schema:
        type: string
    rowFilter.report_definitions.pivot_measures:
      in: query
      name: pivot_measures
      required: false
      schema:
        type: string
    rowFilter.report_definitions.pivot_limit:
      in: query
      name: pivot_limit
      required: false
      schema:
        type: string
    rowFilter.report_definitions.show_subtotals:
      in: query
      name: show_subtotals
      required: false
      schema:
        type: string
    rowFilter.report_definitions.show_totals:
      in: query
      name: show_totals
      required: false
      schema:
        type: string
    rowFilter.report_definitions.chart_type:
      in: query
      name: chart_type
      required: false
      schema:
        type: string
    rowFilter.report_definitions.visibility:
      in: query
      name: visibility
      required: false
      schema:
        type: string
    rowFilter.report_definitions.status:
      in: query
      name: status
      required: false
      schema:
        type: string
    rowFilter.report_definitions.is_active:
      in: query
      name: is_active
      required: false
      schema:
        type: string
    rowFilter.report_definitions.last_run_at:
      in: query
      name: last_run_at
      required: false
      schema:
        type: string
    rowFilter.report_definitions.run_count:
      in: query
      name: run_count
      required: false
      schema:
        type: string
    rowFilter.report_definitions.created_by:
      in: query
      name: created_by
      required: false
      schema:
        type: string
    rowFilter.report_definitions.created_at:
      in: query
      name: created_at
      required: false
      schema:
        type: string
    rowFilter.report_definitions.updated_at:
      in: query
      name: updated_at
      required: false
      schema:
        type: string
    rowFilter.report_definitions.mine:
      in: query
      name: mine
      required: false
      schema:
        type: string
    rowFilter.report_definitions.is_organization_wide:
      in: query
      name: is_organization_wide
      required: false
      schema:
        type: string
    rowFilter.report_definitions.shared_with_me:
      in: query
      name: shared_with_me
      required: false
      schema:
        type: string
    rowFilter.report_definitions.shared_with:
      in: query
      name: shared_with
      required: false
      schema:
        type: string
    rowFilter.report_definitions.shared_role_ids:
      in: query
      name: shared_role_ids
      required: false
      schema:
        type: string
    rowFilter.report_definitions.shared_site_ids:
      in: query
      name: shared_site_ids
      required: false
      schema:
        type: string
    rowFilter.report_definitions.author_name:
      in: query
      name: author_name
      required: false
      schema:
        type: string
    rowFilter.report_definitions.schedules:
      in: query
      name: schedules
      required: false
      schema:
        type: string
    preferReturn:
      description: Preference
      in: header
      name: Prefer
      required: false
      schema:
        enum:
          - return=representation
          - return=minimal
          - return=none
        type: string
  requestBodies:
    report_definitions:
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/report_definitions'
        application/vnd.pgrst.object+json:
          schema:
            $ref: '#/components/schemas/report_definitions'
        application/vnd.pgrst.object+json;nulls=stripped:
          schema:
            $ref: '#/components/schemas/report_definitions'
        text/csv:
          schema:
            $ref: '#/components/schemas/report_definitions'
      description: report_definitions
  schemas:
    report_definitions:
      description: >-
        Saved reports the caller may open: their own, their roles' and sites',
        and the organisation's.

        Which audience a report has is about whose register it is in, never
        about what it may show.
      properties:
        author_name:
          format: character varying
          maxLength: 200
          type: string
        category:
          format: character varying
          maxLength: 60
          type: string
        chart_type:
          format: character varying
          maxLength: 10
          type: string
        code:
          format: character varying
          maxLength: 60
          type: string
        columns:
          format: jsonb
        created_at:
          format: timestamp with time zone
          type: string
        created_by:
          description: >-
            Note:

            This is a Foreign Key to `capex_invite_candidates.id`.<fk
            table='capex_invite_candidates' column='id'/>
          format: uuid
          type: string
        description:
          format: text
          type: string
        filter_expression:
          format: jsonb
        id:
          description: |-
            Note:
            This is a Primary Key.<pk/>
          format: uuid
          type: string
        is_active:
          format: boolean
          type: boolean
        is_organization_wide:
          format: boolean
          type: boolean
        last_run_at:
          format: timestamp with time zone
          type: string
        mine:
          format: boolean
          type: boolean
        name:
          format: character varying
          maxLength: 150
          type: string
        order_by:
          format: character varying
          maxLength: 200
          type: string
        pivot_column:
          format: jsonb
        pivot_limit:
          format: smallint
          type: integer
        pivot_measures:
          format: jsonb
        pivot_rows:
          format: jsonb
        row_limit:
          format: integer
          type: integer
        run_count:
          format: integer
          type: integer
        schedules:
          format: bigint
          type: integer
        shared_role_ids:
          format: uuid[]
          items:
            type: string
          type: array
        shared_site_ids:
          format: uuid[]
          items:
            type: string
          type: array
        shared_with:
          format: text[]
          items:
            type: string
          type: array
        shared_with_me:
          format: boolean
          type: boolean
        show_subtotals:
          format: boolean
          type: boolean
        show_totals:
          format: boolean
          type: boolean
        source_view:
          format: character varying
          maxLength: 80
          type: string
        status:
          format: character varying
          maxLength: 20
          type: string
        updated_at:
          format: timestamp with time zone
          type: string
        visibility:
          format: character varying
          maxLength: 20
          type: string
      type: object

````