[rt-users] Ticket numbering

[Scott Frisbie]

The limiting factor on being able to alter this field ( at least in MySQL) is 
that the ticket id number is an int(11) autoincrement field in the DB. You 
would need to make the change there to provide tickets like you want. I don't 
see any of the standard 'Types' for the field which would do the trick, but 
there may be some  ways to add custom field Types to MySQL.  The other option 
is to come up with a custom field and write a scrip to convert the 'normal' 
ticket id to your custom ticket id and insert it into the custom field. This 
would then be possible to apply to a single queue.
Scott


On Thursday 12 January 2006 09:38, Phanoko wrote:
> rt-users at lists.bestpractical.com
>Does anyone know of a way to change the numbering?  We
>would like to have the numbering (in the perfect
>world) of "year-Ticketnumber".  Even better and to be
>a bigger pain can I do this with only 1 queue and
>leave the other tickets alone?  Any links on the
>subject, walk through or even pay pal money would be
>appreciated.  :)

-- 
Scott Frisbie
IT Department
scottf at eAcceleration.com
---
"A democracy is a sheep and two wolves deciding on what to have for
lunch.  Freedom is a well armed sheep contesting the results of the
decision." - Benjamin Franklin