Question
P3Fusion
IN
Last activity: 22 Jul 2019 9:18 EDT
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
Pegasystems Inc.
FR
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?
Swedbank AB
SE
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:
Let us know if it helps!
Thank you,
Pawan
Pegasystems Inc.
IN
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)
Accepted Solution
P3Fusion
IN
Thank you for the result I made in some different way and it is working good https://scrn.li/JbTkME915bJ3J7