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

getting notification date in approval subprocess



I need to get the notification date using SOQL.


For this I am using this

SELECT ActorId, Actor.Name, Actor.Email, CreatedDate,ProcessInstance.Status, ProcessInstance.TargetObjectId, ProcessInstance.TargetObject.Name  FROM ProcessInstanceWorkitem    WHERE  ProcessInstance.Status = 'Pending' AND ProcessInstance.TargetObject.Type = 'APSTD__c' and ProcessInstance.TargetObject.Name='PID-37'


Here I am getting created date but I need to get the Notification date when the mail is triggered in order to send reminder mails.



Please suggest on this.




I don't think we can capture it directly from query.