Start ticket number at an arbitrary value

RT Users
1

Is anyone aware of a way that I can have my next ticket start at an
arbitrary high value that I select? I’m on a new installation, and I
have created a few test tickets (I believe I’m up to number 4) but if
possible I would like the next ticket to start at 5000.

2

Insert a row in the tickets table with id 4999, then the next ticket will be
5000.On 10/25/07, John Arends jarends@uiuc.edu wrote:

Is anyone aware of a way that I can have my next ticket start at an
arbitrary high value that I select? I’m on a new installation, and I
have created a few test tickets (I believe I’m up to number 4) but if
possible I would like the next ticket to start at 5000.

3

That was my initial plan, but I wanted to make sure there wasn’t an RT
sanctioned way, since the general recommendation seems to be to avoid
messing with the database directly.

I can’t imagine this would cause any integrity problems.

Todd Chapman wrote:

4

At Thursday 10/25/2007 04:47 PM, you wrote:

Insert a row in the tickets table with id 4999, then the next ticket
will be 5000.

This may depend on which database you’re using. Oracle, for example,
uses a sequence object for the next id, so in that case you’d need to
reset the sequence value.

Steve>On 10/25/07, John Arends <mailto:jarends@uiuc.edujarends@uiuc.edu > wrote:

Is anyone aware of a way that I can have my next ticket start at an
arbitrary high value that I select? I’m on a new installation, and I
have created a few test tickets (I believe I’m up to number 4) but if
possible I would like the next ticket to start at 5000.

Stephen Turner
Senior Programmer/Analyst - Client Support Services
MIT Information Services and Technology (IS&T)