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

Question

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

Trudy P Claspill · Accepted Answer

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?

Lauma Cīrule · Accepted Answer

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