Deletion of Item Data for Completed and Exception out Items

[ManishRaw]

Hi Team,

Is it possible to delete Item data of the work queue items that are already completed/exception using bp VBOs or any other way?

We have historical data in BP queue which is required for status purpose but we don't require the Item data and the same is taking up much space.#

------------------------------
Manish Rawat
Project Manager
Mercer
New Delhi
------------------------------

[shashank.kumar280]

Hi Manish,

Have you considered updating the work item data to blank/null just before marking as complete?
For the exception case you might need the data again if you retry the case.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

[ManishRaw]

Hi Shashank,

We are already setting work item data to blank for new items. But its the historical item data which we want to clear for completed and exception Items.

Also we will be clearing out the exception cases which are older than 1 year and retry is not needed.

NOTE: We cannot delete the processed items as the same are needed from status tracking purpose.

------------------------------
Manish Rawat
Project Manager
Mercer
New Delhi
------------------------------

[shashank.kumar280]

Ok got it. So are you able to update the data for completed items. I havent tried this though.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

[ManishRaw]

No, actually when I try to update the completed Item using "Set Data" it gives me an error that the item needs to be locked.
And when I try to lock the item by "Get Item by Item ID" it gives an error that it is unable to get a completed Item.

Hence I am stuck here.

------------------------------
Manish Rawat
Project Manager
Mercer
New Delhi
------------------------------

[Ernest1]

Have you tried using the 'Delete Processed Items' action from the 'Work Queues' object?