Report to return OPEN Parent WI only when all of its Child Tasks are CLOSED
Hello Team,
I am trying to fetch the OPEN STATE Parent Work Item of Type Change Request where all of its Child Tasks are in CLOSED STATE in JAZZ REPORTING SERVICE.
I created the report in following way:
- Established Parent and Child relationship
- Parent WI Type= Change request AND Status=OPEN
- Child Status= CLOSED
Report should display OPEN Parent WI only when all of its Child Tasks are CLOSED.
Quick help will be greatly appreciated.
Thanks in Advance,
Yogashree.M
2 answers
Hi,
You didn't mention which version of the solution you're using, but regardless this is quite a simple report. I just built it in a few minutes. Let me attach some screen shots.
This provides only Solution Epics (Parents) that are NOT in any Closed state with children that are in any Closed state.
Amy
