Question

Delete the work object from all the DB Tables

I need to delete all the work case related dependency from the DB what is the step I need to follow, can I use RDB-Delete from DB and suggest me the step to follow for this operation

Correct Answer
July 22, 2019 - 7:40am

Thank you for the result I made in some different way and it is working good https://scrn.li/JbTkME915bJ3J7

Comments

Keep up to date on this post and subscribe to comments

June 14, 2019 - 4:42am

Hello,

Deleting from Dev environment? If yes then I think it would be easiest to do it from the database directly. 

If no then maybe you should archive those cases instead of deleting. What pega version are you using?

Pega
June 14, 2019 - 7:17am

Hello Manoj,

Instead of directly deleting records from the database, you can review the scope of Purge/Archive wizards and see if it meets your requirement.

Link to the same is below:

 https://community1.pega.com/sites/pdn.pega.com/files/help_v731/procomhelpmain.htm#tools/purgearchive/aboutpurgearchivewizard.htm

 

Let us know if it helps!

 

Thank you,
Pawan

Pega
June 14, 2019 - 7:36am

Hi Manoj,

To delete the cases manually, there is a lot of work involved. You can call obj-delete/obj-delete-by-handle from activity. But you have to consider all the tables mentioned below to delete the dependencies.  

Work Table, History table, Assignments(worklist, workbasket), Attachments tables(pc_data_workattach, pc_link_attachment), Work parties table (pc_index_workparty), Pulse messages(pc_work_social), Queue tables in case of any queue items created. 

(Not sure if I missed any)

 

July 22, 2019 - 7:40am
Response to PranathiC

Thank you for the result I made in some different way and it is working good https://scrn.li/JbTkME915bJ3J7