...
| Code Block |
|---|
"Table Name_Columnname" = "value1" and "Table Name_Columnname" = "value2" |
Column Type | Supported operators | Functions | Keywords |
|---|---|---|---|
Simple Text | ~ , !~ , is not , is | EMPTY | |
Number | = , != , <= , >= , > , < , is not , is , not in , in | EMPTY, ORDER BY (ASC / DESC) | |
Decimal Number | = , != , <= , >= , > , < , is not , is , not in , in | EMPTY, ORDER BY (ASC / DESC) | |
Date | = , != , <= , >= , > , < , is not , is , not in , in | currentLogin(), endOfDay(), endOfMonth(), endOfWeek(), endOfYear(), lastLogin(), now(), startOfDay(), startOfMonth(), startOfWeek(), startOfYear() | EMPTY, ORDER BY (ASC / DESC) |
Select List | = , !=, is not , is , not in , in | ORDER BY (ASC / DESC), EMPTY | |
Status | = , != , is not , is , not in , in | EMPTY | |
User Picker | = , != , is not , is, not in, in | EMPTY, ORDER BY (ASC / DESC) | |
Checkbox | = , != , is not , is, not in, in | unchecked, ORDER BY (ASC / DESC) | |
Formula | = , != , <= , >= , > , < , is not , is , not in , in | EMPTY, ORDER BY (ASC / DESC) |