queries:functions:coalesce

coalesce

The coalesce function is used to transform a null value into something useful. If the parameter passed to coalesce is null, the second parameter will be returned and otherwise the first parameter.

Return Type Dynamic
Aggregates No
Flags NotNull

Parameters

Parameters: coalesce(value, default)

Name Type Description
value Dynamic Any value which can be null.
default Dynamic The default which will be returned if the value is null.