nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to find Epics where all issues are resolved

Tracy Soma

I am trying to figure out the jql syntax to find all epics that have resolved or closed issues.

Thanks

Tracy

Accepted answers

Daniel Deng

Hi Tracy

You need a script runner plugin and try JQL like below

issuetype = epic and not (issueFunction in linkedIssuesOf("status != Closed", "has Epic"))

Alexey Matveev

Hello,

You could do it with the Power Scripts add-on as well:

https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation?hosting=cloud&tab=overview

Your JQL query would look like this:

"resolution is not empty")key in epicsOf(

All comments

Daniel Deng

Hi Tracy

You need a script runner plugin and try JQL like below

issuetype = epic and not (issueFunction in linkedIssuesOf("status != Closed", "has Epic"))

Alexey Matveev

Hello,

You could do it with the Power Scripts add-on as well:

https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation?hosting=cloud&tab=overview

Your JQL query would look like this:

"resolution is not empty")key in epicsOf(

Tracy Soma

Thank you! I will look into this too.

Tracy

axel_gruettner

Hi Daniel,

when trying your JQL I get the following error.

"Could not find any issue link type having either inward or outward description: has Epic. Remove argument to search all link types. Available links are: [clones, is cloned by, created, created by, Depends on, Depending Issue, duplicates, is duplicated by, is Epic of, has Epic, Related to, Related from, tests, tested by]"

Any clue what went wrong?

Thanks Axel

Steffen Jantke

There is a difference between the status values Resolved and Closed. You can resolve an issue, but then it is not closed automatically. Perhaps the above query from Daniel does not match your assumption one hundred percent.

How about this?

issuetype = epic and not (issueFunction in linkedIssuesOf("status NOT IN (Resolved, Closed)", "has Epic"))

I currently have similar problems with my query and this one worked for me.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira