You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 19 Next »
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 |
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 | VALCHANGES |
| changes from | CHANGESFROM |
| changes to | CHANGESTO |
Script
| User name | System name |
|---|---|
| contains | LIKE |
| does not contain | NOTLIKE |
| is not empty | ISNOTEMPTY |
| is anything | ANYTHING |
| changes | VALCHANGES |
| changes from | CHANGESFROM |
| 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 | EMPTYSTRING |
| Less than or is | <= |
| Greater than or is | >= |
| Between | BETWEEN |
| Is same | SAMEAS |
| Is different | NSAMEAS |
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 |
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 |
- No labels
