Skip to main content
V
vmanojrc30
April 21, 2023
Solved

Access Table Data Manager from Finance Rules

  • April 21, 2023
  • 2 replies
  • 0 views

Please provide any guidance or knowledge documents on how to access data stored in table data manager tables via Finance Business rules.

Best answer by ckattookaran

What do you mean by table data manager data? Do you mean you want to get data from the tables created? There must be a lot of examples here if you search for brapi.database.createapplicationconnection. Create an app connection, write a SQL and get the data out.

2 replies

C
ckattookaranAnswer
April 21, 2023

What do you mean by table data manager data? Do you mean you want to get data from the tables created? There must be a lot of examples here if you search for brapi.database.createapplicationconnection. Create an app connection, write a SQL and get the data out.

J
JohnMorehead
April 21, 2023

I think what you are asking is how do I access data in custom database tables in a finance rule. You can use syntax such as this to pull the results from a SQL query into a .Net DataTable object. Once you have that, you can do all sorts of operations on it. You can use a query that will return a single result and use it, or a set of results and loop over it to do many things:

Using dbConnApp = BRApi.Database.CreateApplicationDbConnInfo(si)

        Dim allocationInTable as DataTable = BRApi.Database.ExecuteSqlUsingReader(dbConnApp, “Select * From XFC_ARC_AllocationDefinitions”, False)

         'Do something with the DataTable

end Using

Terms & ConditionsAccessibility statement