How to reset work object record # back to 1
Hi Community,
I have been searching online but I have yet to find out how to reset the work object record # back to 1 after purging every existing work ID for a case. Does anyone know how to do this?
Thanks,
Masato
***Edited by Moderator Marissa to update platform capability tags****
Areteans Tech
AU
AASEYA IT SERVICES PVT LTD
IN
Hi Mastan Please find the below querie to achieve your requirement
update pegadata.pc_data_uniqueid set pylastreservedid=0 where pyprefix=<prefex of you Work object>
feel free to reach me for any doubts
Accenture
IN
hi may i know where to execute this query so that the value gets reset
Pegasystems Inc.
AU
You can open the instances of class Data-UniqueID and delete the corresponding record (based on the prefix) by opening the XML.
This will reset the counter and case prefix will begin from 1.
Accenture
IN
will this delete the records and associated information
Hi Masato,
Once the case is triggered , a unique case prefix gets stored in the data.PC_DATA_UNIQUEID table .
If you want to reset the case ID to start from #1 , you can delete the record which has corresponding prefix and all the Work Items starting with the Prefix should also be deleted from the corresponding Work table.
Note: This can cause the loss of existing work item data