Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 20 Next »

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:

ComparatorEvaluates to True when...Types handled
_LESS_THANitem 1 is less than item 2numeric, alphabetic
_GREATER_THANitem 1 is greater than the item 2numeric, alphabetic
_EQUALSitem 1 is identical to the item 2numeric, alphabetic
_GREATER_THAN_OR_EQUALitem 1 is identical to or greater than the item 2numeric, alphabetic
_LESS_THAN_OR_EQUALitem 1 is identical to or less than the item 2numeric, alphabetic
_NOT_EQUALSitem 1 is not identical to the item 2numeric, alphabetic
_STARTS_WITHitem 1 starts with the string specified in item 2alphabetic
_NOT_STARTS_WITHitem 1 does not start with the string specified in item 2alphabetic
_LIKEitem 1 is like the item 2alphabetic
_IS_NOT_NULLitem 1 is a string or value representing null and item 2 is a non-null value or stringnumeric, alphabetic
_IS_NULLitem 1 is a string or value representing null and item 2 is a null value or stringnumeric, alphabetic




  • No labels