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.
Eg.
- 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.
Thanks,
Glenn
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Helped me so much
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()".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There is https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_nextsprint. Maybe other ways too.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Recommended Learning For You
Level up your skills with Atlassian learning
Jira Align Program Essentials
Learn how to use Jira Align at the program level and how to plan for and manage your Program Increment (PI).
Managing Agile Boards and Reports
Learn how to pick the right board type for your team and customize it to fit your specific requirements.
Atlassian Certified Associate
Jira Software Board Configuration
Earn an associate-level credential from Atlassian that shows you can effectively configure Jira Software boards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.