Rename Case ID Prefix for Existing Data


We have a requirement to change Case ID prefixes for existing work objects and also their references like childs and parents.

Do we have any product OOTB utility for this? please suggest if any one worked on this kind of requirement.

Thank You!


***Edited by Moderator Marissa to update platform capability tags****


Keep up to date on this post and subscribe to comments

April 18, 2019 - 3:19am


You also want to change prefixes for existing cases in Production? What is your version of PRPC?

April 18, 2019 - 8:56am

Yes, we need to do in production as well. Our current version is Pega 7.4. 

I tried one time activity, open work object and update case id string replace with string as per our requirement, system created a new instance with new case id automatically updated pxinsname and pzinskey. is this right approach? Please provide your suggestions. 

Appreciated for your time.

Thanks much!


April 19, 2019 - 3:33am
Response to SrideviK9723

Hello Sri,

I never had such requirement but you might have references everywhere. Say for example attachments, with your activity, when you get the new IDs generated can you still access attachments correctly?

November 19, 2019 - 6:01pm
Response to SrideviK9723

I have a similar situation, Is there a straight forward way of doing it.

April 23, 2019 - 2:06pm

Hi, Yes attachments are not automatically linked to the renamed pyID but we can manually update the link attachment table to make this reference. All the work reference tables like history, attachments we need to manually update the reference object keys after the pyID renamed in work table. I have tested its working fine.

Now I am checking scenarios when work objects has  child cases, seems pxCoveredInsKeys is a value list hopefully i can update it. For Child to Parent can I update pxCoverInsKey? Please share your thoughts here.

Much appreciated.

Thank You!

Best Regards,