Skip to main content
System StatusContact Support
VersionOne Community

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 check Support Center -> About 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

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 check Support Center -> About 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 or rest-1.oauth.v1/Data endpoints.

Getting Started

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.

  • Was this article helpful?