GetAssignedWorkingTime Function
GetAssignedWorkingTime (user as ObjectIdentifier, dateTime1 as DateTime, dateTime2 as DateTime, loadType as String, state1 as ObjectIdentifier, state2 as ObjectIdentifier, ... as ObjectIdentifier) as Duration
Category: | Date |
Description: | Returns a duration value indicating the working time for the specified User in the given time range for work items in the indicated states. Where the loadType indicates whether to analyze the load by either "PlannedWork" or "RemainingEffort". 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: | |
user as ObjectIdentifier(User) | Represents a reference to a user object or a field that returns a user object |
dateTime1 as DateTime | Represents a reference to a from date or field that returns a date value |
dateTime2 as DateTime | Represents a reference to a to date or field that returns a date value |
loadType as String | loadType indicates whether to analyze the load by either 'PlannedWork' or 'RemainingEffort' |
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 Duration | Returns a duration value indicating the working time for the specified User in the given time range for work items in the indicated states |
Example #1 |
GetAssignedWorkingTime('joe.user',today(),today()+days(14),'PlannedWork') |
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. |
Related Functions |