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.
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 / email@example.com
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
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")
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...
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