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

Tony Rossiter_hj465k

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

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!