Changing the starting Ticket-Number

Hi all,

i know this was asked before, but I didn’t find it in the archives.
How can I change the ticket-number to a format like yyyymmddnnn with

yyyymmdd as a date-Format and nnn being an Integer from 000 to 999?

I know that I have to do it via cron, but didn’t find the proper
mysql-Statement.

Thanks in advance for your help.

Bye for now,
Bis denne,
Joerg

You can’t.On Fri, Aug 20, 2004 at 10:33:11PM +0200, Joerg Herbert wrote:

Hi all,

i know this was asked before, but I didn’t find it in the archives.
How can I change the ticket-number to a format like yyyymmddnnn with

yyyymmdd as a date-Format and nnn being an Integer from 000 to 999?

I know that I have to do it via cron, but didn’t find the proper
mysql-Statement.

Thanks in advance for your help.


Bye for now,
Bis denne,
Joerg


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com