Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
Predicate functions and operators check if the input argument satisfies a condition.
Predicate Function
The ISNULL function checks if the input value is NULL and returns 1 if the input value is NULL, and 0 (as an INT) otherwise.
Predicate Operators
Predicate operators return true
if the respective condition is fulfilled, and false
otherwise:
- IN can be used to match the values of a column with a list of match values.
- In contrast to IN, MULTI_IN matches a list of tuples.
- LIKE returns
true
if the value of a column matches the given pattern. - The BETWEEN operator matches an inclusive range between two given values.
- In contrast to the ISNULL function, which returns an INT, the
IS NULL operator
returns
true
if the input is NULL, andfalse
otherwise.
The output of IN
, LIKE
, BETWEEN
and IS NULL
can be negated by using
NOT IN
, NOT LIKE
, NOT BETWEEN
and IS NOT NULL
respectively.
IN, MULTI_IN, LIKE, BETWEEN and IS NULL can be used within one of the following contexts, which can evaluate a boolean expression:
- CASE WHEN (in the
WHEN
conditions) - FILTER
- Pull-Up-Functions (in the filter argument)
- BIND_FILTERS (in the filter argument)
- CALC_REWORK (in the filter argument)
Predicate operators can be combined with logical operators to more complex boolean expressions.
Content