nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Trudy P Claspill

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/

All comments

Trudy P Claspill

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!

Yong Yang

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.

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud