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

Query to fetch related work items filed against specific team

Questions
Tags
Users
Badges
Attaullah Syed
JAZZ DEVELOPER (138●1●2) Aug 11 '14, 6:50 a.m.
 Hi,
How to create a RTC query that can fetch only the stories that have related work items filed against a specific team? For example, the development team creates stories for a release. Other teams such as documentation or testing teams add related work items to the stories. I want to fetch only the stories that have related work items filed against doc.

0 votes

Comments
Krzysztof Kaźmierczyk
Aug 11 '14, 7:44 a.m.
Hi Attaullah, I haven't found any option. You can create new enhancement for that on https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.newWorkItem&type=enhancement

Susan Hanson
Aug 11 '14, 8:14 a.m.
Yea, so there are some issues with Queries when it comes to multiple "other" work items. For example, in the query builder, you can do Type is Story and Related>Filed Against is Doc.  (The Related is available if you select the checkbox in the Condition Selector called "show links"). However, there are some interesting characteristics around "all must match" or "any can match" that you'll have to play around with to see if it meets your criteria.

1 answer
6,308 views
0 votes

Accepted answer

Permanent link
Eric Jodet
JAZZ DEVELOPER (6.3k●5●111●120) Aug 11 '14, 10:35 a.m.
 Hello,
I tried using RTC 5.0 - Query Editor
- type = Story
- Links --> Related --> Filed Against --> select category(ies) in the displayed tree
(you can multi-select categories)

Not sure what is missing here.

Eric

Attaullah Syed selected this answer as the correct answer

1 vote

Comments
Attaullah Syed
JAZZ DEVELOPER Aug 25 '14, 4:38 a.m.
 Thanks Eric. That worked on RTC 5.0.

Your answer

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,146
× 202

Question asked: Aug 11 '14, 6:50 a.m.

Question was seen: 6,308 times

Last updated: Aug 25 '14, 4:38 a.m.

Confirmation Cancel Confirm