Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RTC: How to create report/query to identify all SCM change sets associated with a hierarchy of work items?

Questions
Tags
Users
Badges
Todd Dunnavant
(57●10●19) Mar 23 '16, 11:30 a.m.
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?

0 votes

Comments
Geoffrey Clemm
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Mar 23 '16, 5:30 p.m.
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.?

Todd Dunnavant
Mar 23 '16, 6:01 p.m.
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.

Donald Nong
Mar 24 '16, 5:26 a.m.
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.

Todd Dunnavant
Mar 24 '16, 9:38 a.m.
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.

0 answers
3,441 views
0 votes

Be the first one to answer this question!

Register or log in to post your answer.

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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,144

Question asked: Mar 23 '16, 11:30 a.m.

Question was seen: 3,441 times

Last updated: Mar 24 '16, 9:38 a.m.

Confirmation Cancel Confirm