A filter that identifies a list of Epics

Question

I want to create a filter that identifies a list of Epics that has an associated tickets (Issues in Epic) that are within an active sprint. I only want to return results that are Epics and not the linked tickets.
e.g.

* An Epic (EPIC1) has a ticket (DEV1) listed under the 'Issues in Epic' section.
* DEV1 has Active Sprint as SPRINT1
I require:
* EPIC1 to be returned within the search result.
* DEV1 will not be returned within the search result.

How can I create a filter to realize this? Please someone provide me with actual JQL statement.

Hisamitsu Koga_cv95ul · Answer

Hi Sam,

Thank you for your answer.

Sam Hall_h1otcf · Answer

Hi Hisamitsu,

As far as I know, the answer given here is still accurate: https://answers.atlassian.com/questions/203497/how-to-create-a-filter-that-returns-a-list-of-epics-that-has-at-least-one-story-within-an-active-sprint

It's not possible without an add-on.

Sam