The following logical functions are available:
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
Some logical functions may take a Comparator Type parameter which specifies the comparison operations.
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:
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 | 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 |
| _IS_NOT_NULL | item 1 is a string or value representing null and item 2 is a non-null 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 |