Skip to content

IIF Function

Nilesh Ghodekar edited this page May 5, 2018 · 9 revisions

Syntax

object IIF(condition:bool, trueReturn:object, falseReturn:object)

Description

Returns the second or third parameter based on the evaluation of the condition specified as the first parameter.

Remarks

If the first input parameter (condition) is null, it is treated as false. All the three parameters of the IIF function can be any other WAL functions returning the data type mentioned in the function signature. Please note the IIF function evaluates the values for the second as well as the third parameter even when it only returns the value of either the second or the third parameter based on the evaluation of the condition specified as the first parameter.

Supported Version

1.0.0.0 and later

Examples

IIF(Eq([//Target/EmployeeType],"Contractor"),"OU=Vendors",[//WorkflowData/OrgOU])

IIF(Not(Eq(1,2)),true,false)

IIF(Not(Eq(1,2)),"1 != 2","1 == 2")

Clone this wiki locally