This function, which accepts any number of arguments, evaluates each in order, and returns the first non-null argument. A typical use case involves two arguments - the first being something dynamic, the second being a static value to use as a guard in case the dynamic value is null. The function itself detects its return type based on the type of the last argument.

coalesce(value, [value, ...])

  • Parameters

Object value - Any number of values.

  • Returns

Object - The first non null argument.

coalesce(null, "abc") //Would return "abc".
coalesce("xyz", "abc") //Would return "xyz".
coalesce({Root Container.MyDataSet}[0,"ColumnName"], 0) //Would return the value in the dataset if it isn't null, but 0 if it is null.