Sort Query Results
The order_by argument
Results from your query can be sorted by using the order_by argument. The argument can be used to sort nested objects
too.
The sort order (ascending vs. descending) is set by specifying the Asc or Desc enum value for the column name in the
order_by input object, e.g. {name: Desc}.
By default, for ascending ordering null values are returned at the end of the results and for descending ordering
null values are returned at the start of the results.
The order_by argument takes an array of objects to allow sorting by multiple columns.
You can also use nested objects' fields to sort the results. Only columns from object relationships** and **aggregates from array relationships** can be used for sorting.
The following are example queries for different sorting use cases:
Sorting objects
Example: Fetch a list of authors sorted by their names in ascending order:
Sorting nested objects
Example: Fetch a list of authors sorted by their names with a list of their articles that is sorted by their rating:
Sorting by Nested Object Fields
Only columns from object relationships can be used for sorting.
For object relationships
For object relationships only columns can be used for sorting.
Example: Fetch a list of articles that are sorted by their author's ids in descending order:
Sorting by multiple fields
Key order in input object for order_by is not preserved. This means you should only have a single key per object, or
you may see unexpected behavior.
