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
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.
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
Susan Hanson
Apr 07 '14, 7:32 p.m.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
1 vote
Sunita Dinakar
Apr 07 '14, 7:36 p.m.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.