Is there a way to list Epics with status != Done and their issues are with Status = Done

[Nauman Ikram]

1 - I need only EPICS 

2 - EPICS STATUS != DONE    (or UNRESOLVED)

3 - EPICS Issues has STATUS = DONE (if any of issue is not in DONE status, EPIC should be excluded)

[Petter Gonçalves]

Hello Nauman,

I hope you are having a nice day.

The JQL language does not have a parameter to return Epic based on the details of the linked issues, however, there are some add-ons that can provide you this functionality.

For JIRA Cloud, you can use the parameter epicOfQuery provided by the JQL Search Extensions for Jira add-on:

issuetype = Epic and status != done and epicOfQuery = "status = Done"

That been said, I'm not sure if the query will also return the Epic which has sub-tasks that are "Done" and also "not Done", but I think the JQL runs for each one of them and deny if any task does not match the criteria.

Let me know if this information helps.

[Nauman Ikram]

I don't have jira add-on with me.