How do you Jquery tickets that are in current sprint and 2 future sprints ahead?

Question

I am planning to create a dashboard that will automatically have the filter for current and 2 future sprints for a specific squad.

I know that the current sprint has a query of ()Opensprint but I do not know how to determine the query for the 2 future sprints.

Trudy P Claspill · Answer

Hello @Sherwin Soriano

This does not appear to be possible.

Jira does not provide a native method to do this in JQL.

ScriptRunner has a function to get issues from the "next" sprint when you specify a specific board. But that is only one next sprint, not two.

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions#nextsprint

I used Google to search for an answer to your question with this as the search:

jira cloud jql for a specific number of future sprints

I found a number of community posts where people asked the same question, and there were no JQL solutions mentioned other than the ScriptRunner option for nextSprint().

Sherwin Soriano_cnhh8m · Answer

Thank you @Trudy P Claspill but I wanted to know if I can limit the future sprints in the query, like only the succeeding 2 future sprints from the current sprint, is this possible?

Trudy P Claspill · Answer

Hello @Sherwin Soriano

Refer to the futureSprints() function on this page:

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