You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 35 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
| Operator Display Name | System name |
|---|---|
| is | = |
| is not | != |
| is same | SAMEAS |
| is different | NSAMEAS |
| is (calculated) | IS_CALCULATED |
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 |
|---|---|
| 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 |
| 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 |
|---|---|
| is empty | ISEMPTY |
| is not empty | ISNOTEMPTY |
| is (calculated) | IS_CALCULATED |
List
| Operator Display Name | System name |
|---|---|
| has | HAS |
| has not | HASNOT |
| is | = |
| is not | != |
| contains | LIKE |
| does not contain | NOTLIKE |
| is empty | ISEMPTY |
| is not empty | ISNOTEMPTY |
| contains (dynamic) | CONTAINS_DYNAMIC |
| does not contain (dynamic) | DOESNOTCONTAIN_DYNAMIC |
| is one of | IN |
| is (calculated) | IS_CALCULATED |
Big Integer, Decimal, Float, Integer, Numeric, Percent Complete, Percent Decimal, Small Integer
| Operator Display Name | System name |
|---|---|
| is | = |
| is not | != |
| is one of | IN |
| 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 |
|---|---|
| is | = |
| is not | != |
| is one of | IN |
| contains | LIKE |
| does not contain | NOTLIKE |
| starts with | STARTSWITH |
| ends with | ENDSWITH |
| 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 |
|---|---|
| is | = |
| is not | != |
| is one of | IN |
| contains | LIKE |
| does not contain | NOTLIKE |
| starts with | STARTSWITH |
| ends with | ENDSWITH |
| is (calculated) | IS_CALCULATED |
Script
| Operator Display Name | System name |
|---|---|
| contains | LIKE |
| does not contain | NOTLIKE |
| is not empty | ISNOTEMPTY |
| is anything | ANYTHING |
| is (calculated) | IS_CALCULATED |
String, Text
| Operator Display Name | System name |
|---|---|
| contains | LIKE |
| does not contain | NOTLIKE |
| starts with | STARTSWITH |
| ends with | ENDSWITH |
| 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 |
|---|---|
| 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 |
| hour is | |
| is (calculated) | IS_CALCULATED |
- No labels
