Logical Expressions
Logical expressions are used to evaluate conditions and make decisions within your application. This category includes functions for comparison, boolean operations (such as AND, OR, NOT), and conditional statements.
Boolean
Represents a logical value that can be either true or false.
1
Boolean Constant
Boolean
And
Returns true if both conditions are true; otherwise, returns false.
>=2
Boolean
Whole Number
Or
Returns true if at least one of the conditions is true; otherwise, returns false.
>=2
Boolean
Whole Number List
And Also
Performs a logical AND operation on its operands only if the first operand evaluates to true.
>=2
Boolean
Boolean
Or Else
Performs a logical OR operation on its operands only if the first operand evaluates to false.
>=2
Boolean
Boolean
Is Not Null
Checks if a value is not null.
1
Any
Boolean
Is Null
Checks if a value is null.
1
Any
Boolean
Text Is Null
Checks if a text string is null.
1
Text
Boolean
Text Is Not Null
Checks if a text string is not null.
1
Text
Boolean
Is Equal to
Compares two values to determine if they are equal.
2
Decimal, Date or Text
Both Operands should be of the same time
Boolean
Is Not Equal to
Compares two values to determine if they are not equal.
2
Decimal, Date or Text
Both Operands should be of the same time
Boolean
Is Greater Than
Compares two values to determine if one is greater than the other.
2
Decimal or Date
Both Operands should be of the same time
Boolean
Is Greater Than or Equal to
Compares two values to determine if one is greater than or equal to the other.
2
Decimal or Date
Both Operands should be of the same time
Boolean
Is Less Than
Compares two values to determine if one is less than the other.
2
Decimal or Date
Both Operands should be of the same time
Boolean
Is Less Than or Equal to
Compares two values to determine if one is less than or equal to the other.
2
Decimal or Date
Both Operands should be of the same time
Boolean
Contains Item
Checks if a collection contains a specified item.
2
1st is a List
2nd same type as list
Boolean
Inclusive Between
Determines if a value falls within a specified range, inclusive of the boundary values.
3
Whole Number/Decimal
1st operand is the argument, and the two others are the min and max ranges
Boolean
Exclusive Between
Determines if a value falls within a specified range, exclusive of the boundary values.
3
Whole Number/Decimal
1st operand is the argument, and the two others are the min and max ranges
Boolean
Min Range Inclusive Between
Determines if a value falls within a specified range, including the minimum boundary value.
3
Whole Number/Decimal
1st operand is the argument, and the two others are the min and max ranges
Boolean
Max Range Inclusive Between
Determines if a value falls within a specified range, including the maximum boundary value.
3
Whole Number/Decimal
1st operand is the argument, and the two others are the min and max ranges
Boolean
If
Executes a block of expressions based on whether a specified condition is true or false.
3
1st Boolean
2nd and 3rd any
True/False Branch types
Is Empty
Checks if a collection of values is empty.
1
List
Boolean
Last updated