...
| 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 null operator | f / fa | NotNull | SQL is not null operator(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 |
...