Hi ChrisBadenhorst you can get to the Workflow Status of any WFPOV. I have not used a BR to do that. Take a look at this WorkflowStatus Method Query which is available on the platform by way of a Dashboard Data Adapter. Create a new Data Adapter, for the Command Type select 'Method', for the Method Type select 'WorkflowStatus'. OneStream provides you a hint of the parameters needed to execute the Method Query. You can get all of the Statuses for each Workflow Task in a single Cube Root Workflow Profile.
Hope this helps.
Thank you Mike,
I unfortunately need to use a BR as there are a few things that need to happen based on the workflow status of the parent profile.
Chris
Try that ;
'Check the Workflow status of the parent (We can't calculate plan if the parent is certified)
Dim wfRegParent As WorkflowProfileInfo = BRApi.Workflow.Metadata.GetParent(si, si.WorkflowClusterPk)
Dim wfRegParentPk As New WorkflowUnitClusterPk(wfRegParent.ProfileKey, si.WorkflowClusterPk.ScenarioKey, si.WorkflowClusterPk.TimeKey)
Dim wfRegParentStatus As WorkflowInfo = BRApi.Workflow.Status.GetWorkflowStatus(si, wfRegParentPk, False) Hi Nic!
Thanks.
It errors on this line if the user does not have access to the Parent Workflow Profile.
Dim wfRegParent As WorkflowProfileInfo = BRApi.Workflow.Metadata.GetParent(si, si.WorkflowClusterPk)
Try
BRApi.Workflow.Metadata.GetParent(si, si.WorkflowClusterPk, False)