Is there a way to pull a query that shows Epics that have all their child issues resolved/closed?

Question

Like the title says. I've tried a few different things and right now I'm trapped looking at this:

issueFunction in parentsOf("resolution is not EMPTY")

As you can imagine, it is not pulling what I want.

I have access to Script Runner.

Any help would be massively appreciated!

Ste Wright · Answer

Hi @Sofie Palacios

This should work:

issueFunction in epicsOf("resolution is not EMPTY")

See more information on this function on Adaptavist's help site: https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/issue-links#epicsOf

Ste

Kalyan Sattaluri_iinm1n · Answer

where XXXX is the project where epics live.

Kalyan Sattaluri_iinm1n · Answer

Hello @Sofie Palacios

I am in DC and this is how I look for Epics where *all* stories are done:

issuefunction in epicsOf('issueFunction in issuesInEpics("project = XXXX") and status = Done') 
and not
issuefunction in epicsOf('issueFunction in issuesInEpics("project = XXXX") and status != Done')

Hope it works.