Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
On this page, operators separated by type of condition are listed.
| Note |
|---|
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 |
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 |
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 |
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 empty string | EMPTYSTRING |
Keywords
| User name | System name |
|---|---|
| Are | ARE |
| Changes | VALCHANGES |
| Changes from | CHANGESFROM |
| Changes to | CHANGESTO |
Image
| User name | System name |
|---|---|
| Changes | VALCHANGES |
| Changes from | CHANGESFROM |
| Changes to | CHANGESTO |
| Is empty | ISEMPTY |
| Is not empty | ISNOTEMPTY |
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 |
Numeric, Decimal, Percent Decimal, Percent Complete, Float, Small Integer, Integer, Big 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 |
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 |
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 |
| changesСhanges | VALCHANGES |
| changes Сhanges from | CHANGESFROM |
| changes Сhanges to | CHANGESTO |
Script
| User name | System name |
|---|---|
| containsСontains | LIKE |
| does Does not contain | NOTLIKE |
| is Is not empty | ISNOTEMPTY |
| is Is anything | ANYTHING |
| changesChanges | VALCHANGES |
| changes Changes from | CHANGESFROM |
| changes Changes to | CHANGESTO |
String, Text
| 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 empty string | EMPTYSTRINGLess than or is | <= | |
| Greater than or is | >= | ||
| Between | BETWEEN | ||
| Is same | SAMEAS | ||
| Is different | NSAMEAS |
Time
| User name | System name |
|---|---|
| containsContains | LIKE |
| onOn | ON |
| not Not on | NOTON |
| beforeBefore | < |
| afterAfter | > |
| at At or before | <= |
| at At or after | >= |
| betweenBetween | BETWEEN |
| is Is empty | ISEMPTY |
| is Is not empty | ISNOTEMPTY |
| is Is anything | ANYTHING |
| is Is same | SAMEAS |
| is Is different | NSAMEAS |
| changesChanges | VALCHANGES |
| changes Changes from | CHANGESFROM |
| changes Changes to | CHANGESTO |
Timestamp
| User name | System name |
|---|---|
| containsContains | LIKE |
| onOn | ON |
| not Not on | NOTON |
| beforeBefore | < |
| afterAfter | > |
| at At or before | <= |
| at At or after | >= |
| betweenBetween | BETWEEN |
| is Is empty | ISEMPTY |
| is Is not empty | ISNOTEMPTY |
| is Is anything | ANYTHING |
| is Is same | SAMEAS |
| is Is different | NSAMEAS |
| changesChanges | VALCHANGES |
| changes Changes from | CHANGESFROM |
| changes Changes to | CHANGESTO |
| Table of Contents | ||||
|---|---|---|---|---|
|