Strange TicketID number

[gawkla]

Hello Team. Maybe you can help me.
My SystemID is 15
But my automatic generated ticketID is (for example) 151506594 where:
15 - is system ID
150 - ???
6594 - is auto increment part

How to remove this ??? strange 150 part?
I have no idea. I tried to search into all config but this is nothing visible.

I am pretty sure that this part is comming with one of updates, probably from v5 to v6. Any ideas how to remove this?

[wurzel]

Hi,

which number generator is configured?

Flo

[gawkla]

"AutoIncrement" increments the ticket number, the SystemID and the counter are used with SystemID.counter format (e.g. 1010138, 1010139).
So, it should be: 156594.
Maybe counter starting position is set to 150000.
But how to check this - it is stored somewhere in database but I can't find it.

Other question, can system ID be empty? Or not include it into autoincremet?

For me ideal format should be:
YYYYMMDDxxx (for example: 20201128xxx where xxx is incremented every day starting from 001). I do not expect more than 999 tickets per day. Even in such case, it can be saved as xxxx (1000, 1001, 1002). This counter will be unique but not so long.
Currently format with date is very long because simply add date part before autoincrement part: 20201128151506645

[crythias]

What will happen to your ticket system when you hit 9999 tickets +1?

[gawkla]

nothing strange. Should be 10000. Next should be 10001.

[crythias]

would you expect your ticket number to expand length or occupy the 0?

[gawkla]

Because my counter is groving slow it would be better to expand length (9999 -> 10000). But it is less important. More important is:
1) is it possible to remove systemID from ticket number?
2) how "lower" current ticket counter from 1506599 to, for example: 06599

In my case this will remove 4-5 digits from current format 15150xxxx. Because I have to write down these numbers sometimes on stickers it is worth to optimize. The best would be have format like YYYYMMDDxx where xx is incremented every day starting from 01 but this is probably not so easy to implement.

[root]

Hi,

You can implement your own counter. Had this done for a customer with 6 character ticket number containing letter A-Z and number 0-9 like A3H4BG. That's no rocket science. It's even harder to manage existing tickets and their follow-ups. Usually the won't be detected until youn write a custom follow-up detection.

- Roy