...
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 are used within the containing logical function and 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 | item 1 is less than item 2 | numeric, alphabetic |
_GREATER_THAN | item 1 is greater than the item 2 | numeric, alphabetic |
_EQUALS | item 1 is identical to the item 2 | numeric, alphabetic |
_GREATER_THAN_OR_EQUAL | item 1 is identical to or greater than the item 2 | numeric, alphabetic |
_LESS_THAN_OR_EQUAL | item 1 is identical to or less than the item 2 | numeric, alphabetic |
_NOT_EQUALS | item 1 is not identical to the item 2 | numeric, alphabetic |
_STARTS_WITH | item 1 starts with the string specified in item 2 | alphabetic |
_NOT_STARTS_WITH | item 1 does not start with the string specified in item 2 | alphabetic |
_LIKE | item 1 is like the item 2 | alphabetic |
The following comparators, _IS_NOT_NULL and _IS_NULL, only have 1 item, which is compared to null. | ||
_IS_NOT_NULL | item 1 is a string or value representing null and item 2 is a non-null string or value or string. | numeric, alphabetic |
_IS_NULL | item 1 is a string or value representing null and item 2 is a null value or string. | numeric, alphabetic |