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; } } }

JQL for next sprint

Shirley_q1an3i

Does anyone know if there is syntax to filter for the next sprint? To help with planning for our next 2-week sprint, I have several filters set up that include the sprint ID for our next sprint but I have to manually update the sprint ID in the filters at each sprint change. I have created all my sprints for the year so the the sprint ID numbers are sequential and I have added start and end dates to each sprint.

I know there is syntax to filter for the sprint that was just closed: sprint in closedSprints() AND resolved >= -14d

Is there anything similar to look two weeks or less in the future?

Accepted answers

Sagar Mahajan_d8sqh7

Hi @Shirley There are some advanced JQL functions available which you can used to filter the issues from future sprint like below:

sprint in futureSprints()

If you are Scriptrunner plugin then you can use the below JQL as well

Sprint in nextSprint(Board Name)

Further you can check the below Atlassian document for getting more filter results based on board name, project name etc.

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

For Script runner please check this document.

https://scriptrunner.adaptavist.com/5.0.4/jira/jql-functions.html#_nextsprint

Let me know if you find these JQL functions useful and fulfill your requirement.

All comments

Sagar Mahajan_d8sqh7

Hi @Shirley There are some advanced JQL functions available which you can used to filter the issues from future sprint like below:

sprint in futureSprints()

If you are Scriptrunner plugin then you can use the below JQL as well

Sprint in nextSprint(Board Name)

Further you can check the below Atlassian document for getting more filter results based on board name, project name etc.

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

For Script runner please check this document.

https://scriptrunner.adaptavist.com/5.0.4/jira/jql-functions.html#_nextsprint

Let me know if you find these JQL functions useful and fulfill your requirement.

Bill Sheboy

Hi @Shirley

Yes, and...to what @Sagar Mahajan suggests:

Would you clarify your planning steps a bit, as that may provide context for the community to offer ideas to help?

You ask about using JQL to find issues for the next sprint to support sprint planning. Sprint planning is normally when teams identify and select work items to meet the sprint goal they create. Is the team pre-selecting work for the next sprint, prior to planning?

Thanks, and kind regards,
Bill

Shirley_q1an3i

Thank you, @Sagar Mahajan for the quick response. I was hoping to have the query pull the next future sprint only and not all future sprints.

@Bill Sheboy, I'll try to provide more context. Hopefully, it's not too much detail!

I am Scrum Master for a cross-functional modified scrum team doing both operational support and new project work on a 2-week sprint cadence. We are using Jira Cloud with an XRay plugin for testing coverage.

Some of our work needs to happen on specific dates or in a specific order so we pre-assign it to specific upcoming sprints. Other work is flexible so we have a fake sprint which a placeholder for all the work that we would like considered for the next sprint if it will fit in for capacity and priority. We don't have a Product Owner so our team manager reviews and prioritizes the team's work a couple days before sprint planning. Some work is assigned before sprint planning because there are specific people who will need to do it. We use both story points and subtask hours in estimating.

As our work requests have been more than our capacity and priorities are frequently changing, I have created dashboards in Jira to help us better prepare for each sprint planning. One dashboard is focused on backlog grooming and looks at issues just in the next future sprint and our placeholder sprint. There are gadgets on the dashboard (each with their own JQL query) for various issue types that show ones that need more backlog grooming to meet our definition of ready (i.e., they are missing information in key fields).

Example JQL query for a Test Execution issue type, checking four required fields. Sprint ID 44 is our placeholder sprint and Sprint ID 313 is our next future sprint which I manually increment up by one and then resave each sprint:

project = SGO AND issuetype in ("Test Execution") AND resolution = Unresolved AND Sprint in (44, 313) AND ("Team[Dropdown]" is EMPTY OR "Backlog Group" is EMPTY OR Component is EMPTY OR originalEstimate is EMPTY) ORDER BY Rank ASC, cf[10033] ASC, priority DESC

Another dashboard that we use leading up to and during sprint planning helps us know the potential commitment looks like so far and what is being assigned to whom. This helps us to proactively make adjustments to balance the workload.

Example JQL query to see what subtask and Test Execution work is assigned and to whom, and what is unassigned. Again, Sprint ID 313 is our next future sprint which I manually increment up by one and then resave each sprint:

project = SGO AND issuetype in (subTaskIssueTypes(), "Test Execution") AND Sprint = 313 ORDER BY Rank, parent ASC, assignee ASC, created DESC

All that brings me back to my initial question: Is there JQL syntax for a specific future sprint, such as the next sprint ID number or next sprint start date?

Bill Sheboy

Thank you for explaining the details, Shirley. There may be an auto-magic approach to help, depending upon a few things:

When you say you "manually increment up by one" the sprint ID in the filter, does that always work? I would expect if there are other teams perhaps that ID values goes up by more than one occasionally. True?
When do you create that new future sprint: during the current sprint or afterwards and just-in-time for planning? (I suspect it is earlier based on what your team manager is doing.)
How many future sprints do you have, in addition to your "placeholder sprint"?
What is the naming convention for your sprints?

I ask these questions as it is possible to edit a filter using the REST API (and a web request), from an automation rule. Thus if you can predictably create a sprint which is for development work (not the placeholder), and can determine it is the "next" one by name, you can update the filters used by the dashboards.