Agile Central - Queries: Use Lookback API to filter on PlanEstimate values

Document ID : KB000111783
Last Modified Date : 21/08/2018
Show Technical Document Details
Question:
How can we use Lookback API to find all the past instances of a certain artifact that meet a certain criteria (for example: PlanEstimate is greater than zero)?
Answer:
This is a Lookback API query example of getting all past snapshots instances of a specific artifact where PlanEstimate is greater than zero. Similarly, you can change the criteria or the artifact to create even more complex queries:

Notice this query is asking for: FormattedID = "US1" and "PlanEstimate > 0". It will receive only the past snapshot instances that meet this criteria:

https://rally1.rallydev.com/analytics/v2.0/service/rally/workspace/<<Workspace Object ID>>/artifact/snapshot/query.js?find={$and: [{"FormattedID":"US1"},{"PlanEstimate": {$gt: 0}}]}&fields=["PlanEstimate","_SnapshotDate","_SnapshotNumber"]&compress=true


User-added image
Additional Information:
More on Lookback API: https://rally1.rallydev.com/analytics/doc/#/manual