Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




How to increase issue ID from 4 digints to 10

web-app

Hi all,
How would one easily increase the issue ID number from 4 digits to say 10, or an arbitrary number of characters.

Regards,

Robert.
r0bertj
· 1 		r0bertj
Tuesday, April 18, 2006, 3:02:59 AM
Replies (2)
helpful
0
not helpful

You can force this using the following SQL:

set identity_insert issues on
declare @issueid int
insert into issues (issueid,projid,compid,reportedby,summary, longdesc,isstype,isspriority,issstatus,issresolution,risklevel,startdate,duedate,assignedto,fixedinverid, isprivate) 
  values (1000000000,1,1,1,'','',1,1,1,1,1,getdate(),getdate(),1, 1,0) 
select @issueid=@@identity
select * from issues
delete from issues where issueid=@issueid

 

This will make the issue numbers start from 1000000001
Mark Wing
· 9108 		Mark Wing
Tuesday, April 18, 2006, 10:24:52 AM
helpful
0
not helpful

Thanks for such a comprehensive answer.
I decided to simply change the seed value of the issues table, I was happy to have the old numbers start at 1 as set up by default.
r0bertj
· 1 		r0bertj
Wednesday, April 26, 2006, 3:01:51 PM