The function ecm:nvl returns the specified object when not a null value. Otherwise, a specified default object is returned. The value returned is an object type.

Example

A message greeting is personalized to use the first name of the recipient. Recipients who do not have a first name stored as an attribute are addressed as ''Dear Subscriber".

The greeting is inserted into the message using an ​InsertIf​ statement, which is constructed as follows:

<%${ecm:nvl(user['FirstName'], 'Subscriber')}%>
CODE

Structure​

ecm:nvl(object, object)

Parameters​

Parameter

Description

object

Specifies the target object. This object is returned if not null.

object

The default object to be returned when the first parameter is null.