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

is possible change rest id for all servicecalls?

SOLVED
Go to solution
Highlighted
PEPE_23
Super Collector

is possible change rest id for all servicecalls?

Hi,
I need reset the ID on all servicecalls but Ion't want delete this servicalls only reset the ID. I need start the ID with 1 because I delete 300 scall.
7 REPLIES
Crist Vandendri
Esteemed Contributor
Solution

Re: is possible change rest id for all servicecalls?

Hi,

This is possible and quite easy. You will have to manipulate the DB though. Have a look at this thread.

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=42105

Hope this helps,

Crist
PEPE_23
Super Collector

Re: is possible change rest id for all servicecalls?

Thanks
William_157
Senior Member

Re: is possible change rest id for all servicecalls?

Hi PEPE

you can tell me how u reset the sc id, but still the old sc.

Thanks
PEPE_23
Super Collector

Re: is possible change rest id for all servicecalls?

I need reset Id but i don't want remove servicecalls is possible?
Crist Vandendri
Esteemed Contributor

Re: is possible change rest id for all servicecalls?

Yes you can do that. But you will need to be carefull that you do not create duplicate IDs.

The SQL statement in the other thread will not work though. You will need to create your own, or manually change the IDs of the existing service calls.

First you need to change the IDs in ITSM_SERVICECALLS, field SER_ID (NOT SER_OID!!!!!!!). After that start the sequence with the last ID+1 in IFC_SEQUENCES.

You will have to keep in mind that if you have communicated IDs to your callers (your service call was created with ID x), that reference has changed.

Links between items (eg Service call-person) will not be harmed since they use the SER_OID. That's why you don't want to mess around with that.

Crist
PEPE_23
Super Collector

Re: is possible change rest id for all servicecalls?

OK
Ali Safwan
Super Collector

Re: is possible change rest id for all servicecalls?

Hi,
i wana know the next value of ser_oid
from where can i get it ?

Regards
Ali Safwan
//Add this to "OnDomLoad" event