Question
Zensar Technologies Ltd
IN
Last activity: 3 Jul 2023 9:04 EDT
Call GenerateID
Hi, I need to delete some IDs that are generated using OOTB activity Call GenerateID from database. Can someone help me to find the table names from which I can delete these IDs. Thanks,
Accepted Solution
Updated: 3 Jul 2023 9:04 EDT
DXC
AU
@AbhishekC1725 No only this table keep the reference no other table
Bits in Glass
IN
@AbhishekC1725 can you check instances of Data-uniqueid and see if the ids you looking for are in that table?
Zensar Technologies Ltd
IN
@Anoop Krishna Hi, Thanks for answer. I am able to locate the table and the prefix also in backend. Just want to confirm that I took Prefix as SH- for my id, and I generated 20 ids using Call GenerateID OOTB activity In that table pc_data_uniqueid only one record/row is present, for prefix SH-, and pylastreservedid = 20 . So, it is correct right. If we simply delete that one row for prefix SH- prefix it will be deleted all the previous 20 ids right?
DXC
AU
@AbhishekC1725 No, What this is do is it will reset the value, if you are still using the same prefix, then when you will create a new Workobject it will start with 1 instead of 21 in your case.
Zensar Technologies Ltd
IN
@gasharma Ok, Got it thanks, Do we have any other table from which we need to delete my SH- prefix record entry in pega? Currently I delete record from this table = pc_data_uniqueid only.
Accepted Solution
Updated: 3 Jul 2023 9:04 EDT
DXC
AU
@AbhishekC1725 No only this table keep the reference no other table
Pegasystems Inc.
GB
@AbhishekC1725 please can you mark the 'Accept Solution' against the reply that helped answer your question?
See our post Community Tip - Acknowledge Correct/Helpful Replies