can i change Jirra issuekey by SQL script?

Olivier MAZEN

Hello there,

 

I have initialize a production environement by import a xml backup file.

 

 

There is something i didn"t planed on is now on my production when i create a new issue, the issukey is set to 156 for example and not to 1.

 

 

It is possible to re-order the actual issuenum to set the issye key to 1 , 2  3 etc.

and set the sequense to the number of issue actually created on my production environement?

 

i want to do this:

issuekey-156 ==> issukey-1

issuekey-157 ==> issukey-2 

issuekey-158 ==> issukey-3

[...]

Create new issue ==> issue key-4

 

I have found out how to reset the number sequence with this post:

https://community.atlassian.com/t5/Jira-questions/Is-it-possible-to-reset-the-issue-key-number/qaq-p/440609

 

but i didn't how i can reorder the issunum.

 

Do you have any solution? or it is a SQL script to wrote ?

 

king regards,

 

Olivier

 

Keri

Hi Olivier, 

 

If you want to reset the issue keys, you can try moving all of the existing issues to a temporary project, then running the queries in https://confluence.atlassian.com/jirakb/how-to-reset-the-project-counter-after-moving-issues-776643590.html again. 

Once this has been completed, move the issues back to the project. 

With all moves like this, we always recommend that you test it in a staging environment first if possible!

 

Cheers, 

Keri