How to create a filter that will refer to Active (current ) Sprint?

Yana N September 29, 2015

I am creating a JIRA filter with below code. It refers  to Sprint number (current Sprint ). I want to have a filter that always will show me list of issues in Active Sprint so that will have no need to create a separate Filter criteria for each new Sprint

 

project = XXX AND issuetype in (Bug, Improvement, Story) AND status in (Open, "In Progress", Reopened) AND Sprint = 65 ORDER BY issuetype DESC, cf[10008] DESC, Rank DESC

9 answers

1 accepted

61 votes
Answer accepted
Nick September 29, 2015

You can do 

Sprint in (openSprints())

openSprints is a collection of all open sprints. Constraining by project etc may be good enough. We have many projects and hence many sprints so we had to create our own currentSprint("XXX") JQL function.

There is also "closedSprints()" and "futureSprints()"

 

I just found a previous answer https://answers.atlassian.com/questions/199842

rob February 7, 2019

Thanks!

Like Hendryck Anthony likes this
Jorge_Pinto July 31, 2019

Thank you! That helped!

Tomasz Kopera August 17, 2019

Nick, unfortunately it does not work for me - what I receive is "An option provided by the function 'openSprints' for the field 'sprint' does not exist." 

 

It happens while using 

Sprint in openSprints()

P.S We are using Jira Cloud

Dave Teale October 28, 2019

i had that error when i used "=" instead of "in". Also in JIRA cloud

Like Özlem Keyder likes this
Sen, Suprakash September 4, 2020

Thanks!

Neetu Verma January 21, 2021

It is a too late to reply but hope this will help someone else. You are missing a set of parenthesis

 

Sprint in (openSprints())
Like IRENE ORR likes this
LilaTournier April 1, 2021

what are you supposed to out in between the () ? the name of the sprint? 
It doesnt work for me 

2 votes
Rodrigo Rosa
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
September 29, 2015

Hello Yana,

Please try the filter described here smile

0 votes
Yasser_Abdallah November 19, 2019
Sprint in openSprints()
Kyle O'Donnell April 30, 2021

yep.

0 votes
Martin_Fabian July 9, 2019

Thank you!

0 votes
Alisha Maistry November 15, 2018

THANK YOU!!!

0 votes
Karol Urbaniak October 10, 2018

Thanks! :)

0 votes
Amit Jain July 6, 2017

Thanks! 

0 votes
anilshekhar June 30, 2017

Thanks. 

0 votes
Yana N October 1, 2015

Thanks a lot!!

Suggest an answer

Log in or Sign up to answer