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.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Wonderful!
If this answers your question would you please hit the Accept answer next to the vote button.
Much appreciated!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It won't show rolled over issues... :/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
😕
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have another suggestion here: https://community.atlassian.com/t5/Jira-questions/Re-JQL-for-Last-Sprint/qaq-p/2810699/comment-id/1051126#M1051126
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.