Skip to main content

 

Planview Customer Success Center

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’)