> ## 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. # Each time a work order was raised and each time one was closed, one row apiece, dated when it happened. > Each time a work order was raised and each time one was closed, one row apiece, dated when it happened. The source for counting maintenance tickets by the month they happened in: a ticket raised in September and closed in October is in September's raised and October's closed, so a month can close more than it raised. Work orders whose type is planned are not included. `activity` is RAISED or CLOSED. A closing row exists only while the ticket is closed, and is within SLA or late by the ticket's recorded breach. `activity_year` and `activity_month` are the UTC year and month of `activity_at`, the same month a report groups the rows under. Each row carries where the job is (business unit, site and the top of its location branch) and who has it (team and technician), so a report can be narrowed by any of them. Rows are the work orders the caller can already see. ## OpenAPI ````yaml /api-reference/openapi.json get /work_order_activity 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: My work - name: Sites and locations - name: Assets - name: Asset lifecycle - name: Asset components - name: Kits - name: Work lifecycle - name: Work order execution - name: Work sequencing - name: Maintenance - name: Inspections - name: Checklists - name: Verification - name: Self verification - name: Inventory - name: Inventory detail - name: Parts demand - name: Procurement - name: Catalogue - name: Vendors and contracts - name: Contracts - name: Amendments - name: Vendor spend forecast - name: Workforce - name: Workforce detail - name: Capacity - name: Dispatch - name: Shutdown - name: Permits - name: Tools - name: Tools on jobs - name: Bookings - name: Booking hand over - name: Booking bills - name: Calibration history - name: Reliability - name: Sensors and meters - name: Readers - name: Trackers - name: Real-time location - name: Feeds - name: Energy - name: IT assets - name: IT asset software - name: IT asset topology - name: Warranty lookups - name: Map - name: Floor plans - name: Labels - name: Lost and found - name: Visitors - name: Root cause analysis - name: Costing - name: Finance - name: E-way bills - name: E-way bill filing - name: Budgets - name: Capex plans - name: Capex consolidation - name: Capex capitalization - name: FF&E plans - name: Documents - name: Document control - name: Document folders - name: Document tree - name: Knowledge - name: Reports - name: Dashboards - name: Extracts - name: Data exports - name: Audit center - name: Audit feed - name: Activity - name: Conversations - name: Notifications - name: Date reminders - name: Channels - name: Search - name: Copilot - name: Import - name: Bulk jobs - name: File exchange - name: Filing exceptions - name: Files - name: Sync - name: Support - name: API keys - name: Webhooks - name: MCP connections - name: MCP sign-in - name: SCIM provisioning - name: Directory sync - name: Security streams - name: Clarity - name: Single sign-on - name: Two-factor sign-in - name: Admin - name: Access - name: Lookups - name: Read models - name: Reference - name: Reference columns - name: Reference entry - name: List views - name: Mapping - name: Numbering - name: Branding - name: Custom fields - name: Form studio - name: Workflows - name: Workflow studio - name: Rules - name: Statuses and transitions - name: Currencies and locales - name: Today - 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: Setup - name: Features - name: Billing - name: Licence - name: Welcome - name: Tray - name: Tenant switch - name: Release - name: Upgrade - name: Telegram - name: Whatsapp - name: Inbound mail - name: Platform externalDocs: description: PostgREST Documentation url: https://postgrest.org/en/v12/references/api.html paths: /work_order_activity: get: tags: - Reports summary: >- Each time a work order was raised and each time one was closed, one row apiece, dated when it happened. description: >- Each time a work order was raised and each time one was closed, one row apiece, dated when it happened. The source for counting maintenance tickets by the month they happened in: a ticket raised in September and closed in October is in September's raised and October's closed, so a month can close more than it raised. Work orders whose type is planned are not included. `activity` is RAISED or CLOSED. A closing row exists only while the ticket is closed, and is within SLA or late by the ticket's recorded breach. `activity_year` and `activity_month` are the UTC year and month of `activity_at`, the same month a report groups the rows under. Each row carries where the job is (business unit, site and the top of its location branch) and who has it (team and technician), so a report can be narrowed by any of them. Rows are the work orders the caller can already see. parameters: - $ref: '#/components/parameters/rowFilter.work_order_activity.work_order_id' - $ref: >- #/components/parameters/rowFilter.work_order_activity.work_order_number - $ref: '#/components/parameters/rowFilter.work_order_activity.title' - $ref: '#/components/parameters/rowFilter.work_order_activity.activity' - $ref: '#/components/parameters/rowFilter.work_order_activity.activity_at' - $ref: '#/components/parameters/rowFilter.work_order_activity.activity_year' - $ref: '#/components/parameters/rowFilter.work_order_activity.activity_month' - $ref: >- #/components/parameters/rowFilter.work_order_activity.closed_within_sla - $ref: '#/components/parameters/rowFilter.work_order_activity.closed_late' - $ref: >- #/components/parameters/rowFilter.work_order_activity.status_category - $ref: >- #/components/parameters/rowFilter.work_order_activity.business_unit_id - $ref: >- #/components/parameters/rowFilter.work_order_activity.business_unit_name - $ref: '#/components/parameters/rowFilter.work_order_activity.site_id' - $ref: '#/components/parameters/rowFilter.work_order_activity.site_name' - $ref: >- #/components/parameters/rowFilter.work_order_activity.top_location_id - $ref: >- #/components/parameters/rowFilter.work_order_activity.top_location_name - $ref: '#/components/parameters/rowFilter.work_order_activity.location_id' - $ref: >- #/components/parameters/rowFilter.work_order_activity.assigned_team_id - $ref: >- #/components/parameters/rowFilter.work_order_activity.assigned_team_name - $ref: >- #/components/parameters/rowFilter.work_order_activity.assigned_worker_id - $ref: >- #/components/parameters/rowFilter.work_order_activity.assigned_worker_name - $ref: '#/components/parameters/rowFilter.work_order_activity.problem_code' - $ref: '#/components/parameters/select' - $ref: '#/components/parameters/order' - $ref: '#/components/parameters/range' - $ref: '#/components/parameters/rangeUnit' - $ref: '#/components/parameters/offset' - $ref: '#/components/parameters/limit' - $ref: '#/components/parameters/preferCount' responses: '200': content: application/json: schema: items: $ref: '#/components/schemas/work_order_activity' type: array application/vnd.pgrst.object+json: schema: items: $ref: '#/components/schemas/work_order_activity' type: array application/vnd.pgrst.object+json;nulls=stripped: schema: items: $ref: '#/components/schemas/work_order_activity' type: array text/csv: schema: items: $ref: '#/components/schemas/work_order_activity' type: array description: OK '206': description: Partial Content components: parameters: rowFilter.work_order_activity.work_order_id: in: query name: work_order_id required: false schema: type: string rowFilter.work_order_activity.work_order_number: in: query name: work_order_number required: false schema: type: string rowFilter.work_order_activity.title: in: query name: title required: false schema: type: string rowFilter.work_order_activity.activity: in: query name: activity required: false schema: type: string rowFilter.work_order_activity.activity_at: in: query name: activity_at required: false schema: type: string rowFilter.work_order_activity.activity_year: in: query name: activity_year required: false schema: type: string rowFilter.work_order_activity.activity_month: in: query name: activity_month required: false schema: type: string rowFilter.work_order_activity.closed_within_sla: in: query name: closed_within_sla required: false schema: type: string rowFilter.work_order_activity.closed_late: in: query name: closed_late required: false schema: type: string rowFilter.work_order_activity.status_category: in: query name: status_category required: false schema: type: string rowFilter.work_order_activity.business_unit_id: in: query name: business_unit_id required: false schema: type: string rowFilter.work_order_activity.business_unit_name: in: query name: business_unit_name required: false schema: type: string rowFilter.work_order_activity.site_id: in: query name: site_id required: false schema: type: string rowFilter.work_order_activity.site_name: in: query name: site_name required: false schema: type: string rowFilter.work_order_activity.top_location_id: in: query name: top_location_id required: false schema: type: string rowFilter.work_order_activity.top_location_name: in: query name: top_location_name required: false schema: type: string rowFilter.work_order_activity.location_id: in: query name: location_id required: false schema: type: string rowFilter.work_order_activity.assigned_team_id: in: query name: assigned_team_id required: false schema: type: string rowFilter.work_order_activity.assigned_team_name: in: query name: assigned_team_name required: false schema: type: string rowFilter.work_order_activity.assigned_worker_id: in: query name: assigned_worker_id required: false schema: type: string rowFilter.work_order_activity.assigned_worker_name: in: query name: assigned_worker_name required: false schema: type: string rowFilter.work_order_activity.problem_code: in: query name: problem_code required: false schema: type: string select: description: Filtering Columns in: query name: select required: false schema: type: string order: description: Ordering in: query name: order required: false schema: type: string range: description: Limiting and Pagination in: header name: Range required: false schema: type: string rangeUnit: description: Limiting and Pagination in: header name: Range-Unit required: false schema: default: items type: string offset: description: Limiting and Pagination in: query name: offset required: false schema: type: string limit: description: Limiting and Pagination in: query name: limit required: false schema: type: string preferCount: description: Preference in: header name: Prefer required: false schema: enum: - count=none type: string schemas: work_order_activity: description: >- Each time a work order was raised and each time one was closed, one row apiece, dated when it happened. The source for counting maintenance tickets by the month they happened in: a ticket raised in September and closed in October is in September's raised and October's closed, so a month can close more than it raised. Work orders whose type is planned are not included. `activity` is RAISED or CLOSED. A closing row exists only while the ticket is closed, and is within SLA or late by the ticket's recorded breach. `activity_year` and `activity_month` are the UTC year and month of `activity_at`, the same month a report groups the rows under. Each row carries where the job is (business unit, site and the top of its location branch) and who has it (team and technician), so a report can be narrowed by any of them. Rows are the work orders the caller can already see. properties: activity: format: text type: string activity_at: format: timestamp with time zone type: string activity_month: format: integer type: integer activity_year: format: integer type: integer assigned_team_id: description: |- Note: This is a Foreign Key to `teams.id`. format: uuid type: string assigned_team_name: format: character varying maxLength: 200 type: string assigned_worker_id: description: >- Note: This is a Foreign Key to `assignable_workers.id`. format: uuid type: string assigned_worker_name: format: character varying maxLength: 200 type: string business_unit_id: description: >- Note: This is a Foreign Key to `business_units.id`. format: uuid type: string business_unit_name: format: character varying maxLength: 200 type: string closed_late: format: boolean type: boolean closed_within_sla: format: boolean type: boolean location_id: description: >- Note: This is a Foreign Key to `location_settings.id`. format: uuid type: string problem_code: format: character varying maxLength: 80 type: string site_id: description: >- Note: This is a Foreign Key to `entry_currencies.for_site_id`. format: uuid type: string site_name: format: character varying maxLength: 200 type: string status_category: format: character varying maxLength: 20 type: string title: format: character varying maxLength: 250 type: string top_location_id: format: uuid type: string top_location_name: format: text type: string work_order_id: description: |- Note: This is a Primary Key. format: uuid type: string work_order_number: format: character varying maxLength: 60 type: string type: object ```` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.