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
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
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
Ikor PX
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.