Filter Issues by Sprint Name

[ebony burroughs]

In my Jira project, there are 6 scrum teams sharing a single backlog. It's the worst because when each team creates future sprints, all the future sprints for all the teams show up in the backlog.I I think I figured out the JQL but the statement keeps getting kicked back. Any idea what's broken here?

sprint in openSprints() AND sprint in futureSprints() AND sprint in (name ~ "Emerald") ORDER BY created DESC

[Trudy Claspill · Accepted solution]

Hello @ebony burroughs 

Welcome to the Atlassian community.

You can set a filter such as 

sprint=Emerald

...to get all the issues that are in Sprints (past, current, or future) where "Emerald" is part of the sprint name. 

However, that would exclude issues not assigned to any sprint. To include such you would need to add:

sprint is empty

And if the issues had been in the team's sprints in the past but is now owned by a different team, to exclude the assignments for previous closed sprints you would want to add

sprint in openSprints() or sprint in futureSprints()

Altogether the filter would be

sprint is empty or (sprint=Emerald and (sprint in openSprints() or sprint in futureSprints()))

An alternative would be to make use of the native Team field to set an owning team for each issue and then filter based on that.

https://support.atlassian.com/atlassian-account/docs/what-is-an-atlassian-team/

https://support.atlassian.com/atlassian-account/docs/using-atlassian-teams-in-jira-projects/

[ebony burroughs]

This gets me what I need! Thank you!

[Mudassar Pasha]

Hi @ebony burroughs , I  am wondering how you set this up. I am having the same problem and it is quite a pickle considering the size of our program. Would you be able to help me out with this please?

[Heather Hale]

The search works well for alpha characters: sprint = Emerald

but if you are using a numeric value (ie, you want everything for Sprint 55, for every team), you have to put quotes around it: sprint = "55" or JIRA will look for the sprint value IT sets to = 55. Just a tip. 

[YY Brother]

Hi @ebony burroughs 

Welcome to our Community.

I suggest you split the currrent single project into 6 scrum boards, each of which is for a specific scrum team. By changing the way of management, collaboration and management will be easier.

Thanks,

YY哥

[ebony burroughs]

That would be my preference as well but due to organizational constraints, this is not an option in the short-term.