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
- 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.
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.
Thomas Deiler is a Bavarian, Mountaineering, Senior Agile Coach. In this Showcase, you will learn about his journey from software engineer to project manager, his freelance philosophy, and much more....
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!
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot