HasOverloadedResources Function
HasOverloadedResources (workItem as ObjectIdentifier, overload as Numeric, loadType as String, state1 as ObjectIdentifier, state2 as ObjectIdentifier, ... as ObjectIdentifier) as Boolean
Category: | Logical |
Description: | Returns "TRUE" when the specified Work Item has at least one resource that has a load greater than the Overload percentage specified for work items in the specified State. Overload is optional and is set to 100 by default. Up to five work item states can be specified, if not entered the query will run for all Active and Draft work items. |
Supported Context: | BusinessRules |
Parameters: | |
workItem as ObjectIdentifier(Work Item) | Represents a reference to a work item or field that returns a work item |
overload as Numeric | Represents a numeric value that denotes the percent that is determined to be overloaded. |
loadType as String | Indicates whether to analyze load by either "PlannedWork" or "Remaining Effort" |
state1 as ObjectIdentifier(State) |
An optional parameter that represents the state of work items for which you would like to get reported hours, this parameter can be repeated for each work item state, or left as null for work items in state "draft" and "active"
|
state2 as ObjectIdentifier(State) |
An optional parameter that represents the state of work items for which you would like to get reported hours, this parameter can be repeated for each work item state
|
... as ObjectIdentifier(State) |
An optional parameter that represents the state of work items for which you would like to get reported hours, this parameter can be repeated for each work item state
|
Returned value as Boolean | Returns a boolean value, where "TRUE" represents that the work item specified in the "workItem" parameter has overloaded resources or "FALSE" if it does not |
Example #1 |
Build a scheduled workflow rule running once a week that will check off a custom field check box on a work item if it has any overloaded resources. This example requires the creation of a new custom field of type "Checkbox", once created, create a scheduled workflow rule and select the update field action that will update the custom checkbox field. This will only update the work items that are in the state Draft, Active or On Hold. In the update field action enter the following: If(HasOverloadedResources(currentobject(),100 ,"Draft","Active","On Hold"), TRUE, FALSE) |
Tips | This function has a parameter from type pick list that may have being customized by your organization. Please refer to the pick list values in the formula helper editor or view the values within the relevant field. |