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 find Epics in open sprints

Paul Alexander

Since an Epic by design is not associated with a Sprint, it can not be included in a JQL query with a function like this. The goal is to create a filter that could be fed to a dashboard that includes only Epics that have linked issues (other parents) in open sprints...and be able to include them with the linked issues...better yet, extract just the Epics. Is there a solution for a Cloud user?

sprint in openSprints()

Accepted answers

All comments

Andre Borzzatto

Hi Paul,

It should be possible to track it using only JQL if you are using the default settings of JIRA Agile.

As JIRA Agile tracks the Epic issue using a specific issue type, the Epic issue type:

sprint in openSprints() and issuetype = Epic

Not sure, but I think it works in the intended way.

I hope it helps!

Cheers!

Andre

Paul Alexander

I do have a highly customized environment, but my definition around the epic object is the default. Issuing your JQL query yields no results. You claim this works by design...is it possible I've done something to abstract the default behavior?? As far as I have ever been able to tell (going back two years), an Epic by design is not associated with a sprint since a sprint only seems to contain parent issues (excluding the Epic). Love some help on this, Andre.

Paul Alexander

In fact, have a look at my more recent inquiry...here --> https://answers.atlassian.com/questions/13420008

Shamee

As Epics are not associated to a Sprint, It's not straightforward to create a filter referencing Sprint number. The below JQL helps to get the list of epics in a

Active Sprint.

project = "XY" AND issueFunction in linkedIssuesOf("sprint in openSprints()", "has epic") ORDER BY cf[10007] ASC, summary ASC

Closed Sprint

project = "XY" AND issueFunction in linkedIssuesOf("sprint in openSprints()", "has epic") ORDER BY cf[10007] ASC, summary ASC

Previous Sprint

project = "XY" AND issueFunction in linkedIssuesOf("sprint in prevSprints()", "has epic") ORDER BY cf[10007] ASC, summary ASC

Paul Alexander

Shamee, perhaps these functions are available in the Server/Data Center platforms, but they're not available in the Cloud platform. That would be awesome to have though!

Blake Pusztai

@Shamee This is excellent. How can I filter the epic results to find ones with a certain component, or really any value? Simply doing the following eliminates all results because my team only applies components to the epics:

project = "XY" AND issueFunction in linkedIssuesOf("sprint in openSprints()", "has epic") AND component in ("ABC")

Edit: I figured it out. Nevermind. It helps when epics with component "ABC" actually have stories in a sprint.

How to find epics

I like prodigy

I like the epics

I like prodigy alont

I got an error: Field 'issueFunction' does not exist or you do not have permission to view it. I guess it is not available in Cloud platform.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql