Start a conversation

Changing the Ticket ID Type to Show a Sequence of Numbers

Overview

This article provides instruction on how to change the ticket ID type to show a sequence of numbers.

Process

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

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

    001.png

  2. You need to execute the following query on the helpdesk database to start ticket ID, for example, from 3000:
    ALTER TABLE swtickets AUTO_INCREMENT 3000;

Note: AUTO_INCREMENT does not accept lower values once the above query is executed. 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.

001.png

  1. 5 KB
  2. View
  3. Download
Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Priyanka Bhotika

  2. Posted
  3. Updated

Comments