Posted: 27 Nov 2016 5:18 EST Last activity: 16 Mar 2018 19:46 EDT
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.
Hi, Once committed I dont think the data can be rollbacked. It might be possible to work with the database administrator to rollback the data to a previous state but it is outside of Pega control. Thanks!