General operators
Description of general operators used in decision tables
List of general operators
Every condition cell in the decision table can have a different operator. These are the general operators which you can choose from:
All the input values (left operands) are auto-casted (meaning the value will be converted to the data type needed by the operator, whenever possible).
ALL THE RIGHT SIDE OPERANDS ARE ALSO AUTOCASTED.
THUS NO QUOTEMARKS SHOULD BE USED IN THE TABLE VALUES.
We use the double quote marks in the table values only to highlight the fact that these will be converted to string on the backend.
Anything Operator (anything)
The anything operator (anything) returns true always.
Equals Operator (=)
Compares two scalar values. The equal operator compares mainly:
String
Number
Boolean
Equal Operator examples:
[request value] = [table value]
3 = 3 //true
"3" = 3 //true
true = true //true
"true" = true //trueIS IN Operator (IN)
The IS IN operator ( in ) returns true if the right operand contains the left operand, and false otherwise.
Members of the set can be separated by pipe (|), comma (,), semicolon (;)
The right operand has to be an array
[]Only exact matches!
IS IN Operator examples:
[request value] IN [table value]
3 IN 1|2|3 //true
4 IN 1|2|3 //false
"a" IN "a"|"b"|"c" //true
"d" IN "a"|"b"|"c" //false
"3" IN 1|2|3 //trueNOT IN Operator (NOT IN)
The NOT IN operator (not in ) returns true if the right operand does not contain the left operand, and false otherwise.
Members of the set can be separated by pipe (|), comma (,), semicolon (;)
The right operand has to be an array
[]
NOT IN Operator examples:
[request value] NOT IN [table value]
3 NOT IN 1|2|3 //false
4 NOT IN 1|2|3 //true
"a" NOT IN "a"|"b"|"c" //false
"d" NOT IN "a"|"b"|"c" //true
"3" NOT IN 1|2|3 //falseGreater than OR Equal Operator (>=)
The greater than or equal operator (>=) returns true if the left operand is greater than or equal to the right operand, and false otherwise.
Numbers can be decimal or integer
String comparison is similar to JS
Greater than OR Equal Operator examples:
[request value] >= [table value]
5 >= 3 // true
3.1 >= 2.1 // true
"b" >= "a" // true
"a" >= "a" // true
true >= true // true
true >= false // trueGreater Operator (>)
The greater operator (>) returns true if the left operand is greater than the right operand, and false otherwise.
Numbers can be decimal or integer
String comparison is similar to JS
Greater Operator examples:
[request value] > [table value]
5 > 3 // true
3.1 > 2.1 // true
"b" > "a" // true
true > true // false
true > false // trueLess than OR Equal Operator (<=)
The less than or equal operator (<=) returns true if the left operand is less than or equal to the right operand, and false otherwise.
Numbers can be decimal or integer
String comparison is similar to JS
Less than OR Equal Operator examples:
[request value] <= [table value]
3 <= 5 // true
3 <= 3 // true
2.1 <= 3.1 // true
"a" <= "a" // true
"a" <= "b" // true
true <= true // true
false <= true // trueLess than Operator (<)
The less than operator (<) returns true if the left operand is less than the right operand, and false otherwise.
Numbers can be decimal or integer
String comparison is similar to JS.
Less than Operator examples:
[request value] < [table value]
3 < 5 // true
2.1 < 3.1 // true
"a" < "b" // true
true < true // false
false < true // trueBetween Operator (between)
The between operator (between) returns true if the left operand is between or equal to the right operand, and false otherwise.
The left operand can be Number, String, or Boolean
The right operand has to be an Array of two values
Between Operator examples:
[request value] between [table value]
4 between [3 and 5] // true
3 between [3 and 5] // true
4.0 between [3.0 and 5.5] // true
3.5 between [3.0 and 5.5] // true
"b" between ["a" and "c"] // true
"a" between ["a" and "c"] // true
true between [true and false] // true
true between [true and true] // trueBetween Left Open Operator
The between left open operator (betweenLeftOpen) returns true if the request value falls between the interval excluding the lower limit (left value) and including the upper limit (right value). Otherwise it returns false.
The left operand can be Number, String, or Boolean
The right operand has to be an Array of two values
[request value] between [table value]
4 between [3 and 5] // true
3 between [3 and 5] // false
5.5 between [3.0 and 5.5] // true
3.0 between [3.0 and 5.5] // false
"b" between ["a" and "c"] // true
"a" between ["a" and "c"] // false
true between [false and true] // true
false between [false and true] // falseBetween Right Open Operator
The between right open operator (betweenRightOpen) returns true if the request value falls between the interval including the lower limit (left value) and excluding the upper limit (right value). Otherwise it returns false.
The left operand can be Number, String, or Boolean
The right operand has to be an Array of two values
[request value] between [table value]
4 between [3 and 5] // true
5 between [3 and 5] // false
3.0 between [3.0 and 5.5] // true
5.5 between [3.0 and 5.5] // false
"b" between ["a" and "c"] // true
"c" between ["a" and "c"] // false
true between [false and true] // false
false between [false and true] // trueNot Equal Operator (<>)
Compares two scalar values. The not equal operator compares mainly:
String
Number
Boolean
Not Equal Operator examples:
[request value] <> [table value]
3 <> 3 //false
"3" <> 3 //false
3 <> 4 //true
true <> false //trueIs Null
The is null operator (IsNull) returns true if the value is empty.
[request value] isNull [table value]
null //true
{} //true
[] //true
"a" //false
3 //false
"" //falseIs Not Null
The is not null operator (isNotNull) returns true if the value is not empty.
[request value] isNotNull [table value]
"a" //true
3 //true
"" //true
null //false
{} //false
[] //falseContains Text Operator (containsText)
The contains text operator (containsText) returns true if the left operand contains in the right operand, and false otherwise.
Members of the set can be separated by pipe (|), comma (,), semicolon (;)
The left operand can be Number, String, or Boolean or Array of these data types
It is matching not only the exact matches but also the substrings
Contains Text Operator examples:
[request value] containsText [table value]
[1,2,3] containsText "1" //true
[11,2,3] containsText "1" //true
[2,3,4] containsText "1" //false
"This is example 1,2,3 with true." containsText "1,2,3" //true
"This is example false or true." containsText "true or false" //false
"This is example true with false." containsText true //trueContains In Operator (containsIn)
The contains in operator (containsIn) returns true if any of the elements in the right operand is included in the element/elements of the left operand. Otherwise false is returned.
trueis returned when any of the elements in the right operand is included in any substring of the left operand.Members of the set can be separated by pipe (|), comma (,), semicolon (;)
The left operand can be Number, String, Boolean or Array of these data types
Contains in Operator examples:
[request value] containsIn [table value]
"This is example 1 with true." containsIn 1|2|3 //true
"This is example 1 with true." containsIn 1|true|"ok" //true
"This is example 1 with true." containsIn "is"|2|true //true
"This is example 1 with true." containsIn true|3 //true
[1,2,3] containsIn true|3 //true
["true or falseee", "haha"] containsIn true|false //true
"This is example 1 with true." containsIn "test"|2 //falseNot Contains In Operator (notContainsIn)
The not contains in operator (notContainsIn) returns true if none of the elements in the right operand is included in the element/elements of the left operand. Otherwise false is returned.
Members of the set can be separated by pipe (|), comma (,), semicolon (;)
The left operand can be Number, String, Boolean or Array of these data types
Contains Text Operator examples:
[request value] notContainsIn [table value]
"This is example 1 with true." notContainsIn 2|3|4 //true
"This is example 1 with true." notContainsIn 2|false|"ok" //true
"This is example 1 with true." notContainsIn "are"|2|false //true
"This is example 1 with true." notContainsIn false|3 //true
[1,2,3] containsIn true|3 //false
["true or falseee", "haha"] containsIn "hello"|"bye" //true
"This is example 1 with true." notContainsIn "test"|1 //falseEqual Array Operator (equalArray)
The Equal Array operator ( equalArray ) returns true if all the values inside the right operand are substrings of one of the values inside left operand.
Members of the set can be separated by pipe (|), comma (,), semicolon (;)
The left operand has to be an array
[]
equalArray Operator examples:
[request value] equalArray [table value]
[1, 2, 3] equalArray 1|2|3 //true
["a", "b"] equalArray "a"|"b" //true
[1,2,3] equalArray 1|2 //true
[1111,111] equalArray 1|11|111 //true
[1,2,3,4,5] equalArray 1|2|3|4|6 //falseElse Operator (ELSE)
The ELSE is a special kind of operator, whose returned value is independent of the respective input variable of the column. Instead, the ELSE operator returns true if no row has passed up to the time of evaluation of the condition cell.
The ELSE operator allows you, among other things, to add a so-called default row to your decision table. It is simply a row at the end of the table with ELSE operator in all of its condition cells. By definition, the default row gets triggered whenever there is no other row passing. It can be used e.g. to send an error message to the output.
Last updated
Was this helpful?