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. These are strings with one of the following values:
| Comparator | Meaning | Types handled |
|---|---|---|
| _LESS_THAN | The first item is less than the second. | numeric, alphabetic |
| _GREATER_THAN | The first item is greater than the second. | numeric, alphabetic |
| _EQUALS | The first item is identical to the second. | numeric, alphabetic |
| _GREATER_THAN_OR_EQUAL | The first item is identical to or greater than the second. | numeric, alphabetic |
| _LESS_THAN_OR_EQUAL | The first item is identical to or less than the second. | numeric, alphabetic |
| _NOT_EQUALS | The first item is not identical to the second. | numeric, alphabetic |
| _STARTS_WITH | The first item starts with the second string. | alphabetic |
| _NOT_STARTS_WITH | The first item does not start with the second string. | alphabetic |
| _LIKE | The first item is like the second string. | alphabetic |
| _IS_NOT_NULL | The first item is not null compared to the second string ?? | numeric, alphabetic |
| _IS_NULL | The first item is null to the second string ?? | numeric, alphabetic |
Clarifying info required:
- If you use a comparator are you asking a question? Is A (comparison) B?
- Syntax of a simple example, e.g. A _EQUALS B
- A and B are what?
- What do you get back Returns either 1 or 0 to indicate true or false
- If you use a comparator are you asking a question? What do you get back
- Is A less than B
- _START: how many characters ???
- How does _LIKE work???
- ISNULL - what is it comparing