Completed sprints not displaying in query results

When I pull a query of user stories, the value under 'Sprint' is showing up as 'None' rather than naming the completed sprint name.

Is this a bug, or a setting that needs to be adjusted in the setup?

7 answers

0 votes
Andy Nguyen Atlassian Team Mar 12, 2014

Hi Katrina,

The Sprint column in Issue Navigator will only display the sprint names of those sprints visible in Plan mode. In other words, only future or open (active) sprints are available while closed sprints are not. The purpose of this is to prevent the case in which an issue was completed in a sprint but then reopened and added to another sprint (the issue appears in multiple sprints).

In order to see the issues in closed sprints, you may want to use the following queries:

  • Sprint in closedSprints() Or
  • Sprint in (<sprint_name>)



I'm not having trouble seeing the logged issues, just with finding a way to have the Sprint value populated in the query results when running a search under the 'Issues' section of our site.

Good morning Andy,

This seems to be a change with the latest patch that we deployed and has had a negative impact on our ability to report (via exports of JIRA data) on historical work. The query Katrina mentions includes the "Sprint" column in the results, but all closed Sprints return a value of "None" where they were populated with the correct Sprint number in previous runs of the same query. I understand this change was the decided on approach to address your concern where the issue appears in multiple sprints, but we need a way to pull the correct "Sprint" into the data export for our reporting purposes. I can still run the "Sprint Report" under ->Agile->Report, so I assume there is still a column or link in the DB to get this for an export.

Please help as this report is shared with our customers to communicate work that we are doing for them. If the above is not clear or you need additional details, maybe we can setup a time to chat.



This thread seems to have dead-ended. Is Atlassian planning on doing anything with regard to this problem?



Our exports are showing the correct Sprint value again for closed sprints, so I assume the issue was addressed.  Thanks!

What version are you running.  It shows "None" for items in completed sprints for me.  Thanks.

We're running v6.2.  Does anyone know when the behavior was changed to be as Andy described on March 12?

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

655 views 4 15
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot