Need help on JQL that can list all EPIC (Feature) which is open but has its child issues are closed

Question

Need help on how i can frame the jql that can list all features which are kept open while it has all child issues are closed.

I tried with below JQL however it list Features which has mix of both closed and open story/ task linked to it.

project =ECPRV and issueType = Epic  and status not in(Releasing, Closed, Cancelled) and issueFunction in epicsOf( "project =ECPRV  and issueType in(story, bug,Sub-task, Bug, Task) and status not in (Refined, 'In Backlog', Cancelled, 'ON HOLD', PRIORITIZED, 'READY FOR DEVELOPMENT', 'IN DEV', 'READY FOR QA', 'IN QA', 'IN UAT')")

Marc -Devoteam- · Answer

Hi @Jaikumar Kochi

Welcome to the community.

@Piyush Annadate _ACE Pune_ is right, you need a 3rd party app to solve this.

Check the available option on the Atlassian Marketplace.

P.S. I personally like; https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira?hosting=datacenter&tab=overview

Piyush Annadate _ACE Pune_ · Answer

Hi @Jaikumar Kochi ,
Welcome to the Community !

Do you have scriptrunner? As 'issuefunction in' is a addon provided by Adaptavist - Scriptrunner plugin.

On a note: jira doesn't have native functionality to query child issues based on filter.
Refer my comment for the same https://community.atlassian.com/forums/Jira-questions/Re-How-to-get-the-child-issues-list-by-using-a-JQL-filter/qaq-p/3017674/comment-id/1124198#M1124198