Queries: Use Lookback API to filter on PlanEstimate values
search cancel

Queries: Use Lookback API to filter on PlanEstimate values

book

Article ID: 111783

calendar_today

Updated On:

Products

CA Agile Central On Premise (Rally) CA Agile Central SaaS (Rally)

Issue/Introduction

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)?

Environment

Release:
Component: ACSAAS

Resolution

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_OID>/artifact/snapshot/query.js?find={$and: [{"FormattedID":"US1"},{"PlanEstimate": {$gt: 0}}]}&fields=["PlanEstimate","_SnapshotDate","_SnapshotNumber"]&compress=true