ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


<Please see attached file for image>

User-added image

Additional Information

More on Lookback API: https://rally1.rallydev.com/analytics/doc/#/manual

Attachments

1558697245436000111783_sktwi1f5rjvs16ivh.png get_app