Can I rename a completed sprint?

An old, dummy sprint I created actually uses a naming convention that I need to use going forward. So, I now have two sprints with the exact same name; one real and one for test purposes. This is somewhat confusing for my engineers.

I know how to rename an active sprint, but is there a way to rename a sprint that was created and is now completed?

Many thanks in advance,


6 answers

1 accepted

Just had the same problem and I don't have access to query the database directly.

So I've found an alternative that seems even better, since you don't have to restart/reindex Jira. There's no back-end validation/restriction for renaming a completed sprint, so I just called the service that makes the change:

http[s]://{jira base URL}/jira/rest/greenhopper/1.0/sprint/{sprint id}

{sprint id} value can be retrieved on the report section, by inspecting (browser) the sprint name, and searching by the "data-sprint-id" attribute value.

The request must use the PUT method, and must contain some specific headers. I recommend you rename an open sprint and inspect the request done (using Network from Chrome/FF Firebug, for example), so you can replicate those headers.

A sample raw body (JSON format) for the request:

{"name":"My new name for sprint","startDate":"03/Feb/14 3:31 PM","endDate":"03/Feb/14 4:58 PM"}

Hope it helps.

Edit: Greenhopper 6.1

It worked:

NEW_SPRINT_NAME="my new sprint name"
NEW_START_DATE="06/Apr/14 8:00 PM"
NEW_END_DATE="14/Apr/14 1:18 PM"

curl -u$USERNAME:$PASSWORD '$URL/rest/greenhopper/1.0/sprint/$SPRINTID' -X PUT -H 'Accept: application/json, text/javascript, */*; q=0.01' -H 'Accept-Language: pl,en-us;q=0.7,en;q=0.3' -H 'Connection: keep-alive' -H 'Content-Type: application/json; charset=UTF-8' --data '{"name":"$NEW_SPRINT_NAME","startDate":"$NEW_START_DATE","endDate":"$NEW_END_DATE"}'

Remember that user must be in Administrator role for this project.

Tested with Jira Agile 6.3.12

Fyi, does not work anymore with JIRA Agile 6.7.12.

Also not working on JIRA Agile v6.4.5 - API returns error message:

{"errorMessages":["Cannot update closed sprint"],"errors":{}}

Tracked by

Is this possible somehow in JIRA OnDemand?

1 vote
Yilin Mo Atlassian Team May 28, 2013

It is possible to do it via the database query:

1. Locate the sprint that you want to rename:

select * from "AO_60DB71_SPRINT" where "CLOSED" = 't';
2.  then update the related spirnt name in the name column value.
3.  You need to restart JIRA to make the modification available.

Many thanks for this. It's unfortunate that this can only be changed at the database level, but I'll speak to my JIRA adminstrator and see if he can perform this change.

How about for those of us who have Sprints from the very beginning of the Rapidboards? Isn't there going to be a problem with how the refs used to be by name (now by ID) or something?

I am hesitant to try such manual overrides directly in DB without understanding the full implications.

Thank you,


Reopen the sprint in Sprint Report then you can rename it on the Backlog as normal.

Yes, that solved the problem.

this solution is avaible in some versions 

In newer versions of JIRA (I'm on 7.6.3), you can do this a little more directly:

  1. Go to the Sprint Report
  2. Select the sprint you want to rename
  3. Click the ellipses button (...)
  4. Select Edit Sprint
  5. Change the name to whatever you'd like, and click Save
Ami Weinberg I'm New Here Monday

Thank you!!

You are likely to also have to reindex your Jira instance after touching the database manually like that.

does this work on all versions?

I have v6.0.8.

Thanks, Lynn

Suggest an answer

Log in or Join to answer
Community showcase
Bridget Sauer
Published Mar 05, 2018 in Jira Software

Jack Graves: Real Ale enthusiast with a knack for Jira Software implementation

@Jack Graves first caught our eye with his incredible breakdown of what, in his opinion, can make or break a Jira software implementation. (Read his thoughts on this thread)! In this followup Sh...

72,291 views 4 6
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