Delete Cases in Bulk
I'm running PRPC 7.1.8 and attempting to delete all cases from a Dev instance. I created a Purge/Archive operation, scheduled and ran it, but it did not delete anything. The archive process seemed to work, but all the cases that met the criteria under the Schedule Process utility (> 1 day old) are still there and did not get deleted.
Is there a way to delete all cases from an application? And reset the case number scheme if possible.
Thanks
Pegasystems Inc.
IN
Delete from pc_data_uniqueid@
update pc_data_uniqueid set pylastreservedid=0@
delete from <WorkPool>@ // please replace with workpool table.
Delete from pc_work@
delete from pc_assign_worklist@
delete from pc_assign_workbasket@
delete from pc_history_work immediate @
delete from pc_data_workattach@
delete from pc_index_workparty@
delete from pc_link_attachment@
delete from pc_link_folder@
Commit@
Vodafone GmbH
DE
Hi Sahup,
1) What table has to be taken for <WorkPool>?
2) How does the query look like if i want to delete cases older a specific date?
3) Are there any side effects, that need to be covered?
4) I think your SQLs script is a complete cleanup, where all cases are removed. Is it?
Regards, Andre
Tygart Technology
US
When stepping through the wizard again, it says it will only purge RESOLVED work.
Is there a way to delete cases that are not resolved in bulk?
Thanks
Pegasystems
The wizard wants the case to be resolved so all subcases and assignments are cleaned up. You can run an activity that loops through a list of cases (obtained from a report definition) and calls pxForceCaseClose to Complete all of the work. You will pass the desired resolved status (for example, Resolved-Complete) as a parameter. Set the Commit parameter to true. Then you can use the wizard to delete the cases.
NIIT Technologies Limited
AU
Addition to NORIR's comment -
After resolving and purguing all work objects, you have to manually update the pc_data_uniqueid table to start the ID generation from 1.
Pegasystems Inc.
IN
could you please correct me otherwise, we generally set to pylastreservedid to ZERO and not ONE
update pc_data_uniqueid set pylastreservedid=0
Thank you!
Pegasystems Inc.
US
See also SA-12080, https://community.pega.com/support/support-articles/delete-work-objects-bulk, which cites this discussion and the pertinent Help topic as Related Content.