Mendix 7 is no longer supported unless you have Extended Support (for details, please contact Mendix Support). Mendix 7 documentation will remain available for customers with Extended Support until July, 2024.
OQL COALESCE
Last modified: August 2, 2022
The COALESCE function returns the first of its arguments that is not null.
The syntax is as follows:
COALESCE ( expression [ ,...n ] )
expression Specifies the expression to check if the result is NULL.