Pagination, sorting, and filtering

Tesouro’s GraphQL API supports pagination and filtering on collection queries.

Pagination

Collection queries accept a paging input with two fields:

Field	Type	Description
`skip`	`Int!`	The number of records to skip (offset).
`take`	`Int!`	The number of records to return per page.

Each collection query returns a pageInfo object alongside the result items:

Field	Type	Description
`hasNextPage`	`Boolean!`	Whether more records exist after this page.
`hasPreviousPage`	`Boolean!`	Whether records exist before this page.

Example

query ListItems($input: ListItemsInput!) {
  listItems(input: $input) {
    items {
      id
      createdAt
      status
    }
    pageInfo {
      hasNextPage
      hasPreviousPage
    }
  }
}

Variables

{
  "input": {
    "paging": {
      "skip": 0,
      "take": 25
    }
  }
}

To retrieve the next page, increment skip by the take value:

{
  "input": {
    "paging": {
      "skip": 25,
      "take": 25
    }
  }
}

Continue paginating until pageInfo.hasNextPage is false.

Filtering

Collection queries accept a where input containing typed filter fields. The available filter fields vary by query. Common filter input types include:

Filter type	Operators	Description
`GuidFilterInput`	`eq`, `in`	Filter by a single UUID or a list of UUIDs.
`StringFilterInput`	`eq`, `in`	Filter by exact string match or a list of strings.
`DateRangeFilterInput`	`gte`, `lte`	Filter by a date range (inclusive).
`EnumFilterInput`	`eq`, `in`, `nin`	Filter by enum value, inclusion, or exclusion.

Refer to the schema reference for each query to see its available filter fields and types.

Rate limiting Playground

⌘I

Getting started

Authentication

Applications

Stakeholders

Decision components

Information requests

Webhooks

Pagination, sorting, and filtering

Example

Filtering

​Pagination

​Example

​Filtering

Pagination

Example

Filtering