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

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.

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