Any way to set or seed the starting Issue number

I'm testing/evaluating the Bamboo / JIRA / GreenHopper combo. We have been testing Bamboo independently in production, so it contains records with pointers to JIRA Issues. But the JIRA production system does not -- and cannot right now -- get the Bamboo plugin.

I have a test instance of JIRA / GreenHopper. I can create a project with initials matching the ones Bamboo knows about. But the Issue numbers start at 1. To get a matching number I will have to pump in a thousand bogus JIRA Issues.

I was hoping there was a way to tell my new project to start with number 995, for example.

4 answers

1 accepted

0 vote

You can stop Jira, set the counter for the project and restart it. Uses SQL, and I really do mean it about stopping Jira, so that might not be suitable.

The other trick I use is exactly what you've suggested - import a CSV with the right number of lines, and then delete them all later. (Spreadsheets make it very easy to generate the CSV)

Hi, I want to assist the user by the next issue number (based on the current count of project issues), while he is creating an issue. this needs to create a custom filed or change the issue number field so that it sets the value based on the query result or project.issuecount +1; I greatly appreciate if you explain where and how I can write this query and test for a custom field. I am new to jira. based on the highest available issue number in the project I am trying to get the count of all issues of a project

You can't. You cannot know what the number is going to be until the user clicks the "save" button. Simple scenario - the counter is at say 576. So you start creating an issue. Your logic would say "the number will be 577". You don't type as fast as I do, and I click create before you. I get 577, and you get 578. Also, I'd question the requirement - what actual use is the number to the user before they create the issue? Second, for "trying to get a count of all issues", the issue keys are of no use. The instant someone moves or deletes an issue from the project, the "highest issue key" is wrong. To find out how many issues there are in a project, you need to run a filter for "all issues in project" and look at the number it returns.

Thank you for your reply. I just learnt how to check the answers (from a folder in my inbox)

go to your JIRA DB and navigate to the project table and there is a field called "pcounter" . set this field value to what you need . as your example if you want to tell your project to start with 995 then set this filed value to 994.

then you will get what you needed.

Remember to STOP Jira before doing that, or you may find it does some odd things.

Actually, that answer is exactly what I said already.

Hi Nic you only mentioned is "You can stop Jira, set the counter for the project and restart it", when i see this i had no idea about the counter you mentioned in your answer.so thats why i put this answer.. thnks..

0 vote
Renjith Pillai Community Champion Oct 12, 2012

Use the data generator plugin in JIRA and pump in 994 issues. And later delete them.

https://marketplace.atlassian.com/plugins/com.atlassian.jira.plugins.jira-data-generator

Any solution available for Cloud versión? i don't have access to de DB

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,264 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot