Question
Confidential
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 [email protected]
update pc_data_uniqueid set [email protected]
delete from [email protected]
delete from [email protected]
delete from [email protected]
delete from [email protected]
delete from [email protected]
delete from [email protected]
delete from [email protected]
delete from [email protected]
[email protected]
We need to write the activity to delete all the cases from case history. using below tables.
delete from [email protected]
update pc_data_uniqueid set [email protected]
delete from [email protected]
delete from [email protected]
delete from [email protected]
delete from [email protected]
delete from [email protected]
delete from [email protected]
delete from [email protected]
delete from [email protected]
[email protected]
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'
Confidential
IN
Hi Anand,
How come it will work, when there is no data?
Regards,
Balu