how to reset the issue key number?

[rakeshgowd]

how to reset the issue key number

[Nic Brough -Adaptavist-]

Delete all the issues in the project (not just move them, you have to delete), stop Jira, amend the counter field in the project table in the database, restart Jira and re-index it before creating issues in the project you have reset.

[Sreenivasaraju P]

@rakeshgowd ,

It can be done only through DB QUERY. Through UI , you can't do.

https://confluence.atlassian.com/jirakb/how-to-reset-the-project-counter-after-moving-issues-776643590.html

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

[Oussama Brik]

if you have scriptrunner

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.project.Project
import com.atlassian.jira.project.ProjectManager

Project key = ComponentAccessor.getProjectManager().getProjectObjByKey("XRM")
Long value = 0L // Will be set to 0 so the first issue will get the ID of "KEY-1"

ComponentAccessor.getProjectManager().setCurrentCounterForProject(key, value)