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
Article ID: 111783
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
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
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>
Additional Information
More on Lookback API: https://rally1.rallydev.com/analytics/doc/#/manual
Attachments
Feedback
Yes
No
Powered by
