Search…
SDK and Frameworks
Logical Functions

List of 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.

Deprecated functions

  • REGEXP

Equal (EQ)

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

Greater than (GT)

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

Greater than or equal (GTE)

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

Less than (LT)

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

Less than or equal (LTE)

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

Not equal (NE)

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

Between (BTW)

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

Between left open (BETWEEN_LEFT_OPEN)

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.

Between right open (BETWEEN_RIGHT_OPEN)

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.

And (AND)

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

Or (OR)

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

Is null (IS_NULL)

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

Is not null (IS_NOT_NULL)

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

Negation (NOT)

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

Regular expression (REGEXP) (deprecated)

This function is deprecated. Use TEST instead (see Text Functions).
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
Copy link
On this page
List of logical functions
Equal (EQ)
Greater than (GT)
Greater than or equal (GTE)
Less than (LT)
Less than or equal (LTE)
Not equal (NE)
Between (BTW)
Between left open (BETWEEN_LEFT_OPEN)
Between right open (BETWEEN_RIGHT_OPEN)
And (AND)
Or (OR)
Is null (IS_NULL)
Is not null (IS_NOT_NULL)
Negation (NOT)
Regular expression (REGEXP) (deprecated)