Skip to main content
December 13, 2023

Workflow Audit History

  • December 13, 2023
  • 2 replies
  • 0 views

Hi

Does anyone know where all of the below information is stored? 

 


2023-12-13_0-08-49.jpg

Thank you,

Mikki

 

2 replies

December 13, 2023

Wild guess: the Workflow*History tables...? 😅

If you can find an Application Report that displays the data, you can typically dissect it in Design Mode, get to the data adapters and from there to the tables (or methods) that you need.

MikkiAuthor
December 13, 2023

Thank you. I did the reverse engineering like you said but only managed to get Certify step info and that without user info. Application report is using Method query so no idea where the data sits in table. I will look into Workflow History tables.

MikkiAuthor
December 14, 2023

Hi, 

I am happy to try out the functions. I tried below (took from one other thread in this forum) but didn't work

Dim wfstatus As WorkflowInfo = BRApi.Workflow.Status.GetWorkflowStatus(si, mywfstep)
Dim logusername as String = wfstatus.LastExecutedStep.StepLogItems(0).UserName 

All I wanted is User name and time stamp of steps.