[rt-users] resetting ticket numbers

[Jason Bachman]

Thanks Frank... I will give that a try!!

Jason

Frank Pater wrote:

>Hi Jason,
>
>	I was able to do this for my Postgres-based RT installation with the following SQL:
>
>select setval('tickets_id_seq', <starting-ticket-number>);
>
>I'm sure there is similar code that works for MySQL.
>
>Frank
>
>
>On Fri, Nov 18, 2005 at 10:11:31AM -0500, Jason Bachman wrote:
>  
>
>>   I have a related question to this one.....
>>   Is it possible to change the starting ticket number?  The boss would like
>>   the ticket numbers to be something like 1001, 1002, 1003... instead of
>>   1,2,3...
>>
>>   Thanks,
>>   Jason
>>
>>   Walmach, Joe wrote:
>>
>>     Is it possible to reset the tickets back to zero? We're finished with
>>     our testing and want to go live but it would be good to erase all the
>>     test tickets first. Deleting them still holds them in the data base with
>>     the counter leaving off with the last ticket number. Truncating the
>>     ticket table in mysql (Linux) brought me back to zero but all new
>>     tickets include the original data in the history view. For example,
>>     ticket number 1 shows what transpired in the original ticket #1. I hope
>>     I'm not asking a question that's already been answered. I've searched
>>     the archives and only found one incident of this question which went
>>     unanswered. Any help would be appreciated.
>>
>>     
>>
>>     Thanks,
>>
>>     
>>
>>     Joe
>>
>>       ------------------------------------------------------------------
>>
>> _______________________________________________
>> [1]http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Be sure to check out the RT Wiki at [2]http://wiki.bestpractical.com
>>
>> Download a free sample chapter of RT Essentials from O'Reilly Media at [3]http://rtbook.bestpractical.com
>>
>> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
>> San Francisco - Find out more at [4]http://bestpractical.com/services/training.html
>>
>>References
>>
>>   Visible links
>>   1. http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>   2. http://wiki.bestpractical.com/
>>   3. http://rtbook.bestpractical.com/
>>   4. http://bestpractical.com/services/training.html
>>    
>>
>
>  
>
>>_______________________________________________
>>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>>Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>>
>>Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
>>
>>WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
>>San Francisco - Find out more at http://bestpractical.com/services/training.html
>>    
>>
>Frank Pater
>DCANet
>http://www.dca.net
>voice: 888-4-DCANET (888-432-2638)
>fax: 302-426-6386
>  
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20051118/5b876547/attachment.htm>