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

[Yana N]

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

[Nick · Accepted solution]

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]

Thanks!

[Jorge_Pinto]

Thank you! That helped!

[Tomasz Kopera]

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]

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

[Sen, Suprakash]

Thanks!

[Neetu Verma]

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

Sprint in (openSprints())

[LilaTournier]

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

[Rodrigo Rosa]

Hello Yana,

Please try the filter described here 

[Yasser_Abdallah]

Sprint in openSprints()

[Kyle O'Donnell]

yep.

[Martin_Fabian]

Thank you!

[Alisha Maistry]

THANK YOU!!!

[Karol Urbaniak]

Thanks! :)

[Amit Jain]

Thanks! 

[anilshekhar]

Thanks. 

[Yana N]

Thanks a lot!!