How to view a previous sprint that has been closed?

How to view a previous sprint that has been closed?

10 answers

1 accepted

14 votes
Accepted answer


Its true what Whyves said above, basically you can see historical sprint data in most of JIRA Agile report mode. Please refer to - Using Report Mode


I found that and thank you both!

See my note below - the Reports view isn't what we want - the list we want to see is on the Rapidboard.

Can you fix the dead link?

Like 1 person likes this

Please fix that bad link like Filip says...

Dead link.


How can we check previous sprints ?

1. Go to Search on the left (magnifying glass symbol) and then select all issues.

2. In the search bar type Sprint = "<name of sprint>"


Note that the sprint name needs to be exact for this to work. There are other keywords that could be used for this search as well. 

Fix the broken link. :|

the link is still broken....

DavidB I'm New Here Nov 20, 2018

This link shows how to view (and possibly reopen) closed sprints

Reports >> Sprint Report

I didn't need to reopen my sprint; I just could not see my previously closed stories on a nextgen board. 

For this, I went to Reports > Burnup Report > changed to the sprint I wanted to see > scrolled down to see sprint stories and activity.

On the "Sprint Completed" section, it showed me completed stories, but also stories which carried over to the next sprint. Therefore, it wasn't a comprehensive list of everything closed in that sprint, but it worked for what I was trying to see (ie. details of an old spike to create a new story based upon it).

Depends on what you want to see but you can consult some previous sprint data in the Report view of the Rapid Board.

Below query can be used for finding the details of Closed date in Human readable format in MySql database

select ID,Name, FROM_UNIXTIME(Start_DATE/1000),FROM_UNIXTIME(COMPLETE_DATE/1000) as completed_dates from AO_60DB71_SPRINT where  FROM_UNIXTIME(COMPLETE_DATE/1000) >= '2015-06-01' and closed = 1;

Actually in Sprint table date's are stored in Big Int format(20 digits may be) so need to change it using FROM_UNIXTIME

I've seen the dropdown list on a Rapidboard that shows past (closed) sprints, but cannot figure out how it got there.  The user was able to use the dropdown and see a list of closed sprints she could view without using the reports.

The only thing we can see on past sprints in the Reports view is the data from the reports, not a Rapidboard.  

Is there a way to show the dropdown on the Rapidboard in the location noted in the attached image?


Hi Jolie Roy .


You can try below query may helfull to you


project="Mobile Apps" and sprint in closedSprints() and Sprint='Mob Sprint 35' and status=closed ORDER BY updatedDate



project="Mobile Apps" and sprint in closedSprints() and status=closed ORDER BY updatedDate

0 votes

Left Report > Sprint report

Use query statement in advanced search feature

Sprint = "<name of sprint>"

Are you telling me that there is no direct way to see a list of closed sprints, click and get at least the list of stories????

0 votes
bavani.s I'm New Here Nov 26, 2018

Very simple.

Select the respective project from drop-down list, 

From left side bar, Select 'Issues and filters' -> follows 'All Issues' , there you can see from 'sprint 1'

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,016 views 4 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you