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()

[Rene Carpio]

I like prodigy alont

[Rene Carpio]

I like the epics

[Rene Carpio]

I like prodigy

[Rene Carpio]

How to find epics

[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. :) 

[Wenhui Tan]

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. 

[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