The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Combine 2 Methods of Data Adapters
Hi
I want to combine data from 2 out-of-box methods in Data Adapter for a custom grid.
Is there a function that I can use in BR to read data from the methods - FormsStatusForWorkFlowUnit and Cer...
Hi Mikki
You would just need to get your method queries into the same format (if they aren't already) and then merge the 2 datasets/data tables together.
Syntax for the method command is:
Dim objDataSet As DataSet = BRApi.Database.ExecuteMethodCommand(dbConn, methodTypeId, methodQuery, resultDataTableName, customSubVars)
There is an example of using method queries including looping through and working with the data within here:
There is a fair amount of info on google about joining data tables so I'll leave that to you!
- Daniel
Thank you both!