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 · Accepted solution]

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

[Olivier MAZEN]

Thanks Keri !