How to set the starting issue number for a project
Platform Notice: Cloud, Server, and Data Center - This article applies equally to all platforms.
When creating a new project, you want to define the number that starts the project's issue ID's. For example, you want to start your project from JIRA-1000 and not JIRA-1.
Resolution for Server, Data Center, and Cloud
You can do it yourself by using the External System Import with a CSV file, the file should be formatted like this:
An example, if you want your project to start the issues from 1001:
key,summary TEST-1000,Dummy summary
The dummy issue can be deleted afterwards. This will set the project issue number count to 1000, so the following issue will have the key TEST-1001.
Resolution for Server, and Data Center
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
The following process will help you modify that starting value
Make backups of your database
- Shutdown Jira (Not applicable for Cloud)
You should not change your counter value to anything lower than the newest created ticket value for your project, so run this query to find out what that value is:
SELECT max(issuenum) FROM jiraissue INNER JOIN project on project.id = jiraissue.project WHERE project.pname = '<YOUR_PROJECT_NAME>';
Make a note of this value.
Set the pcounter value for your project to ONE LESS than your intended start (n-1). You CANNOT set your new starting number to anything lower than the value you got from the query in step 3.
UPDATE project SET pcounter = '<ONE_LESS_THAN_DESIRED_STARTING_VALUE>' WHERE pname = '<YOUR_PROJECT_NAME>';
- Start Jira (Not applicable for Cloud)
Once Jira has started up the moment you create an issue in the project, it should assign to 1 number up from what you set.
Was this helpful?Yes Provide feedback about this article