...
| In Query | Meaning | Valid for <type> |
|---|---|---|
eq | = | f |
lte | <= | f |
lt | < | f |
gte | >= | f |
gt | > | f |
like | SQL LIKE operator | f |
ilike | SQL ILIKE operator | f |
| isnull | SQL is (not) null operator value: "true","t","1" (= is Null) or "false","f","0" (= is not Null) | f / fa |
| contains | array field contains all of the values | fa |
| containedby | array field is contained by by the list of values | fa |
| overlap | array field and list of values overlap | fa |
If no operator is given the default default eq operator operator will be used for fields and contains for arrays.
Examples
"data" is a database field of type JSON, you can even query into the JSON structure.
Please note that these fields are not indexed. For performance reasons always limit the result set e.g. by setting a date range.
| Code Block | ||
|---|---|---|
| ||
# Query JSON field "data.mbus.Id" for a number
&f:data.mbus.Id=eq:130567728
# Query JSON field "data.mbus.IdString" for a string
&f:data.mbus.IdString=eq:"10130567728" |
To filter a date range, the same filter can be applied multiple times with different operators
| Code Block | ||
|---|---|---|
| ||
&f:createdAt=gt:2000-01-01T02:37:00%2B01:00?f:createdAt=lt:2000-01-02T02:37:00%2B01:00 |
Usage recommendations
- Set the gzip encoding header to reduce network traffic:
Accept-Encoding:gzip
- Use pagination with page sizes smaller than 10.000 entries
...