Searches#

The storages filter, sort and page the resources in the database. The following table lists what a search supports:

Feature

Support

Comparison operators

eq, ne, co, sw, ew, gt, ge, lt, le, and pr.

Logical operators

and, or, not, and value selections such as emails[type eq "work"].

Filtered attributes

Columns, hybrid properties, the entries of a Many, and the value and the display name of a Link.

Sorted attributes

Columns, hybrid properties, and the entries of a Many, on the primary entry or else the first one.

Pagination

startIndex and count. Cursors are not supported.

Resource types

One, or every resource type for a search at the root of the server.

A string compares in the form the comparison key of the policy gives it: exactly on SQLite, and approximately on PostgreSQL. How the storage works describes each database.

A resource without a value sorts last when ascending, and first when descending. An attribute the resource type does not declare matches no resource.