Create a query to show all work items with all of their children in a completed state
I am on EWM 7.0.2
I have seen this question asked in the past with no clear responses.
I am trying to query:
Show me all open parent work items that have all of their children in a completed state.
I am trying to query:
Show me all open parent work items that have all of their children in a completed state.
I am not using plans. I have tried this in the query editor using the positive and the negative:
children with status != open_states AND children with status = completed
I have tried it in the report builder:
NOT children with status != completed
children with status != open_states AND children with status = completed
I have tried it in the report builder:
NOT children with status != completed
UPDATE: I recognize this cannot be done using queries and will have to be done in Report Builder. Has anyone done this before? Is this something I need to use the API for?