How to query Milestones by Artifacts and Artifacts by Milestones

Products

• Rally On-Premise
• Rally SaaS

Issue/Introduction

How does one query a Milestone by Artifact, or query for Artifacts by Milestone? 

For instance, if a user would like to get a list of work items such as user stories or defects associated to a certain milestone via a query, how is that done? 

Resolution

Per WS API object model, there is Artifacts collection on a Milestone and Milestones collection on Artifact, allowing many-to-many relationships.

1. Query an Artifact by Milestone:

One can query a work item by simply specifying the Formatted ID of the Milestone:

(Milestones.FormattedID = "MI9")

 

2. Query a Milestone by Artifact:

For an Artifact that is associated to a Milestone, such as US640 in the below screenshot: