07-17-2024 02:28 PM
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
Solved! Go to Solution.
07-17-2024 07:29 PM
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
07-17-2024 07:29 PM
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
07-18-2024 07:59 AM
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
07-19-2024 10:52 AM
Thank you both!