When I installed osTicket, I made my ticket numbers using this format: STI-######, counting up from STI-000001 and so on. When we search for a ticket in the ticket list, simply typing the number doesn't find the ticket. EX: STI-002878 cannot be found by searching for "2878". Instead, I have to enter "STI-002878". I would like to manually update the database to remove the leading "STI-00" and use a simple, sequential number. I can change my ticket format in settings, but would like to go back and update existing tickets to the same format.

Does anyone see an issue with updating the DB table directly? It seems like tickets have an internal ID and "my" ticket number is simply an attribute of the tickets.

Any insight is appreciated!

Thanks. Jerry