04-10-2024 12:26 PM - last edited on 04-10-2024 07:43 PM by JackLacava
Can anyone share brapi command to fetch the Workflow's Hierarchy Level in the Business Rule?
Solved! Go to Solution.
04-11-2024 12:45 PM
Not sure what that is, is it BRApi.Workflow.Metadata.GetProfile(si, "Your profile name").Level , by any chance...?
04-11-2024 05:43 AM
I don't think there is a BRApi object for managing/viewing the Workflow properties. The MarketPlace app XFW Reporting Compliance (RPTA) queries the workflow set up but uses a direct SQL call. Here is an example:
Public Function WfProfile_DescAdjChild(ByVal si As SessionInfo, ByVal strProfileKey As String) As DataTable
Try
'Define the SQL Statement
Dim sql As New Text.StringBuilder
sql.Append("SELECT ")
sql.Append("ProfileKey, ")
sql.Append("ProfileName As Name, ")
sql.Append("ProfileType ")
sql.Append("FROM ")
sql.Append("WorkflowProfileHierarchy ")
sql.Append("Where ")
sql.Append("ProfileType = 51 ")
sql.Append("And ProfileKey In (" & strProfileKey & ") ")
sql.Append("ORDER BY ")
sql.Append("HierarchyIndex ")
'Execute the query
Using dbConnApp As DbConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si)
Dim dt As DataTable = BRApi.Database.ExecuteSql(dbConnApp, sql.ToString, False)
dt.TableName = "WorkflowProfiles"
Return dt
End Using
Return Nothing
Catch ex As Exception
Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
End Try
End Function
04-11-2024 05:48 AM
Thanks Marcus, I was able to use SQL and get it, but checking if there is any inbuilt command to grab it.
04-11-2024 12:12 PM
@vignesh - I tried yesterday could not find. If I find anything will post here.
04-11-2024 12:45 PM
Not sure what that is, is it BRApi.Workflow.Metadata.GetProfile(si, "Your profile name").Level , by any chance...?
04-11-2024 01:41 PM
Yes, it works. Thank you @JackLacava
Dim a As Integer = BRApi.Workflow.Metadata.GetProfile(si,"GL Data load COPR STD.Import").Level
brapi.ErrorLog.LogMessage(si,A & "Value")
04-12-2024 01:38 AM
Thanks Jack