...
Operator | Syntax | Syntax example | Description |
---|---|---|---|
LIKE ILIKE | LIKE ILIKE |
| Compares field data and value. The |
EQUALS NOT_EQUALS | = != |
| Field data and value for equality / inequality. |
IN | IN |
| Checks whether the field's value data is equal to any of the given values. |
LESS_THEN GREATER_THEN GREATER_OR_EQUAL LESS_OR_EQUAL | < > >= <= |
| Checks whether field data is greater, greater equal, less, less or equal than the value given. |
CONTAINS | CONTAINS |
| Checks that all given values are contained in the field data |
Conjunctions
Conjunction | Example | Description |
---|---|---|
AND |
| Result must match both the left-hand and the right-hand part of the IQL |
OR |
| Result must match either the left-hand or the right-hand part of the IQL |
...