Excerpt |
---|
|
Functions which compare values and return a true or false result. |
The following logical functions are available:
True and False
...
Comparator Type
Logical 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 are used within the containing logical function and evaluate to either true or false.
Comparator strings are:
Comparator | Evaluates to True when... | Types handled |
---|
_LESS_THAN |
The first the second. Numerical and Alphabetic comparisons are handleditem 2 | numeric, alphabetic |
_GREATER_THAN |
The first is greater than the second. Numerical and Alphabetic comparisons are handled1 is greater than the item 2 | numeric, alphabetic |
_EQUALS |
The first is identical to the second. Numerical and Alphabetic comparisons are handled1 is identical to the item 2 | numeric, alphabetic |
_GREATER_THAN_OR_EQUAL |
The first is 1 is identical to or greater than |
the second. Numerical and Alphabetic comparisons are handledthe item 2 | numeric, alphabetic |
_LESS_THAN_OR_EQUAL |
The first is 1 is identical to or less than |
the second. Numerical and Alphabetic comparisons are handledthe item 2 | numeric, alphabetic |
_NOT_EQUALS |
The first is the second. Numerical and Alphabetic comparisons are handledthe item 2 | numeric, alphabetic |
_STARTS_WITH |
The first starts second string. Alphabetic comparisons onlystring specified in item 2 | alphabetic |
_NOT_STARTS_WITH |
The first does 1 does not start with the |
second string. Alphabetic comparisons onlystring specified in item 2 | alphabetic |
_LIKE |
The first is like the second string. Alphabetic comparisons only
<Topic name = "and" helpContext = "attributeFunctions/and" isLeaf = "true"/>
<Topic name = "eq" helpContext = "attributeFunctions/equals" isLeaf = "true"/>
<Topic name = "ge" helpContext = "attributeFunctions/greaterThanOrEqual" isLeaf = "true"/>
<Topic name = "gt" helpContext = "attributeFunctions/greaterThan" isLeaf = "true"/>
<Topic name = "isEmpty" helpContext = "attributeFunctions/isEmpty" isLeaf = "true"/>
<Topic name = "isNull" helpContext = "attributeFunctions/isNull" isLeaf = "true"/>
<Topic name = "le" helpContext = "attributeFunctions/lessThanOrEqual" isLeaf = "true"/>
<Topic name = "lt" helpContext = "attributeFunctions/lessThan" isLeaf = "true"/>
<Topic name = "ne" helpContext = "attributeFunctions/notEquals" isLeaf = "true"/>
<Topic name = "not" helpContext = "attributeFunctions/not" isLeaf = "true"/>
<Topic name = "or" helpContext = "attributeFunctions/or" isLeaf = "true"/>
...
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 non-null string or value. | numeric, alphabetic |
_IS_NULL | item 1 is null. | numeric, alphabetic |