Question

3
Replies
778
Views
Close popover
Bala Gangadhar Patuvardhanam (Balu_Patuvardhanam)
IQZ Systems Pvt Ltd
Bala Gangadhar Patuvardhanam
IQZ Systems Pvt Ltd
IN
Balu_Patuvardhanam Member since 2015 5 posts
IQZ Systems Pvt Ltd
Posted: November 27, 2016
Last activity: March 16, 2018
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.