Logical Functions
- EQ
- GT
- GTE
- LT
- LTE
- NE
- BTW
- NOT_BTW
- BTW_LEFT_OPEN
- BTW_RIGHT_OPEN
- AND
- OR
- REGEXP
- IS_NULL
- IS_NOT_NULL
- IF
- NOT
The return value of logical functions is always boolean, i.e., true or false.
- REGEXP
Returns true if two values are equal to each other, or false otherwise.
- Takes 2 arguments.
input1 = 3
input2 = [1,3]
[function] --> [output]
EQ(10,10) --> true
EQ(10,15) --> false
EQ(10,"10") --> true
EQ(10,"aa") --> false
EQ({input1},3) --> true
EQ("a","a") --> true
EQ([1,3],{input2}) --> true
EQ({"price":10},{"price":11}) --> false
EQ(10) --> invalid
Returns true if the first value is greater than the second value, or false otherwise.
- Takes 2 arguments.
- Both arguments have to be numbers, variables or strings.
- When used with strings, it returns true or false based on their alphabetical order.
input = 4
[function] --> [output]
GT(20,10) --> true
GT(20,20) --> false
GT({input},3) --> true
GT("a","a") --> false
GT("b","a") --> true
GT(15) --> invalid
Returns true if the first value is greater than or equal to the second value, or false otherwise.
- Takes 2 arguments.
- Both arguments have to be numbers, variables or strings.
- When used with strings, it returns true or false based on their alphabetical order.
input = 4
[function] --> [output]
GTE(20,10) --> true
GTE(20,20) --> true
GTE({input},3) --> true
GTE("a","a") --> true
GTE("b","a") --> true
GTE(15) --> invalid
Returns true if the first value is lower than the second value.
- Takes 2 arguments.
- Both arguments have to be numbers, variables or strings.
- When used with strings, it returns true or false based on their alphabetical order.
input = 4
[function] --> [output]
LT(10,20) --> true
LT(10,10) --> false
LT(3,{input}) --> true
LT("a","a") --> false
LT("a","b") --> true
LT(15) --> invalid
Returns true if the first value is less than or equal to the second value.
- Takes 2 arguments.
- Both arguments have to be numbers, variables or strings.
- When used with strings, it returns true or false based on their alphabetical order.
input = 4
[function] --> [output]
LTE(10,20) --> true
LTE(20,20) --> true
LTE(3,{input}) --> true
LTE("a","a") --> true
LTE("a","b") --> true
LTE(15) --> invalid
Returns true if the first value is not equal to the second value.
- Takes 2 arguments.
input = 2
[function] --> [output]
NE(10,20) --> true
NE({input},3) --> true
NE(20,10) --> true
NE("a","b") --> true
NE(20,20) --> false
NE("a") --> invalid
Returns true if the second value is between the first and the third value, meaning in particular that first argument ≤ second argument ≤ third argument.
- Takes 3 arguments.
input = 12
[function] --> [output]
BTW(10,15,20) --> true
BTW(10,10,20) --> true
BTW(10,{input},20) --> true
BTW("a","f","z") --> true
BTW(10,8,20) --> false
BTW(20,10,15) --> false
BTW(20,10) --> invalid
Returns true if the second value is between the first (excluding) and the third (including) value, meaning in particular that first argument < second argument ≤ third argument.
- Takes 3 arguments.
Returns true if the second value is between the first (including) and the third (excluding) value, meaning in particular that first argument ≤ second argument < third argument.
- Takes 3 arguments.
Returns true if all of its arguments evaluate to true.
- Must have at least 1 argument.
- Arguments have to be booleans, numbers or variables.
- If the argument is a number, 0 is evaluated as false and anything else as true.
- Alternatively, OR can take an array of values in any argument.
input = true
[function] --> [output]
AND(true,EQ(10,10)) --> true
AND(LT(10,10),GTE(10,10)) --> false
AND(true,EQ(10,20)) --> false
AND(true, {input}, false) --> false
AND([true,true,true]) --> true
AND(1,true) --> true
AND("a","b") --> invalid
Returns true if at least one of its arguments evaluates to true.
- Must have at least 1 argument.
- Arguments have to be booleans, numbers or variables.
- If the argument is a number, 0 is evaluated as false and anything else as true.
- Alternatively, OR can take an array of values in any argument.
input = true
[function] --> [output]
OR(false,EQ(10,10)) --> true
OR(LT(10,10),GTE(10,10)) --> true
OR(false,EQ(10,20)) --> false
OR(false, false, {input}) --> true
OR([true,false,false]) --> true
OR(1,true) --> true
OR("a","b") --> invalid
Returns true if the value is null (empty).
- Must have 1 argument.
input1 = {}
input2 = null
input3 = "null"
input4 = "abc"
input5 = 3
[function] --> [output]
IS_NULL(input1) --> true
IS_NULL(input2) --> true
IS_NULL(input3) --> true
IS_NULL(input4) --> false
IS_NULL(input5) --> false
IS_NULL("abc") --> false
IS_NULL(3) --> false
Returns true if the value is not null (empty).
- Must have 1 argument.
input1 = {}
input2 = null
input3 = "null"
input4 = "abc"
input5 = 3
[function] --> [output]
IS_NOT_NULL(input1) --> false
IS_NOT_NULL(input2) --> false
IS_NOT_NULL(input3) --> false
IS_NOT_NULL(input4) --> true
IS_NOT_NULL(input5) --> true
IS_NOT_NULL("abc") --> true
IS_NOT_NULL(3) --> true
Returns the opposite of a boolean value.
- Must have 1 argument.
input = false
[function] --> [output]
NOT(true) --> false
NOT({input}) --> true
NOT(LT(1,4)) --> false
NOT(EQ(256,256)) --> false
Returns true if the first argument matches against a regular expression in the second argument.
- Must have 2 arguments.
- Arguments have to be numbers, strings or variables.
input = hello
[function] --> [output]
REGEXP("abc","bc") --> true
REGEXP(12233,23) --> true
REGEXP({input},"lo") --> true
REGEXP("xxx","yy") --> false
REGEXP("hello","ho") --> false
REGEXP("bye") --> invalid
Last modified 4mo ago