RTC: How to create report/query to identify all SCM change sets associated with a hierarchy of work items?
Situation: There is a nested hierarchy of work items, including:
- Change Request, which is parent of: - Discipline, which is parent of: - a nested hierarchy of Tasks SCM change sets can be associated with any Task in the Task WI hierarchy. How can I create a report or RTC query which will enable me to identify all the SCM change sets which are associated with the WI hierarchy that is rooted in the Change Request? |
Be the first one to answer this question!
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
What do you want to do with that list of change sets once you have it? E.g., display a list of URL's in a browser window, list the ID's, deliver them to a stream, etc.?
Hi, Geoff,
The users want to have a report in hand that lists the change sets associated with a given Change Request. So, "List the ID's" is a good place to start.
If I understand correctly, the work item query only supports one level of "links" and your use case involves two or more levels, so work item query will be out for this. You may consider using reportable REST API if presenting the result in a separate form is acceptable.
Thanks for the advice, Donald. Unfortunately, there is a hole in Reportable REST with respect to the ability to navigate from Work Items to Change Sets. I've had some of my reporting experts in the Field look into this. So far, we haven't found a way to perform this navigation.