Forum Discussion

irena_czaplicka's avatar
irena_czaplicka
New Contributor
11 months ago

Joining Method Data Adapter table with SQL query

Hi team! We are trying to connect Result Table obtained from the Method query (WorkflowAndEntityStatus) in Data Adapter with another table, preferably SQL table. We expect that it is possible to be...
Data Sources
aformenti's avatar
aformenti
Contributor II
11 months ago

Hi irena_czaplicka ,

That is definitely possible.

Indeed, you need to use a Data Set Business Rule, and then you can leverage this api to retrieve the data from the method query data adapter:

'Gets data from the Cube View MD Data Adapter:
				Dim objDataSet As DataSet = BRApi.Dashboards.Process.GetAdoDataSetForAdapter(si, False, DataAdapterName, "ResultTableName", args.CustomSubstVars)
				Dim dt As DataTable = objDataSet.Tables(0).Copy()