Can someone let me know of SOQL that can pull out all these fields from Approval History ?
Action, Date, Status, Assigned To, Actual Approver, Comments, Overall Status
So far I found out that we can get all the approvals (for one record) using the following query
SELECT Id FROM ProcessInstance WHERE TARGETOBJECTID = "record id here" ORDER BY CreatedDate DESC
This gives me all the processinstances as shown below.
Then I queried ProcessInstanceNode to get various information like
Action, Date, Status
But I am not sure how to get other information like "Assigned To, Actual Approver, Comments and Overall Status"
Can someone help ?