How to Mass Delete Paused and Waiting Interviews records
|Knowledge Article Number||000213446|
|Description||When navigating to the "Paused and Waiting Interviews" (Click on Setup | Build | create | Workflows & Approvals | Flows) I can see that there are multiple records that have been created and now it has reached its limit and we are getting unhandled process fault error in mail. We can delete one Interview record at a time but this will take lot of time to delete all the records so we need to mass delete them.
Is there any way to do so?
|Resolution||You can use Flow to solve this issue. Here are the steps to create the Flow:
To do this please navigate to Setup | Build | create | Workflows & Approvals | Flows and click on the Flow that you created above, it will redirect you to the Flow Detail page. There you can click on the "Run" button to execute the Flow. Please note this will immediately kick off the Flow and the Delete process.
Another alternative would be to use the API (Data Loader, Workbench...).
The FlowInterview object is exposed and records can be deleted via API version 33.0 or above.
More about the FlowInterview table in our Developer's Guide: https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_objects_flowinterview.htm