Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to Change Service Call ID Number .... !

Highlighted
Thiwanka
Regular Collector

How to Change Service Call ID Number .... !

Dear All,

I have a requirement to change the Call ID to start from 20000 on-wards ....

Presently it has reached 16231. I need all new calls to be logged from 20000. (Company requirement)

Q1 - Where do I change this ..... ?
Q2 - What's the DB to be change .... ?

Pls Advice ... !

Thanks,

Thiwanka.
IT is Great !
3 REPLIES
Vasily Kamenev
Honored Contributor

Re: How to Change Service Call ID Number .... !

Hi
Modefy the DB table IFC_SEQUENCES line where you have 16xxx to 20000.
that all.

Vassili
George M. Meneg
Honored Contributor

Re: How to Change Service Call ID Number .... !

Hello,

Run this query to get the SEQ_USN of the service calls.

select * from IFC_SEQUENCES where SEQ_CAT_OID= (select ent_oid from ifc_entities where ent_name='Service call')

set SEQ_USN to 19999 and after doing that the first service call you'll create will have the ID 20000
menes fhtagn
Thiwanka
Regular Collector

Re: How to Change Service Call ID Number .... !

Thanks Guy's !!!
IT is Great !
//Add this to "OnDomLoad" event