It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to view a previous sprint that has been closed?

How to view a previous sprint that has been closed?

11 answers

1 accepted

21 votes
Answer accepted

Winn,

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

Cheers,

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...

Like 1 person likes this

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

https://confluence.atlassian.com/jirasoftwareserver/reopening-a-sprint-938845456.html

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).

Like 2 people like this

How about a simple button that lets me see the previous sprints? Who exactly at Atlassian thinks this nonsense is an acceptable way to navigate something as simple as "what tickets were in the last sprint?"

Like 4 people like this


This is ridiculous 

I don't understand how this is even remotely acceptable as a method for finding something as simple as "show me the last sprint." I'm in my daily stand-up the day after we closed a sprint, trying to find the number of the ticket I worked yesterday, and ten minutes of searching here and there and I still can't find it. The entire Jira interface needs a complete re-think.

Like 3 people like this

I  found the simplest solution is to use versions, create one version per sprint.  Then it is a simple matter to view all previous sprints from the Releases page. 

Hi Jolie Roy .

 

You can try below query may helfull to you

Ex:

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

 

OR

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

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?

 

Left Report > Sprint report

Use query statement in advanced search feature

Sprint = "<name of sprint>"

 

https://confluence.atlassian.com/jirakb/view-stories-in-a-closed-sprint-779159181.html

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????

Very simple. Select the respective project from drop-down list, From left side bar, Select 'Issues and filters' -> follows to the option, 'All Issues' ,Click on it, there you can view from 'sprint 1 to Nth', if you want to filter previous sprint precisely, use this query:

project = project name ORDER BY Sprint DESC

https://companyname.atlassian.net/projects/LL/issues/LL-1?filter=allissues

https://companyname.atlassian.net/browse/LL-351?jql=project%20%3D%20LL%20ORDER%20BY%20Sprint%20DESC

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published Apr 09, 2019 in Portfolio for Jira

Portfolio for Jira 3.0 is here!

The wait is over... Portfolio for Jira Server and Data Center 3.0 is now officially here! Platform releases offer Atlassian an opportunity to shift our strategy, make bold predictions about t...

1,435 views 14 26
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