Done/Resolved Epics with UnResolved/NOT Done Issues (Story/Task/etc.)

Question

I want a view of Epics that are Done/Resolved but the Issues in that Epic are NOT Done and Unresolved.  This seems to be very hard for me to do, even with the opposite below.

Any help is much appreciated!

This would be something similar to below answer from @JamieA  but also different.

This is tricky but doable. But you need the jql functions from the script runner plugin (couple of other plugins can do similar to be fair).

The query is like this:

status != Done and 
    issueFunction in linkedIssuesOf("status = Done", "has epic") and 
    not issueFunction in linkedIssuesOf("status != Done", "has epic")

To translate this:

status != Done: Find epics that are not done. You might need to change the status names

issueFunction in linkedIssuesOf("status = Done", "has epic"): This is the tricky but... find issues that have a "has epic" link to an issue with status = Done.

not issueFunction in linkedIssuesOf("status != Done", "has epic"): Even harder here is the requirement that all the linked issues must be Done, so we filter out any epics that that have stories that are not done.

Not the sort of thing you could expect a user to do but you might be able to set it up for them.

Дина Соболева · Answer

issueFunction in epicsOf("Resolution = Unresolved") and statusCategory in (Done)

Alex Lithgow · Answer

Thank you @Jack Nolddor [Sweet Bananas] .  I need to use native Jira search but i'll keep that in mind in case something changes in future.

Jack Nolddor [Sweet Bananas] · Answer

Hi Alex,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

1) Search for resolved Epics having unresolved issues

resolution IS NOT EMPTY AND issue NOT IN epicsOf(' resolution is EMPTY AND "Epic Link" IS NOT EMPTY ')

(*) Note that this is just an example, you must tune above query to fit your needs. e.g. Use issueFunction keyword instead of issue if you are using Script Runner

Using this app you can also query other issues relations, check:

* epicsOf()
* hasSubtasks()
* issuesInEpics()
* linkedIssuesOf()
* parentsOf()
* portfolioChildOf()
* portfolioParentOf()
* subtasksOf()

References:

* Official documentation

Hope this helps you to create awesome queries <3