Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to create a filter that returns a list of EPICS that has at least one story within an active sprint

Atlassian JIRA v5.1
Atlassian GreenHopper v6.2

I want to create a filter that identifies a list of EPICS that has an associated story (Issues in EPIC) that are within an active sprint. I only want to return results that are EPICs and not the stories.


- An Epic (EPIC1) has a story (STORY1) listed under the 'Issues in EPIC' section.
- STORY1 has Active Sprint as SPRINT1

I require:
- EPIC1 to be returned within the search result.
- STORY1 will not be returned within the search result.

Is anyone able to provide a JQL example of how this can be achieved, that would be much appreciated.


3 answers

I don't think that's possible without plugins at the moment. If you can install plugins, then for example with Script Runner (other fine plugins offering similar are available), the query would be:

issueFunction in linkedIssuesOf("sprint in openSprints()", "has epic")

To break that down:

"sprint in openSprints()" is the subquery, you could add "and issuetype = Story" or other clauses. openSprints() is any active, not unstarted, sprints.

linkedIssuesOf finds any issues linked to isses in the subquery, following the specified link direction. In this case, epics and stories are connected by the "has epic/is epic of" link.

Does anyone know if Atlassian JIRA Agile v6.3 (formally known as greenhopper) contain this capability (without the need for a plugin)?

Any further help is appreciated.

ps. Thanks to Jamie for the plugin information.

Helped me so much :smile: 

Is there a easy ways to have a view for "Next" sprint.
Where I know there will be no easy solution like "sprint in openSprints()".

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Agile

On-demand: Fireside chat with Atlassian on scaling agile organizations

Scaling an agile organization and setting it up for success over the long term is a hard thing to do. We hear a common set of questions from customers all the time, questions like: Can agile scal...

4,000 views 2 17
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you