Problem with RTC Query results
Hi,
I'm trying to query for all defects whose children task's priority is not High. The results are not accurate, if the defect has two tasks, one task with priority low while the other has priority has high - This defect is also displayed in my results although one of the task coes not match my query condtion. I could work around this problem by querying for the tasks and getting the parent id. But this is a two step process and I wish to look for the defects instead of tasks. Is there a way to do this or am I doing something wrong here?
Thanks,
Sunita
|
3 answers
Geoffrey Clemm (30.1k●3●30●35)
| answered Apr 08 '14, 4:02 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
This functionality ("all related match") is not currently available in the GUI query builder. I've created work item Provide query item for "all related work items match" (311162) for it.
|
Hi Sunita,
Not sure if this is going to give the output you expected, but you may want to try the following conditions and see if it works: Type is Defect AND Children>Priority is low AND Children>Priority is not high. Comments
Sunita Dinakar
commented Apr 07 '14, 3:52 p.m.
Hi Kot,
Thank you for the response. But No, that doesn't help as well.
|
Hi Sunita
https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=229817
|
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.
Comments
This has been tried/asked a few times in different ways and I don't believe there is a solution available in RTC. Basically, you need a way to add something to the query when dealing with child tasks to say whether it should query based on "all children meet this criteria" or "any child meets this criteria". Today, I believe it is the latter is what is happening. In your case, you want all defects where ALL children have a priority that is not high and what you are getting returned is all defects where ANY child has a priority that is not high. I don't believe this is supported today (although if someone can find a way, I would love to know).
Susan
Susan - Spot on! You explained my problem the perfect way anyone could. I just raised a PMR for this issue, let me see what the response would be and share if its anything positive.