As the title says, I have a "tree of work items" query that shows all parent
work items ("Initiatives") that have a certain State
(here: Closed) with their respective children which are not closed, so it looks something like that:
Parent 1 [Closed]
Child 4 [New]
Child 5 [Active]
Parent 2 [Closed]
Parent 3 [Closed]
Child 2 [Ready]
Child 4 [Active]
How can I filter out the parent work items that don't have any matching children? I.e. Parent 2 should not show up as a result of the query.
You can use Work items and direct links type of query instead of tree of work items
See below screenshot: User Stores that don't have any matching children will be filtered out.