This is my first time using JIRA so I was testing out the different issues you can create and etc. After creating the issues I went ahead and deleted them to create other new issues in align with the project. The problem I am having is that the issue count is starting off from the last issue (DS10) instead of DS1. The count didnt reset after deletion of the test issues.
Could someone please walk me through resting the count? I saw few post on SQL queseries to reset the count but I am still very confuses on where to plug these queries in. I am not a global admin in JIRA if that changes anything.
You can't do this in the UI, you have to either code something (script) or amend the database directly.SQL is probably the quickest and easiest approach, and it's one of the few relatively safe things to do in a Jira database.
If you're using Jira Cloud, you don't have a means to access the SQL database at all.
However if you are using Jira Server, it might be possible to hack at the database to adjust this as described in the KB How to reset the project counter after moving issues.
We are currently configuring the test project and now it is time to move it to an instant production, we import the system with the deleted incidents, but the account does not start at 1, could you indicate which would be the query to execute in the Micosoft SLQ database? server 2016 to reset the incident account?
It's a column in the "project" table. I can't remember the name off the top of my head, but it is pretty obvious when you look at it (Something like pcounter).
However, do not change it back to 0 without checking the other places the the issue key is used. Specifically, in Jira without any add-ons, you need think about moved issues and all the text fields which might have had an issue key typed into them. If you have any add-ons, you may need to consider their AO tables as well.
at this time, the production site was installed and the idea now is to migrate all the configuration of the test instance, but without the incidents that were created from the tests, how could this process be carried out properly and that does not affect the configuration?
Jira does not have a way to carry configuration from one system to another, so it's either a large cup of coffee and a manual copying, or you can use one of the add-ons that can export and import config.
I'd use Project Configurator to get the configuration across from one system to the other. I am biased on that one - I work with Pepe and the migration and development teams who are working with and on it, so it's the natural choice for me. There are other options of course, and I am particularly fond of Bontron's Configuration manager if you want another opinion.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG