Question

3
Replies
736
Views
Balu_Patuvardhanam Member since 2015 5 posts
Incessant Technologies
Posted: 3 years ago
Last activity: 2 years 11 months ago
Closed

Clearing the Cases

We need to write the activity to delete all the cases from case history. using below tables.

delete from pc_data_uniqueid@
update pc_data_uniqueid set pylastreservedid=0@
delete from pc_work@
delete from pc_assign_worklist@
delete from pc_assign_workbasket@
delete from pc_history_work@
delete from pc_data_workattach@
delete from pc_index_workparty@
delete from pc_link_attachment@
delete from pc_link_folder@
commit@

Is there any other way to rollback my data? I know once it deleeted from db there is no alternative solution to rollback once it is commited.

Is pega handling it?

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development
Moderation Team has archived post
Share this page LinkedIn