Workflow Locking Timestamp

JuleneDS
New Contributor

I am creating a tableview and I would like to pull the timestamp of when all our sub-workflow profiles were locked. I can audit each and get the lock history so it is stored somewhere.

We have our workflow profiles set up like this:

Jan
->Import
->IC Matching
->CAC
->Close Month End (Certify Step)
->Other reports
->Close reports (Certify Step)


Right now I can pull whether each step is locked using "BRApi.Workflow.Status.GetWorkflowStatus().Locked" and can get the timestamp of a profile with a certify step using "BRApi.DataQuality.Process.GetCertification". When I use "BRApi.Workflow.Status.GetWorkflowStatus().LastExecutedStepTime" it pulls a timestamp only for the top step and the certify steps (however in one of our dashboards we use this method to pull the timestamps of all our sub-profiles). This however is still just the last step done and not the actual locking time displayed.

 

Dim icInfo As WorkflowInfo = BRApi.Workflow.Status.GetWorkflowStatus(si, BRAPi.Workflow.General.GetWorkflowUnitClusterPk(si, row("ProfileName"),"Actual",timeName))
row("Workflow Status Timestamp") = icInfo.LastExecutedStepTime
JuleneDS_0-1724935028222.png
JuleneDS_1-1724935476017.png

Is there a way to do this? 

 

 

0 REPLIES 0