[rt-users] Ticket ID containing date

Phil Homewood pdh at snapgear.com
Sat Sep 20 04:20:48 EDT 2003


Robert Spier wrote:
> I don't know where you've seen this, but there is no way to do it in
> stock RT without a bunch of tweaking.

What about a nightly cron job that sets the DB's autoincrement field
to "`date '+%Y%m%d'`000" ? (I know, bad form, going behind RT's back
and all....)

The resultng number, whatever the mechanism, might be a little large
for the stock DB schemas, and RT itself might have issues with numbers
of that magnitude... and if you ever get more than 1000 tickets in a
day (autoresponder loop, anyone?), you could end up in strife as well.




More information about the rt-users mailing list