Retrieve User behind completion of a workflow step (Forms & Journals) ?
Hello,
Is it possible to get the user who completed a 'Form Input' step in OneStream ?
To clarify, I am able to do so for 'Import/Validate/Load' steps but I'm under the impression that it's impossible for Forms or Journals. Anyone with a similar experience ?
Thanks
Here goes my desperate attempt:
Dim wfstatus As WorkflowInfo = BRApi.Workflow.Status.GetWorkflowStatus(si, mywfstep)
Dim logusername as String = wfstatus.LastExecutedStep.StepLogItems(0).UserName
' (wfstatus.LastExecutedStep.StepLogItems is Nothing) = True
There is a DataAdapter method that will give you that information, so you can execute that (from a rule if necessary).
As far as I can see (but I've not tested it), the public API allows you to retrieve the forms with BRApi.Forms.Metadata.GetForms(si, wfClusterPk) , which should reflect form status, but it doesn't report the author. You could get the form ID from there and then look up some database table to get the user, but I reckon it's easier to just leverage the adapter.
Same deal my friend, you need to leverage infos from the tables in your database ! Go check out the table 'TaskflowLogItems' and search for the rows where 'Reason contains ConfirmXXX' and cross it with another table that logs infos you need. Everything is stored there ! For Import/Validate/Load steps you can find what you need in 'TaskActivity' tables
If this helps a bit, don't hesitate to drop a Kudos it would be appreciated