How to query for user story time in Rally

0
votes

Using Java, I would like to query Rally for the amount of time that user stories in a specific project took to complete become "Accepted". I have some familiarity with the Rally API already, and have already used it to gather defect data.

Does anyone have any suggestions on how to do this? Thanks!

References:
http://rallytools.github.io/RallyRestToolkitForJava/ https://github.com/RallyTools/RallyRestToolkitForJava/wiki/User-Guide

I also have access to the Rally Web Services API Documentation v2.0 at https://rally1.rallydev.com/slm/doc/webservice/

2
javarally

2 Answers

0
votes

Search rally tag for Lookback API posts. LBAPI provides historic data. Even though LBAPI is language agnostic, Rally REST Toolkit for Java does not have a built-in support for it. Currently only javascript AppSDK2 has built-in support for it through snapshotstore.

Unlike Lookback API, WS API gives only the current state of objects. Of course historic data can be gathered from WS API by parsing RevisionHistory,but parsing revisions is expensive and inefficient.
In WS API HierarchicalRequirement has AcceptedDate attribute. This can be accessed directly without having to parse revision history. There is no equivalent for Completed date. You would have to parse revision history to find a revision when a story was set to Completed.

0
votes

Instead of looking for "Defects" do a query for "HeirarchicalRequirements"

QueryRequest ustore = new QueryRequest("hierarchicalrequirement");
ustore.setLimit(Integer.MAX_VALUE);
ustore.setFetch(new Fetch("FormattedID","Name","Parent","Feature","Blocked","PlanEstimate","ScheduleState","Release","Iteration","Owner","Project"));
ustore.setQueryFilter(new QueryFilter("Feature.Name","=",feature.getName()));
QueryResponse usResp = restApi.query(ustore);