Query that excludes parents with "done" tasks

Question

I currently have a query set up in TFS 2015 with the following parameters:

Work Item Type = [Any]

AND

State <> Done

AND

Assigned To = Derek Antrican

This is working well, but currently it will continue to show parent items that I have completed tasks for (because another tfs member has yet to complete a task for that parent). I would like to exclude parent items that have no more tasks assigned to me that are yet to be completed. So ending up with something like this:

Work Item Type = Task

AND

Work Item Type = Product Backlog,Bug IF Child Assigned To = Derek Antrican AND Child State <> Done

AND

State <> Done

AND

Assigned To = Derek Antrican

How do I implement the bold part above?

score 1 · Accepted Answer · answered Apr 28 '16 at 18:02

1

I think this is what you want. You'll need to configure your query to be of type "Work Items and Direct Links" and then filter the children to be assigned to you (it's easier to use @me here):

Note: The separator for the "in" operator depends on your system settings. In my culture (Dutch), it's ;, but it may be different for yours.

answered Apr 28 '16 at 18:02

jessehouwing

106,458
22
256
341

Thanks! Out of curiosity, is this possible with a Flat List (instead of "Work Items and Direct Links")? – derekantrican Apr 28 '16 at 18:40
No it's not possible with Flat list. Only with Direct Links or tree based queries. – jessehouwing Apr 28 '16 at 18:42

Query that excludes parents with "done" tasks

1 Answers1

Linked