Get list of Epics where there are No Open child issues

Melissa Donatell

I'm trying to put together a filter that captures the following data and I'm having a little trouble figuring it out.

Looking for  a list of Epics where all the Child Issues are Complete. (No Open linked issues)

• Epic Project = DF
• Epic Status: Not in Complete
• Child Issues 
  • Status in Done, Complete, Completed
  • Child issues can be in Project DF or DRVIZ
• I only want the list of Epics, not the children

I'm using the Query to find out if I can mark the Epic as Complete or if I need to create more Child Issues.

Thanks for any help you can provide.

Dave Rosenlund (Trundl)

Welcome to the community, @Melissa Donatell   👋

Someone smarter than me will hopefully have a better answer/workaround, but AFAIK, what you want to do is not possible with Jira out of the box. Sorry.

That's because the LinkedIssues function only works on one issue at a time (you have to specifiy the issueKey one Epic at time).

So, I don't think it's possible with a JQL filter.

That said, maybe the CascadesOption will work for you (I've never used it myself), but it requires you to have a custom field, so I'm skeptical that it will.

You may want to keep an eye on Jira's new Lists feature. It's only been released on a limited basis for now (you may not have it yet). Atlassian made some big announcements about enhancements in this area last week at Team'24. It's going to get better and better.

You may want to check out the Atlassian Marketplace in the short term. There may be an app there that can help you do this.

Off the top of my head, Structure (from Tempo) and/or JXL (from Fine Software) may be able to help you. There may be others, too.

Hope this helps,

-dave