04-20-2023 10:21 PM - last edited on 05-25-2023 05:45 AM by JackLacava
Please provide any guidance or knowledge documents on how to access data stored in table data manager tables via Finance Business rules.
Solved! Go to Solution.
04-20-2023 10:56 PM
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.
04-21-2023 12:34 PM
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
04-20-2023 10:56 PM
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.
04-21-2023 12:34 PM
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