How Can I Change The Numbering of My Support Tickets?
By default, when you install Clientexec, your ticket numbering will start at 1000. If you want to change this number you have a
couple of options.
If this is a fresh install or you currently have 0 tickets, you can go to Settings > Support > General then for the input Support Ticket Start Number you can enter the number you want to use.
If you already have existing tickets then option 1 will not work for you. What you can do is adjust this setting with an SQL query. To do this go to Settings > Utilities > SQL Tool and using the following query:
Change the newStartingNumber to the number you want to use.
IMPORTANT: This number must be HIGHER then your current highest ticket number. So if your last ticket number was 1020 for example then you will need to use a number higher then that like so:
Using that query, your next ticket generated would be Ticket number 5000.
couple of options.
Option 1:
If this is a fresh install or you currently have 0 tickets, you can go to Settings > Support > General then for the input Support Ticket Start Number you can enter the number you want to use.
Option 2.
If you already have existing tickets then option 1 will not work for you. What you can do is adjust this setting with an SQL query. To do this go to Settings > Utilities > SQL Tool and using the following query:
ALTER TABLE troubleticket AUTO_INCREMENT = newStartingNumberChange the newStartingNumber to the number you want to use.
IMPORTANT: This number must be HIGHER then your current highest ticket number. So if your last ticket number was 1020 for example then you will need to use a number higher then that like so:
ALTER TABLE troubleticket AUTO_INCREMENT = 5000Using that query, your next ticket generated would be Ticket number 5000.
Updated on: 02/08/2024
Thank you!