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
It looks like the parent ID values of the connector classes are protected so I am unable to get them directly
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