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!
Great! Simple and effective!
Wonderful!
If this answers your question would you please hit the Accept answer next to the vote button.
Much appreciated!
It won't show rolled over issues...
I have another suggestion here: https://community.atlassian.com/t5/Jira-questions/Re-JQL-for-Last-Sprint/qaq-p/2810699/comment-id/1051126#M1051126
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).
It looks like you're new here. Sign in or register to get started.