reportQuery
Execute a MicroSQL reporting query against the analytics schema. Supports SELECT with WHERE, JOIN, ORDER BY, GROUP BY, LIMIT. Tenant isolation is enforced automatically. Covers production (jobs, components, operations, milestones), prepress, scheduling (work_centers, planned_operations, schedule_allocations), sales (estimates, orders, invoices), cost accounting, catalog/inventory (products, substrates, warehouse_stock), logistics (shipments), tasks, time-series (metric_points, progress_points), and people (users, teams). Per-table IAM authorization is enforced — requires :list on each table's resource.
Arguments
queryString!MicroSQL query string (restricted SQL dialect)
Returns ReportQueryPayload!
Scalar fields at a glance
headers[String!]!rows[[JSON!]!]!rowCountInt!limitInttruncatedBoolean!nextOffsetIntExplore in a view
View exact SDL
"""
Execute a MicroSQL reporting query against the analytics schema. Supports SELECT with WHERE, JOIN, ORDER BY, GROUP BY, LIMIT. Tenant isolation is enforced automatically. Covers production (jobs, components, operations, milestones), prepress, scheduling (work_centers, planned_operations, schedule_allocations), sales (estimates, orders, invoices), cost accounting, catalog/inventory (products, substrates, warehouse_stock), logistics (shipments), tasks, time-series (metric_points, progress_points), and people (users, teams). Per-table IAM authorization is enforced — requires :list on each table's resource.
"""
reportQuery(
"""MicroSQL query string (restricted SQL dialect)"""
query: String!
): ReportQueryPayload! @topic(names: ["reporting", "aiml"])Schema reference describes the API contract. Actual access is checked by the platform for every operation.