Jira 프로젝트 이슈 키 카운터 설정

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

 

특정 프로젝트 카운터를 초기화 하고 싶다면,

  • 해당 프로젝트의 이슈를 모두 삭제

  • DB에서 아래의 1번 수행

 

To reset the project count you need to execute the following two steps (please substitute A in the below queries for your project key):

  1.     Reset the pcounter field from project table

    UPDATE project SET pcounter=0 WHERE pkey='A';
  2. Remove the rows referencing the old issue keys from moved_issue_key

    DELETE FROM moved_issue_key WHERE old_issue_key like 'A-%';

 After the above steps you should be capable to create issues starting from the number that was set in the pcounter field.