Changing the starting Ticket-Number

RT Users
1

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

2

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

The rt-users Archives

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