List of Logic Blocks¶
The following table lists the available Logic Blocks.
| Block | Function | Description |
|---|---|---|
| IF/Else Block | If(expression, if_true, if_false) | Returns a value based on whether an expression evaluates to TRUE or FALSE. |
| Comparison Operators Block | operand1 == operand2operand1 <> operand2operand1 < operand2operand1 <= operand2operand1 > operand2operand1 >= operand2 | Comparison operators compare the contents in a field to either the contents in another field or a constant. The operands may be numeric or string values. If both operands are numeric, then a numeric comparison is performed. If either of the operands is a string value, then a string comparison is performed. |
| Logical Operator Block | operand1 And operand2operand1 Or operand2 | The “And” operator determines the logical conjunction of the two operands by treating nonzero values as a value of TRUE and zero values as FALSE.The “Or” operator determines the logical disjunction of the two operands. If either or both operands evaluate to TRUE (nonzero), then the result is TRUE. |
| Is Null Block | IsNull(parameter) | Returns TRUE if the argument contains a null value, otherwise, returns FALSE. |
| Is Numeric Block | IsNumeric(parameter) | Returns TRUE if the argument can be converted to numeric data type, otherwise, returns FALSE. |