JQL query to fetch all EPICS which are marked as DONE but has Undone Linked issues

[asachdeva]

Friends,

I am looking for a mechanism via which I can find out all the EPICS that are marked as DONE but still has some linked issues that are still not DONE.

EPIC1 (DONE) - Story1(DONE), Story2(DONE), Story3(TODO), Story4(IN PROGRESS)

EPIC2 (DONE) - Story1(DONE), Story2(DONE), Story3(DONE), Story4(DONE)

The output should be EPIC1 as it has been marked as DONE but still has Story3 and Story4 that are still not completed.

Looking forward to hear back soon.

Ashish

[Lauma Cīrule · Accepted solution]

Hi @asachdeva,

As you mentioned you are interested in apps that could resolve the question, I would like to suggest looking at eazyBI. You can create an Epic Status dimension and filter to get all issues based on the status of Epic and issues themselves. 

See an example report: https://eazybi.com/accounts/22010/cubes/Issues/reports/844996-issue-epic-hierarchy-for-epics-in-progress. Here we have all in progress epics, and you can expand to see issues within the Epic. Additionally, there is a group of Standard issue count split by issue Status.

Let me know if you have further questions regarding this in eazyBI!
Lauma / support@eazybi.com

[Trudy Claspill · Accepted solution]

Hello @asachdeva 

Welcome to the community.

Jira does not natively provide JQL functionality to get what you want.

Would you consider subscribing to a third party app?

[asachdeva]

Sure, would love to hear on such third party app.

[Trudy Claspill]

I have not researched for one that would enable you to get this specific report.

There are a variety of apps that extend JQL functionality that might enable you to construct the query you want, as well as apps that support more custom reporting.

Adaptavist Scriptrunner is an app that includes JQL extension functions. I used that at a former employer and found it to be very powerful. In fact, they have a function that would suit your needs precisely

epicsOf

JIRA Agile users can query on epic links, eg find all Epics that have unresolved stories:

issueFunction in epicsOf("resolution = unresolved")

You would just need to add a bit to the query to constrain it to only the Epics that are marked as Done

"Epic Status" = Done and issueFunction in epicsOf("resolution = unresolved")