Forum Discussion

irena_czaplicka's avatar
irena_czaplicka
New Contributor
2 years 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
Icon for OneStream Employee rankOneStream Employee
2 years 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()