How to: Query which returns Stories where all child task are done

Erwin Kunz (946●8●61●81) | asked Aug 30 '12, 8:16 a.m.
edited Aug 30 '12, 8:17 a.m.

A scrum team would like to create a query where they can see all Stories where all child tasks are resolved

My setup:

Type: Story
Children>Status : resolved

Unfortunately this query returns stories which have at least one task resolved

Is that possible? Any hint?

Shall I forgett it and create a Plan instead..if it's possible there :-)

2 answers

Most liked answers ↑|Newest answers|Oldest answers

permanent link

David Olsen (523●7) | answered Aug 30 '12, 6:39 p.m.
JAZZ DEVELOPER

It is not possible to do that with a work item query. The query language isn't quite powerful enough.

I don't know if something similar can be done in a plan.

Comments

Guido Schneider commented Sep 01 '12, 4:32 p.m.

I have created a Enhancement Request, because this is a major functionality Project Leaders asking for:

https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=229817

permanent link

Richard Knaster (238●1●7) | answered Oct 12 '12, 12:04 a.m.

Possible Solutions:

1 Create a BIRT report to get the information from Rational Team Concert

How to create BIRT reports: https://jazz.net/wiki/bin/view/Main/Reports

2. Customize the Project Area Template to prevent a parent work item from being closed unless all its
children are done.

It's all about the answers!

Related questions

How to: Query which returns Stories where all child task are done

2 answers

Your answer