How to find all work items without any children in a query
![](http://jazz.net/_images/myphoto/6772618f181b279a261305d84bf51906.jpg)
Hi, I'm trying to create a work-item query from scratch and I want to show only work-items that don't have any children.
(actually this is a first step, my final result is that I want to show work items that either don't have any children, or only have children of type 'Task').
In the conditions list I can select Children, but the only operation is 'exists' but I want 'not exists'.
Is there a way of doing this?
Thanks, Colin.
(actually this is a first step, my final result is that I want to show work items that either don't have any children, or only have children of type 'Task').
In the conditions list I can select Children, but the only operation is 'exists' but I want 'not exists'.
Is there a way of doing this?
Thanks, Colin.
One answer
![](http://jazz.net/_images/myphoto/6772618f181b279a261305d84bf51906.jpg)
Hi, I'm trying to create a work-item query from scratch and I want to
show only work-items that don't have any children.
(actually this is a first step, my final result is that I want to show
work items that either don't have any children, or only have children
of type 'Task').
In the conditions list I can select Children, but the only operation
is 'exists' but I want 'not exists'.
Is there a way of doing this?
Thanks, Colin.
This functionality is available in 2.0 M3 and after.
--
Regards,
Patrick
Jazz Work Item Team