+ Start a Discussion
MC34MC34 

How to delete paused flow interviews with Inactive users?

Hi, 

There are nearly 23K paused flow interviews that are triggering an error emails because they were started by inactive users. I would like to detele these. However, I can draw a CSV based on user id (tried in wrk bench) not based on if those users are active or not. Is there an easy way to do that? Via data loader? 

Thank you, 
Mit 
Yogendra JangidYogendra Jangid
Hi MC34, probably you are looking for something like this.
select id, name, OwnerId from FlowInterview WHERE Owner.IsActive = true
so consider having this SOQL while retrieve data from workbench or Datatloader and you will get all flow intervies where the owner is isactive.
Hope this answers your question and if so please can you mark this as best answer. Thanks.
VinayVinay (Salesforce Developers) 
It isn't possible to change the owner/user for a "waiting" flow interview. The only way to handle this is to re-activate and then "freeze" the user. Once all the flow interviews related to the user are complete, you can deactivate the user's.

Kindly review below link for more details.

https://help.salesforce.com/articleView?id=000339311&type=1&mode=1

Also you might review and vote for this feature.
https://trailblazer.salesforce.com/ideaView?id=0873A000000cM8AQAU

Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
Yogendra JangidYogendra Jangid
Also if you want it to be by user who created, please use following query.
select id, name from FlowInterview WHERE CreatedBy.IsActive = true