IsResourceAvailableForGivenPeriod Function
IsResourceAvailableForGivenPeriod (user as ObjectIdentifier, dateTime1 as DateTime, dateTime2 as DateTime, overload as Numeric, loadType as String, state1 as ObjectIdentifier, state2 as ObjectIdentifier, ... as ObjectIdentifier) as Boolean
Category: | Date |
Description: | Returns "FALSE" in the case that the specified user has a load greater than the Overload percentage specified between the time period of dateTime1 and dateTime2 for work items in the given states. Overload is an optional parameter 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: | |
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 |
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" indicates that the user specified in the "user" parameter is avaiable during the time frame specified in the "period" parameter |
Example #1 |
IsResourceAvailableForGivenPeriod($Resource,$WorkItem.StartDate,$WorkItem.DueDate,100) |
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. |