ScriptRunner Enhanced Search for epicsOf where all child issues are in the same status

[Tony Rossiter]

I've got a user request to pull all Epics in specific statuses where all of their child issue are in a Done status.  The query below pulls Epics where at least one of the children are done: 

status = Approved and issueFunction in epicsOf("issuetype = story and statusCategory in ("Done") and project = "LB - CPQ&O1" and fixVersion = "LB PI4 Jun03-Aug25"")

Is there a way to pull only the Epics where all of the children are in statusCategory = Done?  Below does not seem to work as expected as I'm getting epics with To Do and In Progress children: 

issueFunction in epicsOf("issuetype = story and statusCategory = "Done" and project = "LB - CPQ&O1" and fixVersion = "LB PI4 Jun03-Aug25"")

Thanks in advance anyone can give.

[Andrew Morin · Accepted solution]

So the first query here will return all of the issues in the Epics that are in the Accepted status. The filter ID =191122

issueFunction in issuesInEpics("project = 'Jira Align Implementations'") AND status = Accepted

I then saved that query and tried to use it in the following.

issueFunction in epicsOf("filter = 191122") AND status != Accepted

This returned the Epics but it still included the Epics that had only one story in Accepted status and other Stories that were open. I just don't think this function can do that parsing of the issues in the Epic. I also tried a few versions with issueFunction in linkedIssuesOf("issuetype = Story") AND issueFunction in linkedIssuesOf("status = Accepted") but I could never get it to only pull back the Epics that had all children in a single status

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html

Good luck!

[Tony Rossiter]

@Andrew Morin 

Thanks so much for trying to get to the solution on this.  I think, unless anybody else has any big ideas, that this just isn't something possible.

Tony