How to find Epics in open sprints

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

2 answers

This widget could not be displayed.

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

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.

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

This widget could not be displayed.

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

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!

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

225 views 3 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you