To identify epic status is done, but child issues has in progress

[Ramesh Krishnan]

lets take example .here is epic is parent, and story is child.

Epic 1 status is Done

1.  child 01 status is in progress
2. child 02 status is To Do
3. child 03 status is Done

Epic 2 status is In progress

1.  child 21 status is Done
2. child 22 status is Done
3. child 22 status is Done

I would like to genarate report or trigger email which child has not closed but epic has done status and vice versa

Do we have any script for this use cases.

[John Elder · Accepted solution]

When this type of scenario occurs, we use Automation for this and have two in place.  One that automatically transitions the Epic back to "In Progress" and one that sends an email to the initiator that the Epic can not be marked 'Done' because there are child work items under it that are not yet complete. 

We use the "Related work items condition" as part of our "if" statement, and select either 'Children' or 'Stories (or other work items in this Epic' as the parameter.  This works flawlessly and keeps our workflow integrity intact along with notifying our users of the issue.

When the second scenario occurs, we actually put in automation that automatically closes the Epics when all child work items are marked 'Done'.  This may not work for everyone but before we put this in place, we had thousands of Epics left open and floating in the wind... once that automation was put into production, we no longer have these childless Epics out there, requiring cleanup.

[Ramesh Krishnan]

Thank you so much for the details. let me explore that

[Danut M _StonikByte_ · Accepted solution]

Hi @Ramesh Krishnan,

I see no way in doing this by JQL filtering. But you could try other potential solutions:

1. Use the List view available under each project /space to see the epics along with their child issue and status in a hierarchical view.  

 

2. Use an app (plugin) from Atlassian Marketplace. For example, our Great Gadgets app offers a Work Breakdown Structure (WBS) gadget that can display the issues from a filter/JQL by their hierarchy Epic > Stories > Sub-tasks along with their status. 

This way you can easily visualize the epics along with their child issues and status.

Danut.