Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Ticket ID should not start with 1 - new project

Katrin Tiedemann
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 5, 2021

 Hi there!

I want to create a new project in Jira. Is it possible that the ticket ID cannot start with 1 but with any value? For expample, the first ticket ID in jira starts with value 1200?

2 answers

1 vote
Tom Lister
Community Champion
January 5, 2021

Hi @Katrin Tiedemann 

This can be reset in the database

update project
set pcounter = 0
where pkey = 'PROJ';

commit;
admin February 27, 2025

How do you access the database?

 

admin February 27, 2025

Never mind, The easiest way is to set up a CSV file with 2 simple lines to have the issue start at a number you want. 

Column A Row 1 = issue key Row 2 = your project key and the number you want (ABC-628)

Column B Row 1 = Summary Row 2 = Test (or something so you know it is not real)

Then follow these instructions 

https://confluence.atlassian.com/jirakb/how-to-change-the-issue-key-counter-to-a-desired-number-1251410572.html

Map "Issue Key" to "Issue Key"

Map "Summary" to "Summary"

Then import the file. 

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 5, 2021

Not on Cloud.

On server, there's a trick you can use (create the project, stop Jira, change a counter in the database from 1 to 1200, restart it - I usually tell people never to look at the database, but this is one of the very few things that is safe to do), but you have no way to do it on Cloud.

There is a more manual trick for both server and cloud - in your case, create 1,199 issues and then delete them before anyone else uses the project.  (I'd script it with the REST APIs, or run a couple of CSV imports into the project)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events