Set Request Id to start from a particular number - Version 11.0.

Set Request Id to start from a particular number - Version 11.0.

Regarding the First Portal (General), you can use the below steps to change the Request Id to start from 136000. 

1.The below Select Query will give the last active ticket ID. 

 

Select * from SeqGenState where seqname='WorkOrder.WORKORDERID';



2.Then, please do use the below query to change the Request id to start from 136000. 


update SeqGenState set currentbatchend = ID where seqname='WorkOrder.WORKORDERID';


Replace ID in the above query with the request ID you would like to start with. Refer to the sample query below:


Example: update SeqGenState set currentbatchend =136000 where seqname='WorkOrder.WORKORDERID';




Query to update the Request id in the second portal. 


1.The below Select Query will give the last active ticket ID. 

Select * from SDSeqGenState where seqname='WorkOrder.WORKORDERID';



2.Please use the below query to get the Portal Name and the corresponding Helpdesk ID


select * from helpdeskdetails;





3.Please do run the below query to find the range of the Portal. 

select * from ESMSequenceConfig ;





4.Please do find the update query below:

update SDSeqGenState set currentbatchend = ID where seqname='WorkOrder.WORKORDERID' and helpdeskid = HELPDESKID ;



As your updating the Request id's for 2 portals, let us consider that you've changed the Request id to start from 136000 in the General Portal. Now, for the second portal, please do run the 2nd Query to get the Portal id for "Second Portal", then run the 3rd Query to get the range for that specific portal Id. 


Consider the Start Sequence is 100000001 and the End Sequence is 200000000 for that Helpdesk ID. If you would like to have the ticket from 500K. Then ID in Query 4 should be 100500001 and Helpdesk ID should be replaced based on Query 2. 


update SDSeqGenState set currentbatchend = 100500001 where seqname='WorkOrder.WORKORDERID' and helpdeskid = 301;


After running the update query, please restart the application for the changes to take effect. If possible, please take a backup of DB before running the query. 



To give you an example, I've changed the General Portal to start from 136000.  





But for the second portal, I cannot change the Request id to 1 but within the range of that portal. 

You can find the range using the below query:






I've set up the second portal to start from 100000005.