Hi Hillary,
You shall need to form separate queries to each Rally object with the filter criteria you need. Here is how you can work it out:
- To get the filters for a specific release you can query the
/portfolioitem/feature endpoint with a filter such as:
(Release.Name = "<Your Release Name>")- To get the stories of these features you shall query the
hierarchicalrequirement endpoint with a filter such as:
(Feature.Release.Name = "<Your Release Name>")If you'd like to further constrain the stories to also belong to a specific team/project, then you can extend this filter as follows:
((Feature.Release.Name = "<Your Release Name>") and (Project.Name != "<Your Team Name>"))Lastly, I'm assuming epics are the direct parents of your features in the portfolio hierarchy. If that's the case and in order to get the epics of the features previously fetched (those matching a specific release) you can query the
/portfolioitem/epic endpoint with this filter:
(Children.Release.Name = "<Your Release Name>")As you can see, you need to run different queries against each object with the filter tweaked to match the data model of each specific endpoint. That data model is shared in the WSAPI URL:
https://rally1.rallydev.com/slm/doc/webservice/ . You can see all the endpoints under the 'Object Model'. Clicking each of them will show you the fields available for query of that endpoint.
Let us know if that helped.
Thanks.
Sagi
Original Message:
Sent: 09-16-2019 12:09 PM
From: Hillary Dosch
Subject: Better Query for Hierarchy of Epic/Feature/Stories
Hello,
I'm trying to get a query going to show me a hierarchy view of :
Epics
Features tied to specific release
Stories tied to those features
I would also like to be able to have an additional option of filtering the list so that I can show a stories tied to just one specific team.