rally - How to query for state transitions? -


i want defects transitioned 1 state (for example submitted fixed) within dates. see information in revision history of defect. in ws api says revisions cannot queried.

here example of lookbackapi query looks defects state changed submitted (and higher) fixed within timeframe:

https://rally1.rallydev.com/analytics/v2.0/service/rally/workspace/12352608129/artifact/snapshot/query.js?find={"state":"fixed","_previousvalues.state":{$gte:"submitted"},_validfrom:{$gte:"2013-06-01tz",$lt:"2013-07-011tz"}},sort:{_validfrom:-1}}&fields=true&hydrate=["_previousvalues","state"]&pagesize:20 

lookback api allows see work item or collection of work items looked in past. different using ws api directly, can provide current state of objects, not have historical data.

lbapi documentation available here

on side note, possible state transition data in custom app without using lbapi if query on defects , fetch revisionhistory,revisions , description, , iterate on results parsing description of individual revisions "state changed" string:

if(results.mydefects[i].revisionhistory.revisions[j].description.indexof("state changed")>=0){ //.... 

but can expensive , inefficient. if decide please narrow scope of defect query.


Comments