...
Some logical functions may take a Comparator Type parameter which specifies the comparison operations. These are strings with one of the following values:
...
Specify the 2 items to compare and the comparator string as required by the logical function. For example a comparator in a field condition has the syntax:
| Code Block |
|---|
fieldCondition(attrOne,_EQUALS,attrTwo) |
Comparators evaluate to either 1 (true) or 0 (false) which is then used by the containing logical function.
Comparator strings are:
| Comparator | Evaluates to True when... | Types handled |
|---|
| _LESS_THAN |
The first the second. | item 2 | numeric, alphabetic |
| _GREATER_THAN |
The first is the second. | the item 2 | numeric, alphabetic |
| _EQUALS |
The first is the second. | the item 2 | numeric, alphabetic |
| _GREATER_THAN_OR_EQUAL |
The first is | 1 is identical to or greater than |
the second. | the item 2 | numeric, alphabetic |
| _LESS_THAN_OR_EQUAL |
The first is | 1 is identical to or less than |
the second. | the item 2 | numeric, alphabetic |
| _NOT_EQUALS |
The first is the second. | the item 2 | numeric, alphabetic |
| _STARTS_WITH |
The first starts second .| specified in item 2 | alphabetic |
| _NOT_STARTS_WITH |
The first does | 1 does not start with the |
second .| specified in item 2 | alphabetic |
| _LIKE |
The first is like the second string. | 1 is like the item 2 | alphabetic |
| _IS_NOT_NULL |
The first is not null compared to the second string ??| 1 is a string or value representing null and item 2 is a non-null value or string | numeric, alphabetic |
| _IS_NULL |
The first item is null to the second string ?? | numeric, alphabetic | Calling a method like a field condition and then within the syntax of what you are calling.
fieldCondition(attrOne,_EQUALS,attrTwo)
Clarifying info required:
...
...
| item 1 is a string or value representing null and item 2 is a null value or string | numeric, alphabetic |