Logical Functions

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 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	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 non-null string or value.	numeric, alphabetic
_IS_NULL	item 1 is null.	numeric, alphabetic