Forum Discussion

vignesh's avatar
vignesh
New Contributor II
8 months ago

Retrieve Workflow channel Information using the Profile.

I am trying to retrieve Workflow Channel Information for a specific Workflow Profile in a Business Rule. I am able to fetch it using SQL using the Attribute Index value. Just checking if there is any...
Workflow
vignesh's avatar
vignesh
New Contributor II

This will return Workflow Profile Name, I want the Workflow Channel.

 

Krishna's avatar
Krishna
Valued Contributor
8 months ago

vignesh  - The below Code Provide you the Value of WF Channel not the name. Hope this is a good starting point for you.

In SQL it is easy. 

Sample 1

Dim scenario As String = "Actual"
				Dim wfClusterPk2 As WorkflowUnitClusterPk = BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, "CORP GL LOAD", scenario, "2024M1")
				Dim objList As List(Of WorkFlowProfileInfo) = BRApi.Workflow.Metadata.GetRelatives(si, wfClusterPk2, WorkflowProfileRelativeTypes.Descendants, WorkflowProfileTypes.InputImportChild)

				Dim wfList As New Dictionary(Of String, WorkFlowProfileInfo)
				For Each w As WorkflowProfileInfo In objList
					
					Dim A As String =  w.GetAttributeValue(ScenarioTypeID.Actual, SharedConstants.WorkflowProfileAttributeIndexes.WorkflowChannel)
					
					brapi.ErrorLog.LogMessage(si,A)
				Next


Sample 2
--------------
Dim wfCh As String = brapi.Workflow.Metadata.GetProfile(si,"GL Data load COPR STD.Import").GetAttributeValue(ScenarioTypeID.Actual, SharedConstants.WorkflowProfileAttributeIndexes.WorkflowChannel,Nothing)
brapi.ErrorLog.LogMessage(si,wfCh)