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
