General functions

COALESCE / FALLBACK

Any

Returns first non-null/non-empty value from argument list

{{ coalesce(@[Field], ‘default’)}}
Result: ‘default’ if @[Field] is empty

CONCAT / CONCATENATE

String

Concatenates values into single string

{{ concat('a','b','c') }}
Result: 'abc'

JOIN / CONCAT_WS

String

Concatenates values with separator

{{ '|'.join('IPE','DOC') }}
Result: 'IPE|DOC'

MAP / TRANSLATE

String

Maps input value to output via key/value pairs with optional default. Without last optional default, a failure to match any item will be returned to the original text.

{{@[Status].map('A','Active','I','Inactive','') }}
Result: Maps status codes to text

INLIST

Bool

Returns true if a value is found within the supplied arguments

{{ 'SITE CODE'.InList(GetAttributeFields)}}
Result: True or False

COLLECT / COMBINE

Array

Collects values into single array

{{ collect('A','B','C') }}
Result: Returns array of values

MAXVALUE

Any

Maximum value from list

{{ maxValue([3,7,2]) }}
Result: 7

MINVALUE

Any

Minimum value from list

{{ minValue([3,7,2]) }}
Result: 2

FIRSTVALUE

Any

Returns the first value from a list/array

LASTVALUE

Any

Returns the last value from a list/array

COUNTVALUES

Any

Returns the count of values

if $[attr.value].isSet then $[attr.values].countValues else 0
Result: Count of values or zero

EVALUATE / EVAL

String

Compiles and evaluates string expression dynamically; builds and evaluates expression at runtime

{{ ' '.join('if', 'true'.isTrue,'then',1).eval }}
Result: if True then 1

CANCOMPILE

Bool

Returns true if a string may be compiled successfully into an expression.