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
Steven's avatar
Steven
Contributor II
8 months ago

BRApi.Workflow.Metadata.GetProfile(si, si.WorkflowClusterPk).Name

  • vignesh's avatar
    vignesh
    New Contributor II
    8 months ago

    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)