nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Jack Nolddor [Sweet Bananas]

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

All comments

Jack Nolddor [Sweet Bananas]

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 ?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

jql

epic