Newbie question, possibly, but please could you explain the difference between the Ticket ID (used in querystrings and apparently set to auto-increment) and the Ticket Number (apparently a date-based GUID).
What happens to these numbers when tickets are merged?
Many thanks.
Solved: Ticket ID vs Ticket Number
Moderator: crythias
-
- Znuny expert
- Posts: 167
- Joined: 26 Jan 2011, 13:23
- Znuny Version: 3.0.7
- Real Name: Rod Behr
- Company: Impact
- Location: London, United Kingdom
- Contact:
Solved: Ticket ID vs Ticket Number
Last edited by RBehr on 14 Jul 2011, 11:55, edited 1 time in total.
Rod Behr
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Ticket ID vs Ticket Number
A ticketID is the autoincrement index number for database purposes.
A Ticket Number is the label that includes a unique identifier for ticket and systemID.
What happens to the numbers when the tickets are merged? eh... what answer to the question will provide the information you need for your next question?
A Ticket Number is the label that includes a unique identifier for ticket and systemID.
What happens to the numbers when the tickets are merged? eh... what answer to the question will provide the information you need for your next question?
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
-
- Znuny expert
- Posts: 167
- Joined: 26 Jan 2011, 13:23
- Znuny Version: 3.0.7
- Real Name: Rod Behr
- Company: Impact
- Location: London, United Kingdom
- Contact:
Re: Ticket ID vs Ticket Number
Clever...
A customer has an e-mail with a link to the ticket, using the TicketID in the querystring. Will the link still work?
A customer has an e-mail with a link to the ticket, using the TicketID in the querystring. Will the link still work?
Rod Behr
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3
-
- Znuny expert
- Posts: 167
- Joined: 26 Jan 2011, 13:23
- Znuny Version: 3.0.7
- Real Name: Rod Behr
- Company: Impact
- Location: London, United Kingdom
- Contact:
Re: Ticket ID vs Ticket Number
And, incidentally, why have two? Our customers dislike the lengthier one and would prefer to use the TicketID, but is there any danger in this?
Rod Behr
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Ticket ID vs Ticket Number
Two because a label is more descriptive than a digit. It's also more likely to be unique, especially if it has a common format/length. That's especially important when considering using the same ticket number between two different OTRS implementations (why system ID is important).
I don't know that a link to a ticketId that no longer exists (because of merge) will work. At best, it should, and point to the destination-merge.
(Here again ticket number vs ticket id is important: I might be able to delete the link to the index, but the label stays with what happened to the ticket while separate.)
I don't know that a link to a ticketId that no longer exists (because of merge) will work. At best, it should, and point to the destination-merge.
(Here again ticket number vs ticket id is important: I might be able to delete the link to the index, but the label stays with what happened to the ticket while separate.)
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
-
- Znuny expert
- Posts: 167
- Joined: 26 Jan 2011, 13:23
- Znuny Version: 3.0.7
- Real Name: Rod Behr
- Company: Impact
- Location: London, United Kingdom
- Contact:
Re: Ticket ID vs Ticket Number
Thank you. That is very clear. I will point our users at the Ticket Number for identification purposes rather than the Ticket ID.
Rod Behr
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3
Software Design Manager and Database Analyst | Impact Audiovisual | London
Installation: OTRS 3.0.7, Apache 2, Strawberry Perl 5 on Ubuntu 10.04.3 Server with separate MySQL Server, also on Ubuntu 10.04.3