How to filter Epics with all issue closed

[aleksa.isailovic]

Hi,

Is there an easy way to filter out all open epics that have no more open issues within?
I found that it is possible with some plugins, there is also option to make automation rule that automatically closes epics with all stories closed, but none of those is an option for me.
I just want to filter them out and to decide manually which to close.
Can perhaps automation rule do that filtering for me?

Thanks a lot!
Aleksa

[Mark Chaimungkalanont · Accepted solution]

 there is also option to make automation rule that automatically closes epics with all stories closed

You can follow the same logic with those Automation examples, but instead of transitioning the issues to "Closed" you can add a "Label" on the tickets and then create a filter subscription that emails you the issues that match that label.

Then you can manually go through the list of issues and close them off

[Jack Brickey]

But this would only work if the issues have not yet transitioned to done. If you have a lot of old open epics with done children then you would need to ferret out manually, I think, right?

[aleksa.isailovic]

I would say that it could work with Label. I basically tried to reuse predefined Jira automation rule - to send me the email with list of such issues (instead of transitioning them to Done/Closed) but it was not possible unfortunately.
Thank you for the hint!

[Jack Brickey]

So in this situation...

epic not in Done status but all children in Done status...

then what is the trigger to add label to each child?

[aleksa.isailovic]

Could be - scheduled job every 2 weeks or manual run.

[Jack Brickey · Accepted solution]

without an addon, e.g. scriptrunner, you would need to run a query that includes all epics and export to excel where you could inspect more completely.

[aleksa.isailovic]

I was hoping that Jira has some solution for this, but your work-around is pretty pragmatical. Thank you very much for response!

[coolcodeiguess]

An answer you can adapt to your need is here: https://community.atlassian.com/t5/Jira-Software-questions/Re-Need-query-to-find-epics-where-all-the-children-are-i/qaq-p/2511187/comment-id/683627#M683627

[Jack Brickey]

If you have Scriptrunner that post is useful for sure.