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?

12 answers

1 accepted

30 votes
Answer accepted
vkharisma Atlassian Team Sep 22, 2013

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.

Like Gabriel Pumple likes this

Can you fix the dead link?

Like Ulrich Kuhnhardt likes this

Please fix that bad link like Filip says...

Like Igor Krstic 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. 

Like # people like this

Fix the broken link. :|

the link is still broken....

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

Reports >> Sprint Report

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

Like Stefan Surkamp likes this

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 # 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 # people like this

Works for me, thanks for the comments

broken link!!!!

I agree with Trebor. This is total nonsense. Just have a button that takes us to a list of previous sprints. Just bad UX. 

I mean how the hell do I know the exact name of a sprint, especially if it was 12 months ago. 

Give me break...


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

Like Scott Price likes this

I have put a short video tutorial how to see closed sprints. It works with newest Jira version - hope it helps: https://youtu.be/YH6WhyZQQfo

Kwieting I'm New Here Sep 12, 2019

@Anatoly SpektorThis does not seem to work with NextGen Projects.  I can see the list of sprints in the Velocity Report, but its just a list, not links so I can not drill down.

If you need to make a video for such a basic thing, it means this app is a cra...

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

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

You can access using query in filter:

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
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

269 views 1 2
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you