Forum Discussion

Mikki's avatar
Mikki
New Contributor III
2 years ago

Workflow Audit History

Hi

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

 

Thank you,

Mikki

 

Workflow
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    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.

    • Mikki's avatar
      Mikki
      New Contributor III
      2 years ago

      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.

  • Mikki's avatar
    Mikki
    New Contributor III
    2 years ago

    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.