Page History
...
Each key pair expression is evaluated using a single operator. Certain operators are only applicable to certain data types. Below is a list of all available operators and the data types for which they are applicable.
Operator | Description | Data Types |
---|---|---|
= | Equals | Text, Integer, Number, Datetime, UUID, Array (in) |
> | Greater Than | Text, Integer, Number, Datetime |
< | Less Than | Text, Integer, Number, Datetime |
>= | Greater Than or Equal To | Text, Integer, Number, Datetime |
<= | Less Than or Equal To | Text, Integer, Number, Datetime |
!= | NOT Equal To | Text, Integer, Number, Datetime, UUID, Array (not in) |
like | SQL Like use with '%' wildcards | Text |
not like | SQL Not Like use with '%' wildcards | Text |
Operator modifiers
Modifiers can be defined for an operator, multiple modifiers can be combined for a relation item.
Modifier | Description |
---|---|
case-insensitive | case-Insensitive comparison |
or-is-null | allow null values in the value (will result in sql <cond> or column is null) |
remove-when-null | remove the condition when the value is null, this is usually used |
icw a global variable holding an array of values |
Note | ||
---|---|---|
Text-Based Expressions Expressions which contain the SQL Like or SQL NOT Like operators should be used in conjunction with values that contain wildcards (%).
|
...