JQL look for the three following active sprints beginning of today while there are more than three f

[Luc Dhondt]

project = "DOSCONFIG" AND status IN (Backlog,"In uitvoering") AND sprint IN (170,168,169) ORDER BY cf[10020] DESC, created DESC

In this code we want to change the nummers of the sprints 170,168,169 into the three first sprints that are coming in the future.

Although there are more futures prints planned.

How is it possible to do this?

Verry thank you for your time and help

[Bill Sheboy · Accepted solution]

Hi @Luc Dhondt -- Welcome to the Atlassian Community!

The built-in JQL features do not support that ability. 

JQL can only find the issues in the current open/in progress sprints, future sprints, and closed sprints.  There is no way to search "show me the next three sprints".

Your possible work-arounds are:

• You could manually update your query
• You could use an automation rule to update a saved filter.  This would require calling a REST API function to gather all sprints, identify the future ones of interest, and then call another REST API function to update the saved filter.  The assumption to make this work is the sprints have a standard naming practice or that they have a stable, fixed duration and starting point.
• You could investigate marketplace addons to enhance the features of JQL for such queries

Kind regards,
Bill

[Luc Dhondt]

Thank you Bill for your reaction !

[Luc Dhondt]

.