How can show Epics which have "Epic Issues" in a specific sprint

[Abir Brahem]

Hello, do you know how to filter only the Epics that have Tickets planified in the current sprint? plz

[Mark Segall · Accepted solution]

Hi @Abir Brahem and welcome to the community!

Without a marketplace app, your best bet would be capturing something like this on a dashboard using something like the pie chart  or filter statistics gadget grouped by Epic Link.  Otherwise, you could use a query like this and simply eyeball it:

sprint in openSprints() ORDER BY "Epic Link" ASC

NOTE - This assumes you're working with a company managed project.  Change my Epic Link references to Parent if you're working with a Team-Managed project.

If you're working in a Server/DC environment you can use a marketplace app like scriptrunner to perform the query.

[Abir Brahem]

Hello Mark, thank you for the answer.

I am traying to select the Epics which are in an up level, I dont have the "Epic Link" option. 

knowing that, a Epic has many child (USs) which are planned in diffrent itérations 

[Mark Segall]

If Epic Link isn't available to you, it likely means your project is set up as a Team-Managed project so you'd want to use Parent instead.

[John Funk]

Hi @Abir Brahem - Were you able to validate Mark's suggestion? I am going to mark his answer as accepted, but let us know if you still have questions.