It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to find Epics where all issues are resolved

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

Thanks

Tracy

2 answers

2 accepted

1 vote
Answer accepted

Hi Tracy

You need a  script runner plugin and try JQL like below

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

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

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.

0 votes
Answer accepted

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:

key in epicsOf("resolution is not empty")

Thank you!  I will look into this too.

 

Tracy

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you