It's all about the answers!

Ask a question

How to query for work items with ALL children resolved?

Mike Shkolnik (9808160143) | asked Sep 14 '11, 7:10 p.m.
retagged Sep 21 '12, 5:05 p.m. by Richard Knaster (23817)
I am trying to query for stories/epics that need to be closed based on all their children being closed. I can query for ANY children resolved:

Status - is - Unresolved
Children> Status - is - Resolved

but I can't seem to query for ALL children resolved. Is there some way of doing this, or am I out of luck?

7 answers

permanent link
Nate Decker (37814059) | answered Jul 26 '16, 8:48 a.m.

This is an old question, but I thought I would post a note on here. We ran into the same difficulty in our environment. I eventually came to and started linking all the enhancements I could find that seemed to be requesting this capability. I think I found 3 or 4. Here is one of them:

In our situation, we came up with a workaround by developing an operation behavior (follow up action) that would count the number of blocking work items whenever a work item was saved and store that number in an attribute (which we called "Blocking Link Count"). We could then query for work items where the Blocking Link Count is zero.

Before we came up with that solution, we developed a stand-alone application that used the REST API to figure this out. So it was essentially a report.

Before that REST API solution, a proposed technique is to look at the plan and hide resolved work items. Work items in the plan with an expansion arrow were work items with unresolved children. If the expansion arrow was not present, then all children are closed.

Just a few ideas there...

permanent link
Mike Shkolnik (9808160143) | answered Sep 15 '11, 1:46 p.m.

Status - is - Unresolved
Children> Status - is - Resolved

I forgot to mention that if I add to this:

Children> Status - is not - Unresolved

the result is the same as without that third filter.

permanent link
Mike Shkolnik (9808160143) | answered Sep 05 '12, 3:00 p.m.
It's been a year since I asked. Is there really no way to do this? How are people determining which stories are ready to close if you can't query for it?

permanent link
sam detweiler (12.5k6194201) | answered Sep 05 '12, 5:16 p.m.
huh? the scrum master closes the story when the tasks and acceptance criteria are complete.<br>
the scrum master has a list of all workitems in this sprint. <br>


Oleg Patrakov commented Oct 12 '12, 12:39 p.m.

Sam, your response doesn't address the initial question at all. It's not a topic for discussion how and what SM should do in the team and so on.

Currently, we couldn't find a way to create a query Mike is asking about, and seems like there's no way to do it with what RTC currently provides.
If you know the way to prepare such a query, please, let us know

permanent link
Mike Shkolnik (9808160143) | answered Sep 05 '12, 6:25 p.m.
I am aware this is a Scrum Master responsibility. It appears to be an entirely manual process. I can't even create a query to list all the stories that are ready for closing based on all their children being closed. The alternative is to manually check every story (by checking each story's links) every day. Will all the Scrum Masters do that? No they won't. Thus we have to wait until sprint closeout and with so much lumped into sprint closeout, the Scrum Masters aren't getting that done either. We need a real-time list of ready-to-close stories.

Currently I am telling them to "expand all" in Work Breakdown view in the Eclipse client and to look for stories where all the children are closed. Again, a manual process, subject to Human error, and subject to failure when some children were moved to a different sprint. Yes, I tell them not to do that. Also, this forces them to use Eclipse and many of them are non-coders and should be using the web interface (which has no "expand all" in version 2.x). We need a real-time list of ready-to-close stories. This is something that should appear on a Team Lead Dashboard. It appears that doesn't exist even in version 4. I have subscribed to related work items on, but they are sitting in the backlog, unassigned. I was hoping there is a workaround out there. Something a little less manual and less error-prone.

permanent link
Guido Schneider (3.4k1485115) | answered Oct 13 '12, 10:30 a.m.

For this I wrote an enhancement request beginning of September:

I'm realy missing this and it should be implemented urgently! This should be a pre-configured query!

permanent link
Mike Shkolnik (9808160143) | answered Oct 15 '12, 1:13 p.m.
Thanks for helping to get some attention to this issue. I agree with you on the importance of this. It's creating an Agile adoption problem for us. Without timely closing of Stories, the execs don't trust the system or the methodology.

I wish IBM would decide to review all query enhancement requests and do a major update to the query engine. It needs it. I am subscribed to six myself (including yours) and there are likely many more.

Your answer

Register or to post your answer.