How to JQL list of Epics with at least one story/task in open sprints

[Maxim Maximov]

We have more or less standard process of Scrum in the 8 Scrum Team. On a high level we do planning and status update on the Epic level. Can I build a JQL to fetch list of Epics which have at least one ticket in the Active sprint?

I have combined almost what I need:

sprint in openSprints() and "Epic Link" != null order by "Scrum Team", "Epic Link"

but it's not ideal because I see same epic name several times and JQL does not support group by.

Maybe there is another approach to get what I need? We run Jira 8.1.

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi Maxim,

I believe you can get what are you looking for using a third-party app. Using i.e. JQL Booster Pack (FREE) you must type the following:

Retrieve Epics within issues belonging to an open sprint

issue IN epicsOf("sprint in openSprints()")

Regards

[Maxim Maximov]

This is what I was looking for. Thanks!

[Jérôme Rutily]

Hello !

I don't see any Free Version in your link. How can I get that on the Cloud version ?