Loading data from 2 tables to grid

Suite and Optimus Suite 5
#1

Hi,

I want to display a grid that shows the result of a query made to table 1 (columns A and B) and after that the results of a query made to table 2 (columns A and B). All in the same grid.

Is this posible? If it is posible, how should the connector be configure? (I’m using PDO)

Thanks in advance.

#2

You may use the render_complex_sql function:
https://docs.dhtmlx.com/connector__php__connector_object_methods.html#rendercomplexsql
It allows to use any sql-code to get the data.