Learn how to filter results using the APIs
GET https://api.basic.tech/account/{project_id}/db/{table}
endpoint as query params.
filter
)filter(conditions)
order
)order(field, direction?)
(direction
defaults to ‘asc’)limit
, offset
)limit(count)
, offset(count)
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 |
?field=gte.x<e.y
) not supportedGET https://api.basic.tech/account/{project_id}/db/{table}