Query Reports

Use the report query to fetch a single report by id, and the reports query to list the reports you can see in an organization. A report aggregates records (Todo objects) from one or more workspaces into a saved analytical view; these two queries read the report’s metadata and configuration. To read the records, counts, and aggregations a report produces, see Report Data & Aggregations.

Both queries are visibility-scoped: you only ever see a report you created or one that has been shared with you.

Request

Fetch one report by id with its data sources:

query GetReport {
  report(id: "report_123") {
    id
    title
    description
    lastGeneratedAt
    projectIds
    createdBy {
      fullName
    }
    dataSources {
      id
      name
      sourceType
      projectIds
      order
    }
  }
}

List the reports you can see in an organization, newest-updated first:

query ListReports {
  reports(filter: { companyId: "company_123" }, skip: 0, take: 20) {
    totalCount
    hasNextPage
    hasPreviousPage
    items {
      id
      title
      updatedAt
    }
  }
}

The organization is identified by companyId (accepts the organization ID or slug). The report query is identified by the report’s id.

Parameters

report arguments

reports arguments

ReportFilter

Listing every report in an organization

adminView: true drops the created-by / shared-with restriction, so the list returns every report in companyId. Use it to reach reports left behind by people who have left the organization.

The server proves the caller’s membership rather than trusting the flag: it checks for an OWNER or ADMIN CompanyUser row in that same companyId. A caller who is neither is silently narrowed to their normal scope rather than refused — the query succeeds and simply returns their own visible reports. Because the check is against the requested organization, passing another organization’s id reaches nothing.

Response

report:

{
  "data": {
    "report": {
      "id": "clm4n8qwx000008l0g4oxdqn7",
      "title": "Q3 Delivery Pipeline",
      "description": "Open work across the delivery workspaces.",
      "lastGeneratedAt": "2026-05-28T09:14:22.000Z",
      "projectIds": ["clm4projalpha0001", "clm4projbeta00002"],
      "createdBy": { "fullName": "Dana Reyes" },
      "dataSources": [
        {
          "id": "clm4dsrc00000abcd1234",
          "name": "Delivery",
          "sourceType": "TODOS",
          "projectIds": ["clm4projalpha0001", "clm4projbeta00002"],
          "order": 0
        }
      ]
    }
  }
}

reports:

{
  "data": {
    "reports": {
      "totalCount": 3,
      "hasNextPage": false,
      "hasPreviousPage": false,
      "items": [
        {
          "id": "clm4n8qwx000008l0g4oxdqn7",
          "title": "Q3 Delivery Pipeline",
          "updatedAt": "2026-05-28T09:14:22.000Z"
        },
        {
          "id": "clm4r2abc000108l0aaaa1111",
          "title": "Support Backlog",
          "updatedAt": "2026-05-21T16:02:10.000Z"
        },
        {
          "id": "clm4r9def000208l0bbbb2222",
          "title": "Marketing Calendar",
          "updatedAt": "2026-05-19T11:48:55.000Z"
        }
      ]
    }
  }
}

ReportPagination

Report

The Report type also exposes the todos, todoCount, and aggregations fields. Those are the report’s data surface and are documented on Report Data & Aggregations, which also covers the TodosFilter/TodosSort inputs (shared with the Records section).

ReportDataSource

ReportSourceType

Errors

Both queries require an authenticated user. report raises REPORT_NOT_FOUND rather than returning null when the report is invisible to you, so a missing report and a forbidden one are indistinguishable by design. reports never errors on visibility — it simply omits reports you cannot see.

Permissions

Report visibility is per-report, independent of workspace membership:

• report (view) — succeeds only if you are the report’s createdBy or appear in its reportUsers (with either EDITOR or VIEWER role).
• reports (list) — returns every report in filter.companyId that you created or that was shared with you, sorted by updatedAt descending. Reports you cannot see are silently excluded; the createdById filter narrows this set further. An organization OWNER or ADMIN can pass adminView: true to widen the list to every report in that organization.

Modifying, deleting, and exporting reports have their own (different) access tiers — see Manage Report Access, Duplicate & Delete a Report, and Export a Report.

Related

• Reports overview
• Create a Report
• Report Data & Aggregations
• Manage Report Access
• Duplicate & Delete a Report
• Export a Report
• Records