How to view stories in a closed sprint

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Issue Summary

Sometimes, there is a need to find stories, issues, bugs, etc that were included in a sprint that has already been completed. Jira Software does not have a quick way to do this from its own UI.

Resolution

  • First, you will need to identify the name of the closed Sprint from which you need to look for stories. If you don't remember the name of this Sprint, you can use either method:
    • Method 1:
      • Go to the Jira Software Project from which the Sprint was created
      • Go to the Project Report Page and select Sprint Report 
      • From the Sprint Report page, click on the Sprint dropdown: you will see the list of all the closed sprints that were created from this project:
    • Method 2:
      • Log into the Jira Database
      • Run the following SQL query to find the list of all the Sprints that have been closed. (warning) Note that this SQL query was written and test for a PostgreSQL database, and will need to be adjusted for other types of Databases:

        select * from "AO_60DB71_SPRINT" where "CLOSED" = true;
  • Once you know the name of the Sprint, use the the advanced search feature in Jira's Issue Navigator (from the page Issues > Search for Issues), and construct a JQL statement to find the issues that belong to a certain sprint:

    Sprint = "<name of sprint>"
    

    (warning) For more information on searching for issues using JQL, check out Advanced Searching.



Last modified on Nov 3, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.