Sorting

Sort order

The sort order (ascending vs. descending) is set by specifying an ASC or DESC suffix for the column name in the orderBy input object, e.g. title_DESC. Nullable fields also provide _ASC_NULLS_FIRST, _ASC_NULLS_LAST, _DESC_NULLS_FIRST, and _DESC_NULLS_LAST variants. OpenReader can sort one level into object or relation fields, for example author_name_ASC. Queryable interfaces additionally expose _type_ASC and _type_DESC.

Sorting entities

Example: Fetch a list of videos sorted by their titles in an ascending order:

query {
  videos(orderBy: title_ASC) {
    id
    title
  }
}

query {
  videos(orderBy: [title_ASC]) {
    id
    title
  }
}

Sorting entities by multiple fields

The orderBy argument takes an array of fields to allow sorting by multiple columns. Example: Fetch a list of videos that is sorted by their titles (ascending) and then on their published date (descending):

query {
  videos(orderBy: [title_ASC, publishedOn_DESC]) {
    id
    title
    publishedOn
  }
}

AND/OR filters

OpenReader Pagination

⌘I

Overview

Pipes SDK

Squid SDK

Alternative clients

Sort order

Sorting entities

Sorting entities by multiple fields

​Sort order

​Sorting entities

​Sorting entities by multiple fields

Sort order

Sorting entities

Sorting entities by multiple fields