Solved: Ticket ID vs Ticket Number

Moderator: crythias

Locked
RBehr
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

Post by RBehr »

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.
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
crythias
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

Post by crythias »

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?
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
RBehr
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

Post by RBehr »

Clever...

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
RBehr
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

Post by RBehr »

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
crythias
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

Post by crythias »

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.)
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
RBehr
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

Post by RBehr »

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
Locked