[TreeGridMultitableConnector->render_sql] Parent ID in SQL


#1

How can I use the parent ID in the SQL of the statement?

For example:

$treegrid->render_sql("select * from table where value={parent_id}","id","name");

I don’t want to use the final parameter of the render_sql function, as the query I want to perform requires a more complex query than what it adds


#2

It looks like the parent ID values of the connector classes are protected so I am unable to get them directly


#3

You can use a multi-table connector, which allows to define a different SQL query for different levels of a tree, so you will be able to provide your custom data filtration rules.

docs.dhtmlx.com/connector__php_ … ector.html