Logical Functions

List of 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

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