rally - Using the LookbackAPI to find Scope Change -
is there way query using lookbackapi find stories (hierarchicalrequirement) had change planestimate date (say week ago) today?
or best way find stories on given date in past , return planestimate , unformatedid fields, , compare them current planestimate each story of today?
each lbapi snapshot have _previousvalues
collection. each lbapi snapshot, if field has changed prior snapshot, _previousvalues
collection hydrated value. in other words, if planestimate
has not changed between snapshots, there no planestimate
entry in _previousvalues
collection snapshot. thus, planestimate, following query:
find: { "_typehierarchy" : "hierarchicalrequirement", "_previousvalues.planestimate" : {$exists: true}, "_validfrom": { $gte: "2013-01-01t00:00:00.000z", $lt: "2013-05-01t00:00:00.000z" } }
should provide hierarchicalrequirement snapshots corresponding change in planestimate 2013-05-01 2013-05-10.
Comments
Post a Comment