Get product advice from experts

Ask a question →

Join a community group

Find a group →

Advance your career with learning paths

Take a free class →

Earn badges and rewards

Connect and share ideas at events

See the calendar →

Community
Products
Jira
Questions
Is there any way to filter by the last 3 closed sprints?

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

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.

2 answers

1 accepted

12 votes

Answer accepted

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.

Comment

Great! Simple and effective!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

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.

Comment

Like

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.

Comment

Like • like this

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.

Comment

Like • Alexander Bondarev likes this

Reply

0 votes

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.

Comment

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS

Community showcase