Call GenerateID

General
,
1

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,

2

@AbhishekC1725 can you check instances of Data-uniqueid and see if the ids you looking for are in that table?

3

@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?

4

@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.

5

@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.

6

@gasharma Ok Thanks

7

@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

8

@AbhishekC1725 No only this table keep the reference no other table