Ticket Number Format |
The default ticket number format for all tickets, but can be overridden for a single department in the department settings. Can contain alphanumeric characters and special characters -_.+!*, . The following variables are available:
-
%S - A sequential number, tied to the actual ticket ID (starts from 1). If you prefer that the sequential ID start from a higher value, please manually execute the following SQL replacing '3000' with your starting ID:
alter table ticket auto_increment 3000;
AUTO_INCREMENT does not accept lower values once the above query is executed. You will need to delete all the tickets from the helpdesk and again run the above query with a lower value to meet your requirement.
- %N - A random number, use brackets {?} with a number after to define a sequence of that many random numbers.
- %L - A random letter, use brackets {?} with a number after to define a sequence of that many random letters.
- The following PHP date characters (Y, y, m, d, j, g, G, h, H, i, s) prefixed with a %, for example %Y for a 4 digit representation of the current year.
The default value is %N{7}, giving ticket numbers such as 4783783. Other possible examples are listed below:
- %L{3}-%N{4} - ABC-1234
- %Y-%S - 2016-1
- SALES-%N{5} - SALES-12345
- ACME-%y-%S - ACME-16-1
It is important that the ticket number format generates a unique value for each ticket, and must have some element of randomness or uniqueness in it.
|