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?
Strange TicketID number
Moderator: crythias
Re: Strange TicketID number
Hi,
which number generator is configured?
Flo
which number generator is configured?
Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
Re: Strange TicketID number
"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
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
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Strange TicketID number
What will happen to your ticket system when you hit 9999 tickets +1?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: Strange TicketID number
nothing strange. Should be 10000. Next should be 10001.
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Strange TicketID number
would you expect your ticket number to expand length or occupy the 0?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: Strange TicketID number
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.
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.
-
- Administrator
- Posts: 3991
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Strange TicketID number
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
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
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?