Need query to find epics where all the children are in a status of "To Do"

Cash Coyne_tanpr0

 

I'm able to find Epics where there are children that are In Progress with this ScriptRunner query:

issueFunction in epicsOf("project in (PrjA,PrjB) AND issuetype in standardissuetypes() and status not in ('To Do',Done)") and project in (PrjA,PrjB)

Now I want to find find epics where all the children are in a status of "To Do", and no other status

Any suggestions on that?

 

 

Cash Coyne_tanpr0

Thanks to all for the JQL and ScriptRunner queries but unfortunately none of them gave me what I was looking for.  

I ended up creating a scheduled rule in Jira Automation and ran it once:

Using this JQL for the Schedule: project = RFP and issuetype = epic order by issuekey

Then; Create Variable: CurEpicKey = {{issue.key}}

And: Lookup Issues for this JQL: issuetype in standardissuetypes() and "Epic Link" = {{CurEpicKey}}

And: Create Variable: TotChildren = {{lookupIssues.size}}

And: Lookup Issues: issuetype in standardissuetypes() and "Epic Link" = {{CurEpicKey}} and status = "To Do"

And: Create Variable: TotToDo = {{lookupIssues.size}}

Then If: {{TotChildren}} does not equal 0

Then If: {{TotChildren}} equals {{TotToDo}}

Then add value to the audit log: {{CurEpicKey}},

 

After I run it, I can grab the string of keys from the audit log and throw it in a Jira Query.

 

I only need to use this periodically for cleanup of orphaned ideas/wants/thought, but it will save me a ton of time when I do