Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

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

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

2 answers

2 accepted

0 votes
Answer accepted

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

0 votes
Answer accepted

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?

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

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")

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

578 views 21 25
Read article

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