Work objects can pile up in Development and Test environments rapidly. Sometime clients require clean up of unused work objects.
Pega has provided “Archival and Purge” wizard for doing the cleanup but it is intended more for production environment where we can configure this wizard to remove resolved work objects. This wizard does not provide flexibility like what if we want to remove open work objects or we just want to run the purging only once.
SQL scripts provide more flexibility as we can configure the parameters based on our requirements.
When we talk about cleaning up work object then we have to consider below associated components of work object.
- Assignments associated with work objects
- History of work objects
- Attachments of work objects
- Folders (if work objects are using folders)
- work objects