function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Chandra ShekharChandra Shekhar 

How do I join user and custom object to know if particular user has approved or pending or rejected a record form custom object

I Need to Write an SOQL Query to know how many records are in pending state by a user from a custom object
Best Answer chosen by Chandra Shekhar
SandhyaSandhya (Salesforce Developers) 
Hi,

ProcessInstance represents an instance of a single, end-to-end approval process. Use this and the node, step, and workitem process instance objects to create approval history reports.

Please refer below link which has a similar discussion with sample code.

http://salesforce.stackexchange.com/questions/113784/query-users-items-to-approve
 
Hope this helps you!

If this helps you, please mark it as solved.

Thanks and Regards
Sandhya