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 CertificationForWorkflowUnit
Thank you in advance,
Mikki
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
3 Replies
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
Thank you both!
