Pagination and sorting
| Parameter | Description |
|---|---|
| _limit | Maximum number of records. |
| _start | Zero-based offset. |
| _sort | Sort expression with direction, example field:desc. |
| select_fields | Comma-separated response field projection. |
Comparison suffixes
Common suffixes include _ne, _lt, _lte, _gt, _gte, and _in.
Pattern suffixes
Use _contains, _like, _ilike, _rlike, _llike, and _ncontains to generate LIKE conditions.
Null and empty checks
- _nn: IS NOT NULL
- _inn: IS NULL
- _nie: non-empty string
- _ie: empty string
Example
GET /api/datalist/metadata/products?category=electronics&price_gte=100&price_lte=500&status_ne=discontinued&name_ilike=proAll filters are combined with AND in the resulting SQL WHERE clause.