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

How can JQL return current sprint and future sprints?

Bud Herz_4dzuwt

Previous person wrote this JQL for a dashboard to display work from future sprints and the backlog. Note that it's hardcoded so the sprint numbers need to be updated every sprint -

"Team[Team]" = <team ID> AND project = FS AND sprint IN (348, 349, 350, 356, empty) AND type = Story AND status IN ("To do", "In Progress", "Dev Blocked", "In ST", "ST Blocked", "UAT Ready", "Code Review", "Ready ST") ORDER BY created DESC

I've been looking for something in JQL that might allow me to get away from that. Could I possibly use "AND Sprint IN openSprints()" then some sort of future sprint variable like "opensprint +1" ?

I know we can subtract dates. For example, I also have Global Automations to report the bugs opened and closed in the previous 24 hours using "AFTER -1d"

@Bill Sheboy you seem to always have great ideas. Any thoughts? TIA

Accepted answers

Trudy P Claspill

Hello @Bud Herz

Jira does not natively support providing parameter input to the functions closedSprints(), openSprints(), or futureSprints(). Nor does it natively have additional capabilities for selecting issues based on associated sprints other than explicitly specifying the sprints.

Using sprint IN openSprints() will give you issues in all currently open/Active sprints where the issue match the other criteria in your JQL.

Using sprint IN futureSprints() will give you issues in all currently planned but not yet started sprints where the issue match the other criteria in your JQL.

Do you typically have only one planned sprint or do you have multiple planned sprints?

If you have multiples are you trying to get issues for just the "next" planned sprint? And if so, what information available for that sprint tells you it is "next" vs. any of the other planned sprints?

Do you have any third party apps that extend the JQL capabilities, like ScriptRunner? Are you open to considering getting an app if it would enable you to meet your requirement?

All comments

Trudy P Claspill

Hello @Bud Herz

Using sprint IN openSprints() will give you issues in all currently open/Active sprints where the issue match the other criteria in your JQL.

Using sprint IN futureSprints() will give you issues in all currently planned but not yet started sprints where the issue match the other criteria in your JQL.

Do you typically have only one planned sprint or do you have multiple planned sprints?

Do you have any third party apps that extend the JQL capabilities, like ScriptRunner? Are you open to considering getting an app if it would enable you to meet your requirement?

Bill Sheboy

Hi @Bud Herz

Yes, and...to the suggestions from @Trudy P Claspill

When you want to include all future sprints, the JQL function Trudy notes will help.

When you want a subset of them based on specific criteria, you could use an automation rule to dynamically update the saved filter used by the dashboard, calling the REST API endpoint to identify the relevant sprints and another endpoint to update the filter...both using the Send Web Request action.

Kind regards,
Bill

Bud Herz_4dzuwt

Bill I see you had suggested the REST API for a similar question here:
https://community.atlassian.com/forums/Jira-questions/JQL-for-next-sprint/qaq-p/1821910

My challenge differs from that one I think because I hope to be more versatile by not using the sprint names. (Which is mentioned in that Q&A.)

Bud Herz_4dzuwt

I hadn't refreshed to see these replies. Thank you @Trudy P Claspill and @Bill Sheboy !

Bud Herz_4dzuwt

@Trudy P Claspill - I believe we have ScriptRunner. I know we can use the - IN openSprints() since I use it frequently.

I will try out the sprint IN futureSprints() to see if I can get what I need.

To answer your questions:
We used to have only one sprint (the active sprint). We evolved to prepare a single future sprint maybe a year ago. Currently I am pushing to have at least three future sprints so we can forecast our future work better and leverage the Timeline view and Plan view.

Bill Sheboy

Looks like the JQL function worked for you, but to close the loop...

You wouldn't need the sprint names, only the board name to find the sprints...and then filter from there. The REST API approach helps when there are no issues assigned to the future sprints yet, AND one still needs the filter updated to specifically reflect the sprints.

Hannes Obweger - JXL for Jira

Hi @Bud Herz

just to put it out there in case it is useful:

If you're open to solutions from the Atlassian Marketplace, I believe that you're use case might be easy to solve using the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called smart columns that aren’t natively available, including the sprint status. The sprint status captures the status of the latest sprint that an issue is part of.

This is how it looks in action:

As you can see above, you can easily sort and filter by the sprint status, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud