It's all about the answers!

Ask a question

query for items with no children


Alex Feinberg (2652) | asked May 29 '09, 11:23 a.m.
Greetings,

Let's say you have two work item types, Epic and Story, where Epics, by definition are parents of Stories. Now let's say you have a policy which states that all Epics must be decomposed to have at least one child Story, and you want an easy way to enforce the policy.

I can easily create an Epics query which displays children links. Of course, I can only define this query using the Web client, since the Eclipse client doesn't list the various links in the available columns, but I'm sure someone is already working on fixing that. This query is nice, but I'm greedy. I want to create another query which lists just those Epics which are violating my policy (i.e. they have no children). I can add a "Children exist" condition to my query, but there does not appear to be a "Children not exist" condition. Am I missing something or is RTC?

Thanks,
Alex Feinberg

One answer



permanent link
Patrick Streule (4.9k21) | answered May 31 '09, 7:56 a.m.
JAZZ DEVELOPER
I can easily create an Epics query which displays children links. Of
course, I can only define this query using the Web client, since the
Eclipse client doesn't list the various links in the available
columns, but I'm sure someone is already working on fixing that.

In the Eclipse UI, you can using the Relationships dialog (from the Work
Item view's menu) to turn on the hierarchical mode that shows the children
of the work items in the query. I agree that this should ahppen
automatically when the link attributes are included as query columns.

This query is nice, but I'm greedy. I want to create another query
which lists just those Epics which are violating my policy (i.e. they
have no children). I can add a "Children exist" condition
to my query, but there does not appear to be a "Children not
exist" condition. Am I missing something or is RTC?

This functionality is not available in 1.0.1 but it is in 2.0 (starting
with M3).

--
Regards,
Patrick
Jazz Work Item Team

Your answer


Register or to post your answer.