Access Table Data Manager from Finance Rules
Please provide any guidance or knowledge documents on how to access data stored in table data manager tables via Finance Business rules.
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.
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
