Wednesday, July 8, 2026

Get workflow Approver and approval time through code

  WorkflowTrackingStatusTable wfTrackingTable;

 WorkflowTrackingTable       wfTracking;


 select firstonly wfTrackingTable

     order by wfTrackingTable.CreatedDateTime desc

             where wfTrackingTable.ContextTableId == _purchTable.TableId

             && wfTrackingTable.ContextRecId   == _purchTable.RecId;


 select firstonly   wfTracking

         order by wfTracking.CreatedDateTime desc

         where wfTracking.WorkflowTrackingStatusTable == wfTrackingTable.RecId

            && wfTracking.TrackingType == WorkflowTrackingType::Approval

             && wfTracking.TrackingContext==WorkflowTrackingContext::WorkItem;


 Date POApprovalDate = DateTimeUtil::date(wfTracking.CreatedDateTime);

 str POApprovedBy   = HcmWorker::find(HcmWorker::userId2Worker(wfTracking.user)).name();

No comments:

Post a Comment

Get workflow Approver and approval time through code

  WorkflowTrackingStatusTable wfTrackingTable;  WorkflowTrackingTable       wfTracking;  select firstonly wfTrackingTable      order by wfTr...