Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Function: ifNull()

Acts as a simple IF statement to determine what to do when the expression supplied to it is _NULL or not. Specifically it checks the value returned by the first expression provided, if this is _NULL the second expression will run and if it is not _NULL the third expression will run. If the third statement is blank the expression will do nothing and continue.

Syntax

  1. ifNull(expression, nullReturnValue)
  2. ifNull(expression, nullReturnValue, notNullReturnValue)
ArgumentTypeDescription
expressionAnyThe expression to be evaluated and checked. If notNullReturnValue is not provided, then this is also the return value for the function if expression does not evaluate to _NULL.
nullReturnValueAnyThe value to be returned if expression is _NULL
notNullReturnValueAnyAn optional parameter containing the value to be returned if expression does not evaluate to _NULL.

Examples

ifNull( in.prodID, "failed", "success" )

Resolve the status of an order for which, if it has been successful, we expect to find a product ID on a target system. If in.prodID has a value, the order was successful. If in.prodID is _NULL, the order failed.


ifNull(calls.numCalls, 0)

Get the number of calls from an lookup Pipe. If there are no calls, calls.numCalls is _NULL so we assign the value 0. Otherwise, we simply want the original value of calls.numCalls.

See Also

  • No labels