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
| Operator Display 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 |
| Tip |
|---|
To use the IS_CALCULATED operator, you need to configure it as a column extra attribute first. This attribute allows to use scripts as a condition value. |
Choice
| Operator Display Name | System name |
|---|---|
| is | = |
| is not | != |
| is one of | IN |
| is not one of | NOT IN |
| contains | LIKE |
| does not contain | NOTLIKE |
| 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
| Operator Display 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 |
| contains | LIKE |
| does not contain | NOTLIKE |
| is empty | ISEMPTY |
| is not empty | ISNOTEMPTY |
| is anything | ANYTHING |
| is same | SAMEAS |
| is different | NSAMEAS |
| year is | |
| month is | |
| quarter is | |
| week is | |
| day is | |
| day od week is | |
| hour is | |
| is (calculated) | IS_CALCULATED |
Fieldname
| Operator Display Name | System name |
|---|---|
| contains | LIKE |
| does not contain | NOTLIKE |
| 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
| Operator Display Name | System name |
|---|---|
| are | ARE |
| changes | VALCHANGES |
| changes from | CHANGESFROM |
| changes to | CHANGESTO |
| is (calculated) | IS_CALCULATED |
Image
| Operator Display Name | System name |
|---|---|
| changes | VALCHANGES |
| changes from | CHANGESFROM|
| changes to | CHANGESTO |
| is empty | ISEMPTY |
| is not empty | ISNOTEMPTY |
| is (calculated) | IS_CALCULATED |
List
| Operator Display Name | System name | ||
|---|---|---|---|
| changes | VALCHANGES | ||
| changes from | CHANGESFROM|||
| changes to | CHANGESTO | ||
| has | HAS | ||
| has not | HASNOT | ||
| is | emptyISEMPTY | = | |
| is not empty | ISNOTEMPTY | ||
| is | = | ||
| is not | != | ||
| != | |||
| contains | LIKE | ||
| does not contain | NOTLIKE | ||
| is empty | ISEMPTY | ||
| is not empty | ISNOTEMPTY | is one of | IN|
| contains (dynamic) | CONTAINS_DYNAMIC | ||
| does not contain (dynamic) | DOESNOTCONTAIN_DYNAMICcontains | ||
| is one of | LIKEIN | ||
| is (calculated) | IS_CALCULATED |
Big Integer, Decimal, Float, Integer, Numeric, Percent Complete, Percent Decimal, Small Integer
| Operator Display Name | System name |
|---|---|
| changes | VALCHANGES |
| 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 empty | ISEMPTY |
| is not empty | ISNOTEMPTY |
| is anything | ANYTHING |
| is (dynemic) | DYNAMIC |
| is (calculated) | IS_CALCULATED |
Reference
| Operator Display Name | System name | ||
|---|---|---|---|
| changesis | VALCHANGES= | ||
| changes from | CHANGESFROM | ||
| changes to | CHANGESTO | ||
| starts with | STARTSWITH | ||
| ends with | ENDSWITH | ||
| is not | != | ||
| is one of | IN | ||
| contains | LIKE | ||
| does not contain | NOTLIKEis | ||
| starts with | =STARTSWITH | ||
| is not | != | ||
| ends with | ENDSWITH | 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
| Operator Display 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 | ||
| contains | LIKE | ||
| does not contain | NOTLIKE | ||
| starts with | STARTSWITH | ||
| ends with | ENDSWITH | changes to | CHANGESTO|
| is (calculated) | IS_CALCULATED |
Script
| Operator Display Name | System name | ||
|---|---|---|---|
| contains | 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
| Operator Display Name | System name | ||
|---|---|---|---|
| contains | LIKE | ||
| does not contain | NOTLIKE | ||
| 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
| Operator Display Name | System name | |
|---|---|---|
| contains | LIKE | |
| on | ON | |
| not on | NOTON | |
| before | < | |
| after | > | |
| at or before | <= | |
| at or after | >= | |
| between | BETWEEN | |
| contains | LIKE | |
| does not contain | NOTLIKE | |
| is empty | ISEMPTY | |
| is not empty | ISNOTEMPTY | |
| is anything | ANYTHING | |
| is same | SAMEAS | |
| is different | NSAMEAS | |
| changes | VALCHANGES | |
| changes from | CHANGESFROM | |
| changes to | CHANGESTOhour is | |
| is (calculated) | IS_CALCULATED |
| Table of Contents | ||||
|---|---|---|---|---|
|