Changing the RequestID to start from a particular number

Changing the RequestID to start from a particular number

To change the RequestID to an number of you choice follow steps below.

1. Connect to SupportCenterPluss MySql database 
eg)
C:\\SupportCenter\\mysql\\bin>mysql.exe -u root -P 33356 supportcenter
2. Insert a dummy request with requestid and requesterid
eg)
mysql> insert into workorder (WORKORDERID,REQUESTERID,DEPARTMENTID) values (4999,2,1);
where request ID is 4999,  Requesterid is 2 and Department ID is 1
3.Shutdown SupportCenterPlus and restart it.
4.The next new request that you will create will have the requestid 5000.


For MSSQL database

insert into workorder (WORKORDERID,REQUESTERID,CREATEDTIME,DUEBYTIME,DEPARTMENTID) values (4999,2,0,0,1);

For Postgres database:

postgres# insert into workorder (WORKORDERID,REQUESTERID,CREATEDTIME,DUEBYTIME,DEPARTMENTID) values (4999,2,0,0,1); 

                    New to ADSelfService Plus?

                      • Related Articles

                      • 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, ...
                      • Script to Auto close Request when the status is Resolved for a particular number of days

                        For version 11 and above: -> In version 11, we only have the option to set the request Auto-close for a max of 10 days -> The below script will help you to extend the auto-closure time Execution steps: 1. Go to Reports--> New Query Report and run the ...
                      • Phone number need to be mandatory in 8.1 for contacts

                        Kindly follow the steps below to create the FAFR, 1. Access admin Module 2. Select the request template option and click the edit option the required request template the script needs to be applied on 3. Select the Fields and Forms Rule tab and paste ...
                      • Trying to start PostgresSQL server failed - While Upgrading

                        Error Trace. Trying to start PostgresSQL server failed java.net.ConnectException: Trying to start PostgresSQL server failed at com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer.startDBServer(DefaultPostgresDBInitializer.java:177) at ...
                      • How to Customize the Start Day in the application ?

                        We can customize the start day of your calendar in the application from Admin -> Self Service Portal. Steps to customize it : Goto -> Admin Tab -> Self Service Portal Settings: You can customize the start day as in the screen shot. Having it ...