Is there any way to filter by the last 3 closed sprints?

[Vic Kharitonov]

Is there any way to filter by the last 3 closed sprints using only JQL? Not considering power querry as a solution. Or maybe there are plans to introduce such function that will allow  to see the last spints.

Thank you in advance.   

[Brittany Wispell · Accepted solution]

Hey @Vic Kharitonov

You could try using the below in JQL. If you are doing 2 week sprints you can update the resolved date to be specific to the # of weeks for the 3 closed sprints. 

sprint in closedSprints() and resolved >= -8w

 Hope this helps. Let me know if you have any other questions!

[Rob van den Belt]

Great! Simple and effective!

[Brittany Wispell]

Wonderful! 

If this answers your question would you please hit the Accept answer next to the vote button.

Much appreciated! 

[Fernando Trindade]

It won't show rolled over issues... :/

[Andy_Swift]

Unless I'm getting it wrong. 

It also only works at the beginning of a new sprint...
It starts to bring in issues from Sprint -4 

As the open sprint moves into its second week.

😕 

[Nicolas Gondard]

Not sure if it's appropriate, but may I suggest ScriptRunner for Jira Cloud ? It has a previousScript function that seems to partly do the trick (for only the last sprint).

[Paulo Meirelles]

I have another suggestion here: https://community.atlassian.com/t5/Jira-questions/Re-JQL-for-Last-Sprint/qaq-p/2810699/comment-id/1051126#M1051126