Search…
API
Tutorials
Decision tables
Scripting Rules
Rule Flow
Other
Test Bench
SDK and Frameworks
Business Intelligence
On-Premise / Docker
Terms & Conditions
Advanced Functions
A list of functions is a feature that can be used in the Decision Tables to create functions both in input and output.
Usage of advanced functions
There are 5 types of functions in the list that can be used in the Decision Tables:
SUM
EQUAL
NOW
UPPER_CASE
ARRAY_SUM
MIN
GREATER
CURDATE
LOWER_CASE
ARRAY_CONCAT
MAX
GREATER_EQUAL
CURTIME
REPLACE
ARRAY_CONCAT_WS
AVG
LESS
DATE
LEN
ARRAY_PICK
COUNT
LESS_EQUAL
DATEDIFF
CONCAT
MEDIAN
NOT_EQUAL
DATE_COMPUTE
CONCAT_WS
CEILING
BETWEEN
STRINGFORMAT
FLOOR
AND
ROUND
OR
EXP
REGEXP
POW
IS_NULL
+ (plus)
IS_NOT_NULL
− (minus)
/ (divide)
* (multiply)
Each function can be embedded by the logical structure. Such as:
ROUND(SUM(1,2))
MEDIAN(AVG(1,2,3), MIN(4,5))
OR(EQ(10,10),EQ(10,15))
AND(EQ(10,SUM(7,3)),LT(10,MAX(5,20)))
Attributes from the input or output model can also be used as parameters in the functions in the following format:
{ATTRIBUTE} --> the attribute always must be in {}
Condition (input)
The condition (input) can only have functions returning BOOLEAN values TRUE or FALSE.
Therefore always the input must start with one of the LOGICAL functions, then there can be the other functions embedded in it.
Example of how the input must be.
After the execution of the row, the test bench condition is not shown in the test bench as input but in the CONSOLE if the debug mode is on. See an example below:
This is how the test bench looks like:
This is shown in the console:
Result (output)
The result (output) can be any data type to return. All the functions can be used without any exception.
If there is a string in the function it must be in a ".." or in '...'
e.g.: CONCAT_WS("-", "hello", "my", "world")
Last modified 1mo ago
Copy link