Start a conversation

How to change the ticket ID type to show a sequence of numbers?

We're actively rewriting our user guide, so check back for improved coverage.

For changing the ticket ID's to Sequential ticket ID's beginning from some particular number, you need to perform the below mentioned instructions:

  • Navigate to Admin CP > Settings > Tickets, and change 'Ticket ID Type' to Sequential.

  • You need to execute the following query on the helpdesk database to start ticket ID, for example from 3000

mysql> alter table swtickets auto_increment 3000;

Note: AUTO_INCREMENT does not accept lower values once the above query is exectued. You will need to delete all the tickets from the helpdesk (including the tickets in the trash folder too) and again run the above query with a lower value to meet your requirement.

Choose files or drag and drop files
Was this article helpful?
  1. Sukhpreet Anand

  2. Posted
  3. Updated