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
You would do this in a Dataset business rule which will provide all the flexibility you need to combine multiple datasets. You would then attach the dataset you define in this rule to a data adapter using the Command Type: Method & Method Type: Business Rule
Check out The Dutiful Dead, or: A Tale Of Mixed DataSets - OneStream Community (onestreamsoftware.com) for the techniques you can leverage in the Dataset BRs