Skip to main content
Planview Customer Success Center

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'

  • Active
  • Cancelled
  • Completed
  • Draft
  • On Hold
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

  • Active
  • Cancelled
  • Completed
  • Draft
  • On Hold
... 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

  • Active
  • Cancelled
  • Completed
  • Draft
  • On Hold
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

Today()