Delete Work Object by Activity

Hi, Has anyone tried creating an activity to delete certain work object within PEGA (for v5.1)? I'm trying to use RDB-Delete in an activity to do that, and I need to pass a parameter from an activity to the connect sql, is that possible? How do I refer to the parameter within the connect sql statement? Thanks!

***Updated by moderator: Marissa to close post***
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.


Keep up to date on this post and subscribe to comments

September 23, 2008 - 9:08am

Caution: Do you really want to *delete*, or just force the pyWorkStatus to "Resolved-Cancel" or some similar status? You can force resolution that by adding a ticket to the flow, and raising the ticket in your activity.

Deleting is drastic. To make the database self-consistent, you'd want to delete the not only the work object, but also delete the work object history, work object attachments, and links. If there are open assignments at the time, they have to be deleted too. This will make all the standard reports pretty confusing to interpret.

Resolving with a special status leaves the work object around as a permanent record of what happened.

On the other hand, deleting ALL work objects / so to start over in testing / is used in test environments.

September 23, 2008 - 1:06pm


Thanks for the suggestion, but we want to delete unwanted work objects so that they won't be included in our customized reports. We were going to delete the work object, assigned work basket, assigned work party, assigned worklist, attachment links, and work history of the work object.

I know we can do this by running sql on the DB, but we would like to give users the ability to call for delete by running an activity within PEGA. So I'm trying to use RDB-Delete to run the sql statments to delete. However, I need to pass in the work object key. I have the work object key as a parameter on the activity, but how can I pass that to connect-sql? Would it be refered as {Param.InsHandle}?


September 23, 2008 - 1:23pm

Why dont you resolve the item with a Status like Resolved-Cancelled and in your custom report criteria exclude items of this status.

September 20, 2015 - 11:23am



How to delete bulk(multiple) operators from the system in Pega v7.1.7. Is there any activity?


Please help us on this.