IsPickVal Function
IsPickVal (picklistField as ObjectIdentifier, valueLiteral as String, exact as Boolean) as Boolean
| Category: | Pickup |
| Description: | Checks whether the value of a pick list field is equal to the literal value. An optional "exact" parameter with options: TRUE/FALSE is for Multi-Select Picklists to evaluate if a set of values e.g. "a, b" are contained in the list of selected values e.g. "a, b, c, d" (exact parameter = False) or are the the only values (an exact match) "a, b", using exact parameter=true. |
| Supported Context: | FormulaField And BusinessRules |
| Parameters: | |
| picklistField as ObjectIdentifier | Represents a specific object field of type pick list |
| valueLiteral as String | Represents a picklist value, as text/string of the pick list specified in the "picklistField" parameter |
| exact as Boolean | Optional: Defines if a set of values are contained in the list of selected values. Example: If "a, b" in a list that includes "a, b, c, d", the exact parameter = False, but if the list includes only "a, b", its an exact match, parameter=true. |
| Returned value as Boolean | Returns a boolean value, where "TRUE" indicates that the value of the picklist specified in the "picklistField" parameter is equal to the value specified in the "valueLiteral" parameter |
| Example #1 |
Build a workflow rule on a work item that will return a TRUE if the state of the work item is indeed set to the defined picklist value. Set the evaluation criteria to IsPickval($State,’Completed’) |