How to find a list of epics not closed but child issues are closed using JQL Search Extensions

Owned by Teja(Appfire)
Last updated: Aug 02, 2023 by Avinash Bhagawati
2 min read

This article explains how to find the list of Epics where all the child issues are in Closed or Done status, and Epic is not Resolved in Jira Server/Data Center using JQL Search Extensions.

 All you have to do is follow these steps:

  1. Navigate to the Jira Advanced Search bar and create a filter with the help of epicOf JQL function, as shown below:

    issue in epicOf("resolution is empty")

The above query checks whether the child issue resolution is empty or not. If the child resolution is empty then the query will display their epic.

 

2. Add the filter to the following JQL, as shown in the screenshot:

filter!="List of Epics(Child issues Closed)" and type=Epic and status!=Done

3. Epics can be searched with the below JQL:

issue in epicOf("resolution is not empty") and type=Epic and status!=Done

4. Alternatively, you can use this filter as well to get the list of epics where the Epic is not resolved and all the child issues are in Done stats:

Â