Define which sprint satisfies nextSprint() JQL query

[Tony White]

I have a JQL set up as follows:

project = "my project" AND Sprint in nextSprint("project board")

The "nextSprint()" query however returns nothing, not as expected per my set up.

I have two sprints with dates assigned:

• Sprint 1 (ACTIVE) : 7/29 - 8/12
• Sprint 2 : 8/12 - 8/26
• Backlog

And no other sprints. It seems to me by dates or by process of elimination, the system should know nextSprint() = Sprint 2

Am I missing a step in defining that is explicitly "next sprint"?

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Tony White and welcome to the community!

I've tried the following JQL on the scriptrunner enhanced search:

project = "Software Project" AND issueFunction in nextSprint("Scrum Board")

and it worked fine! However, the "Scrum Board" is indeed a scrum board. Can you please check that the board you are using is a scrum and not a kanban board?

Alex

[Tony White]

Hey Alex, it is a scrum board, but I'm realizing that I'm not actually sure if my company instance has scriptrunner enhanced search. I'm not sure where to check if it's available, but if it helps you to know without having visual, I can successfully pull tickets using:

• currentSprints()
• futureSprints()

... just not nextSprint()

[Alex Koxaras _Relational_]

Nextsprint can is a JQL from scriptrunner. TO see if you have enhanced search:

• go to header menu -> Apps
• ScriptRunner Enhanced Search

[Tony White]

Update @Alex Koxaras _Relational_ actually you're correct. I have the sprints set up in my scrum board, but I was attempting to pull those tickets into a kanban as my supervisor requested to see a kanban that has swimlanes by studio/vendor studios as well as by product (which we're organizing at an epic level for sustainment)

So yeah it appears I'm strapped for trying to use nextSprint() within my kanban board Quick Filters unless there's still a way

EDIT: and also I checked and we do in fact have scriptrunner

[Alex Koxaras _Relational_]

So what you could do is:

• Use the enhanced search to create the filter
• Save the filter and sync it so that you can use it on your Jira filters
• Run the filter from your Jira in order to get the filter ID (e.g. 10003)
• Go to your kanban board and add a quick filter with a jql: filter = 10003

This will work, but keep in mind that once you sync this filter, it will become "static". So you have to resync it often.

Scriptrunner dynamic filter:

Jira "synced" filter:

As you see in the image above, the synced filter return the actual issue ids

[Alex Koxaras _Relational_]

@Tony White if you are ok with the above answer, kindly mark my answer as accepted, in order to help others! Thanx!