Query for hours worked by member within a time period
This topic explains how to Query for hours worked by member within a time period.
What
I would like to find all the hours worked by team members for a specific project within a time period (for example, from the start to the end of the month). How can I query for this data?
How
Solution: Use query.v1 to report by Member
This endpoint was introduced in 13.2, Summer 2013. Please view the About Digital.aiAgility information from the help icon in the menu bar to see if you are on this release or later.
The following uses the query.v1 endpoint to obtain Members with aggregated hours for the date range. The same can be accomplished using the rest-1.v1/Data endpoint.
Getting Started
- Have an HTTP Client.
- Obtain an API token.
Query
For this solution, we use Member as the from parameter. We select for Name and the Actuals data.
from: Member
select:
- Name
- Actuals[Date>='2007-07-01';Date<'2012-08-01'].Value.@Sum
In order to execute the query, submit an HTTP POST with the query as the body to query.v1.
Solution: Use query.v1 to enumerate the hours by date, team member, project
This endpoint was introduced in 13.2, Summer 2013. Please view the About Digital.aiAgility information from the help icon in the menu bar to see if you are on this release or later.
The following uses the query.v1 endpoint to obtain the raw Actuals so calculations can be performed on the data post hoc. The same can be accomplished using the rest-1.v1/Data endpoint.
Getting Started
- Have an HTTP Client.
- Obtain an API token for the scope
query-api-1.0.
Query
For this solution, we use Actual as the from parameter. We select for Date, Member.Name, Scope.Name, and Value. We filter for the date range.
from: Actual
select:
- Date
- Member.Name
- Scope.Name
- Value
filter:
- Date>='2007-07-01';Date<'2012-08-01'
In order to execute the query, submit an HTTP POST with the query as the body to query.v1.