guides
Filtering, ordering, pagination
Learn how to filter results using the APIs
Querying
Chain after GET https://api.basic.tech/account/{project_id}/db/{table}
endpoint as query params.
Filtering (filter
)
- Method:
filter(conditions)
- Supported Operators: eq, neq, gt, gte, lt, lte, like, ilike, in, not (see list of operators)
Ordering (order
)
- Method:
order(field, direction?)
(direction
defaults to ‘asc’)
Pagination (limit
, offset
)
- Methods:
limit(count)
,offset(count)
Supported operators
Operator | Description | Example |
---|---|---|
eq | Equality | status=eq.active |
neq | Not equal | status=neq.deleted |
gt | Greater than | priority=gt.3 |
gte | Greater than or equal | priority=gte.3 |
lt | Less than | priority=lt.3 |
lte | Less than or equal | priority=lte.3 |
like | Pattern (case sensitive) | title=like.*project* |
ilike | Pattern (case insensitive) | title=ilike.*todo* |
in | Value in set | tags=in.work,important |
not | Negation | tags=not.eq.work |
Limitations
- Only one filterable condition per field per query (no compound filters across multiple fields)
- Range filters (e.g.,
?field=gte.x<e.y
) not supported - Method chaining order is flexible, but all must be chained after
GET https://api.basic.tech/account/{project_id}/db/{table}