Skip to main content
Mikki
Member
Dec 13, 2023 5:13 AM UTC

Workflow Audit History

Hi

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

 

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

Thank you,

Mikki

 

    3 replies

    Employee - Sage
    JackLacavaEmployee - Sage
    Employee - Sage
    Dec 13, 2023 4:25 PM UTC

    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
      Member
      Dec 13, 2023 4:59 PM UTC

      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
      Member
      Dec 14, 2023 4:31 AM UTC

      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. 

        Terms & ConditionsAccessibility statement