Question
Apple India Pvt Ltd
IN
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@
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.
Pegasystems Inc.
US
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!
Tata Consultancy Services
US
Hi Balu,
If your db is of Oracle, the below kind of query can help to revert back each tables to its past state
Hi Balu,
If your db is of Oracle, the below kind of query can help to revert back each tables to its past state
insert into test_table
select * /* specify past time */
from test_table as of timestamp timestamp '2016-12-28 10:10:10'