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

[Sofie Palacios]

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]

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]

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.

[Kalyan Sattaluri]

where XXXX is the project where epics live.

[Jack Brickey]

Hi @Sofie Palacios , it may be different in DC but in Cloud I can use the following...

issueFunction in epicsOf("resolution = unresolved")