On this page, operators separated by type of condition are listed.
Please pay attention that these are condition types, not the system types listed in the Column Type (sys_db_column_type) table. |
In the first column, the user operator name is specified.
In the second column, the system operator name is specified, which is usable in condition strings.
Boolean
| User name | System name |
|---|---|
| Is | = |
| Is not | != |
| Is same | SAMEAS |
| Is different | NSAMEAS |
| Is empty | ISEMPTY |
| Is not empty | ISNOTEMPTY |
| Is anything | ANYTHING |
| Is (calculated) | IS_CALCULATED |
To use the IS_CALCULATED operator, you need to configure it as a column extra attribute first. |
Choice
| User name | System name |
|---|---|
| Is | = |
| Is not | != |
| Is one of | IN |
| Is not one of | NOT IN |
| Contains | LIKE |
| Starts with | STARTSWITH |
| Ends with | ENDSWITH |
| Is empty | ISEMPTY |
| Is not empty | ISNOTEMPTY |
| Less than | < |
| Greater than | > |
| Less than or is | <= |
| Greater than or is | >= |
| Between | BETWEEN |
| Is anything | ANYTHING |
| Is same | SAMEAS |
| Is different | NSAMEAS |
| Is (calculated) | IS_CALCULATED |
Datetime
| User name | System name |
|---|---|
| Changes | VALCHANGES |
| Changes from | CHANGESFROM |
| Changes to | CHANGESTO |
On | ON |
| Not on | NOTON |
| Before | < |
| After | > |
| At or before | <= |
| At or after | >= |
| Between | BETWEEN |
| Is empty | ISEMPTY |
| Is not empty | ISNOTEMPTY |
| Is anything | ANYTHING |
| Is same | SAMEAS |
| Is different | NSAMEAS |
| Is (calculated) | IS_CALCULATED |
Fieldname
| User name | System name |
|---|---|
| Starts with | STARTSWITH |
| Ends with | ENDSWITH |
| Changes | VALCHANGES |
| Changes from | CHANGESFROM |
| Changes to | CHANGESTO |
| Contains | LIKE |
| Does not contain | NOTLIKE |
| Is empty | ISEMPTY |
| Is not empty | ISNOTEMPTY |
| Is anything | ANYTHING |
| Is (calculated) | IS_CALCULATED |
Keywords
| User name | System name |
|---|---|
| Are | ARE |
| Changes | VALCHANGES |
| Changes from | CHANGESFROM |
| Changes to | CHANGESTO |
| Is (calculated) | IS_CALCULATED |
Image
| User name | System name |
|---|---|
| Changes | VALCHANGES |
| Changes from | CHANGESFROM |
| Changes to | CHANGESTO |
| Is empty | ISEMPTY |
| Is not empty | ISNOTEMPTY |
| Is (calculated) | IS_CALCULATED |
List
| User name | System name |
|---|---|
| Changes | VALCHANGES |
| Changes from | CHANGESFROM |
| Changes to | CHANGESTO |
| Has | HAS |
| Has not | HASNOT |
| Is empty | ISEMPTY |
| Is not empty | ISNOTEMPTY |
| Is | = |
| Is not | != |
| Contains (dynamic) | CONTAINS_DYNAMIC |
| Does not contain (dynamic) | DOESNOTCONTAIN_DYNAMIC |
| Contains | LIKE |
| Is (calculated) | IS_CALCULATED |
Big Integer, Decimal, Float, Integer, Numeric, Percent Complete, Percent Decimal, Small Integer
| User name | System name |
|---|---|
| Changes | VALCHANGES |
| Changes from | CHANGESFROM |
| Changes to | CHANGESTO |
| Is | = |
| Is not | != |
| Is one of | IN |
| Is empty | ISEMPTY |
| Is not empty | ISNOTEMPTY |
| Is anything | ANYTHING |
| Less than | < |
| Greater than | > |
| Less than or is | <= |
| Greater than or is | >= |
| Between | BETWEEN |
| Is same | SAMEAS |
| Is different | NSAMEAS |
| Greater than field | GT_FIELD |
| Less than field | LT_FIELD |
| Greater than or is field | GT_OR_EQUALS_FIELD |
| Less than or is field | LT_OR_EQUALS_FIELD |
| Is (calculated) | IS_CALCULATED |
Reference
| User name | System name |
|---|---|
| Changes | VALCHANGES |
| Changes from | CHANGESFROM |
| Changes to | CHANGESTO |
| Starts with | STARTSWITH |
| Ends with | ENDSWITH |
| Contains | LIKE |
| Does not contain | NOTLIKE |
| Is | = |
| Is not | != |
| Is one of | IN |
| Is empty | ISEMPTY |
| Is not empty | ISNOTEMPTY |
| Is anything | ANYTHING |
| Is same | SAMEAS |
| Is different | NSAMEAS |
| Is (dynamic) | DYNAMIC |
| Is not (dynamic) | ISNOT_DYNAMIC |
| Is (calculated) | IS_CALCULATED |
Record Class field
| User name | System name |
|---|---|
| Starts with | STARTSWITH |
| Ends with | ENDSWITH |
| Contains | LIKE |
| Does not contain | NOTLIKE |
| Is | = |
| Is not | != |
| Is one of | IN |
| Сhanges | VALCHANGES |
| Сhanges from | CHANGESFROM |
| Сhanges to | CHANGESTO |
| Is (calculated) | IS_CALCULATED |
Script
| User name | System name |
|---|---|
| Сontains | LIKE |
| Does not contain | NOTLIKE |
| Is not empty | ISNOTEMPTY |
| Is anything | ANYTHING |
| Changes | VALCHANGES |
| Changes from | CHANGESFROM |
| Changes to | CHANGESTO |
| Is (calculated) | IS_CALCULATED |
String, Text
| User name | System name |
|---|---|
| Starts with | STARTSWITH |
| Ends with | ENDSWITH |
| Contains | LIKE |
| Does not contain | NOTLIKE |
| Is | = |
| Is not | != |
| Is empty | ISEMPTY |
| Is not empty | ISNOTEMPTY |
| Is anything | ANYTHING |
| Is empty string | EMPTYSTRING |
| Is same | SAMEAS |
| Is different | NSAMEAS |
| Is (calculated) | IS_CALCULATED |
Time
| User name | System name |
|---|---|
| Contains | LIKE |
| On | ON |
| Not on | NOTON |
| Before | < |
| After | > |
| At or before | <= |
| At or after | >= |
| Between | BETWEEN |
| Is empty | ISEMPTY |
| Is not empty | ISNOTEMPTY |
| Is anything | ANYTHING |
| Is same | SAMEAS |
| Is different | NSAMEAS |
| Changes | VALCHANGES |
| Changes from | CHANGESFROM |
| Changes to | CHANGESTO |
| Is (calculated) | IS_CALCULATED |
Timestamp
| User name | System name |
|---|---|
| Contains | LIKE |
| On | ON |
| Not on | NOTON |
| Before | < |
| After | > |
| At or before | <= |
| At or after | >= |
| Between | BETWEEN |
| Is empty | ISEMPTY |
| Is not empty | ISNOTEMPTY |
| Is anything | ANYTHING |
| Is same | SAMEAS |
| Is different | NSAMEAS |
| Changes | VALCHANGES |
| Changes from | CHANGESFROM |
| Changes to | CHANGESTO |
| Is (calculated) | IS_CALCULATED |