True and False
The values True and False are represented by 1 and 0 respectively in PhixFlow and any function which returns a logical value will return either 1 or 0.
Please also note that any non-null, non-zero value will be treated as True by the logical functions.
Comparator Type
Logical functions may take a Comparator Type parameter which specifies the comparison operations. These are strings with one of the following values:
| Comparator | Meaning |
|---|---|
| _LESS_THAN | The first item is less than the second. Numerical and Alphabetic comparisons are handled |
| _GREATER_THAN | The first item is greater than the second. Numerical and Alphabetic comparisons are handled |
| _EQUALS | The first item is identical to the second. Numerical and Alphabetic comparisons are handled |
| _GREATER_THAN_OR_EQUAL | The first item is identical to or greater than the second. Numerical and Alphabetic comparisons are handled |
| _LESS_THAN_OR_EQUAL | The first item is identical to or less than the second. Numerical and Alphabetic comparisons are handled |
| _NOT_EQUALS | The first item is not identical to the second. Numerical and Alphabetic comparisons are handled |
| _STARTS_WITH | The first item starts with the second string. Alphabetic comparisons only |
| _NOT_STARTS_WITH | The first item does not start with the second string. Alphabetic comparisons only |
| _LIKE | The first item is like the second string. Alphabetic comparisons only |
List of logical functions
The following logical functions are available:
<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"/>