function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Shivprakash SoniShivprakash Soni 

Is there any way to find out in how many approval processes a user is present through SOQL query or by any other way(not manually)

Danish HodaDanish Hoda
hi Shivprakash,
You can get some insights with the below query:

SELECT Id, ProcessInstanceId, StepStatus, OriginalActorId, ActorId  FROM ProcessInstanceStep
Devi ChandrikaDevi Chandrika (Salesforce Developers) 
Hi shivprakash,
You can query for approval processes the user is  currently assigned as approver. 
We have an object ProcessInstanceStep which represents one work item in an approval process.

Try this SOQL  
select id , ActorId  from ProcessInstanceStep where ActorId = 'your_userID'
Please refer below link which might help you in this.
https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_processinstancestep.htm

Hope this helps you
Let me know if this helps you. Kindly mark it as solved so that it may help others in future.

Thanks and Regards