Query for Specific Sprint Name

[rcdpanjaitan]

Hello

My case is I have a project with several teams on it and the sprint is running paralel.

so, it looks like this on the active sprint board:

- Sprint 25 Team X

- Sprint 25 Team Y

- Sprint 25 Team Z

I'm trying to make query for each team, but if I use sprint in openSprints (), it will return all of them. Any idea to make it specific? is there any substring function?

Thank you 

[Bill Sheboy · Accepted solution]

Hi @rcdpanjaitan 

How are you distinguishing teams?  For example, with components, labels, etc.  You can check the board filters to confirm this.

Once you know how the teams are distinguished, you may add that to your query.  Let's assume you are using components, then the query would be:

project = myProjectName AND sprint IN openSprints() AND component IN ("Team X") ORDER BY Key ASC

Kind regards,
Bill

[rcdpanjaitan]

Hi Bill,

Nice idea. I think we missed this part, so we cant distinguish the backlogs

thank you.

regards.

[Henning Tietgens]

You can use sprint = "Team X" to find all sprints containing "Team X" in the name.

Best,
Henning