ifNull
- Former user (Deleted)
- Fiona Sargeant (Unlicensed)
- Dominic Sandhu (Unlicensed)
Owned by Former user (Deleted)
Function: ifNull()
The ifNull function acts as a simple IF statement to determine what to do when the supplied expression is _NULL. It checks the value returned by the first expression. If the returned value is:
- _NULL, the second expression runs
- not _NULL, the value in the initial expression is used.
You can provide an optional third expression to run if the first expression is not blank, instead of simply returning the non-null value.
Syntax
- ifNull(expression, nullReturnValue)
- ifNull(expression, nullReturnValue, notNullReturnValue)
| Argument | Type | Description |
|---|---|---|
| expression | Any | The expression to be evaluated and checked. If notNullReturnValue is not provided, then this is used as the return value if expression does not evaluate to _NULL. |
| nullReturnValue | Any | The value to be returned if expression is _NULL |
| notNullReturnValue | Any | An 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.