Query: retrieve a parent work item with ALL childs resolved
I all,
I want to create a query in RTC which returns ALL work items for which ALL childs are resolved.
The problem I encounter is that when I select AND Children is -> Status resolved, it returns all work items for which there are one or more children that are resolved. Which is not what I want.
Is there a way to build such a query? I need it to determine for an administrator that there are parent work items which are ready for a promotion to a next environment.
Thanks,
Ulf Buchner
I want to create a query in RTC which returns ALL work items for which ALL childs are resolved.
The problem I encounter is that when I select AND Children is -> Status resolved, it returns all work items for which there are one or more children that are resolved. Which is not what I want.
Is there a way to build such a query? I need it to determine for an administrator that there are parent work items which are ready for a promotion to a next environment.
Thanks,
Ulf Buchner
2 answers
Hi.
I think the possibilities with work item queries are not powerful enough to express your demand.
As far as I understand, the only option you have is to produce a report.
Getting started is a walk in the park (but takes a little longer than just dragging and dropping a work item query).
Someone at developerworks just released a nice step-by-step guide on
http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part1/index.html
Happy reporting,
/Morten
I think the possibilities with work item queries are not powerful enough to express your demand.
As far as I understand, the only option you have is to produce a report.
Getting started is a walk in the park (but takes a little longer than just dragging and dropping a work item query).
Someone at developerworks just released a nice step-by-step guide on
http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part1/index.html
Happy reporting,
/Morten
Thanks Morten,
I was afraid of an answer like this ;-) I don't think the query is that complicated (I've used SQL for many years) but the possibilities of the query designer are indeed somewhat limited.
Is a report created with live information? So can we display such a report at any point in time? We need the information for instance to notify testers that there are work items ready to be tested.
Perhaps we will use a different approach, assinging the user which has to be notified as owner which will, hopefully, result in sending an E-mail to this person. Unfortunately we are not able to assign a group of people (or better: a role) as an owner. We could then notify all testers that there's stuff to be tested.
In the meantime we created a workaround query...
Thanks,
Ulf
I was afraid of an answer like this ;-) I don't think the query is that complicated (I've used SQL for many years) but the possibilities of the query designer are indeed somewhat limited.
Is a report created with live information? So can we display such a report at any point in time? We need the information for instance to notify testers that there are work items ready to be tested.
Perhaps we will use a different approach, assinging the user which has to be notified as owner which will, hopefully, result in sending an E-mail to this person. Unfortunately we are not able to assign a group of people (or better: a role) as an owner. We could then notify all testers that there's stuff to be tested.
In the meantime we created a workaround query...
Thanks,
Ulf