[rt-users] Starting ticket numbering at a given number

[Nils-Erik Svangård]

Ruslan U. Zakirov wrote:

> Nils-Erik Svangård wrote:
>
>> Matthew Cheale wrote:
>>
>>> You have to alter the database table and set it's auto number start 
>>> point.
>>>
>>> Jean-Michel Barbet wrote:
>>>
>>>> Hi,
>>>>
>>>> Currently evaluating RT and trying to have tickets created in it
>>>> in parallel with req...
>>>>
>>>> => How can I set RT to start numbering at a given number ?
>>>>    How is found the next number to use ?
>>>>
>>>> (I tried to modify the id and EffectiveId for the last created ticket
>>>>  in the Tickets table but it does'nt work. Next ticket is created with
>>>>  previous next available number, not the one I set).
>>>>
>>>> Jean-Michel BARBET.
>>>>
>>>
>> Is this to make RT not start its search from ticket nr 1?
>
> No. It's to force DB to use custom start value for ticket's id.
> Not 1, but 1000000.
>
>> If so how do you search older tickets?
>> /nisse
>>
>
Ok, if I want to all searches to by default search the latest 2000 
tickets and not all 45000. Is that possible?
Or do I have to dump part of the db to get that to work?
/nisse

-- 
<+--//  							\\--+>
	       Datorcentralen Luelå tekniska universitet	  
	Name:	Nils-Erik Svangård	e-mail:	nisse at dc.ltu.se	  
	Ph:	+46-920-49244		URL:http://www.dc.ltu.se  
<+--\\								//--+>