Skip to main content

 

Planview Customer Success Center

GetAssignedProjectWorkForGivenPeriod Function

GetAssignedProjectCapacityForGivenPeriod(user as ObjectIdentifier, project as ObjectIdentifier, dateTime1 as DateTime, dateTime2 as DateTime)

Category: Resource Utilization
Description: Returns a duration value indicating the Assigned Project Capacity for the specified User in the given time range for a specified project. This should correspond to the value that can be seen in the project’s Resource Planning panel.
Supported Context: Business Rules
Parameters:  
user as ObjectIdentifier(User) Represents a reference to a user object or a field that returns a user object. Normally this will be a resource on a project.
project as ObjectIdentifier(project) Represents a project object for which you would like to know the resource’s assigned capacity.
dateTime1 Represents a reference to a from date as DateTime(year,month,day,hour,minute,second) e.g. DateTime(Year(Today()),1,1,08,00,00) or field that returns a date value e.g. Start Date
dateTime2 Represents a reference to a to date as DateTime(year,month,day,hour,minute,second) e.g. DateTime(Year(Today()),12,31,08,00,00) or field that returns a date value e.g. Due Date
Example #1 Create a Scheduled Workflow Rule on the User that will run repeatedly every Monday morning, and send an email to a user's direct manager if the user is overloaded in the current week. This will only check for resource availability on tasks that are "Active", "Draft", or "On Hold" In the Evaluation Criteria enter the following: IsResourceAvailableForFixedPeriod(currentuser(),"w",100, "Active", "Draft", "On Hold")
Tips Use this value in conjunction with a user’s rate to calculate projected cost or revenue from billing for a particular project.