Check documentation for the latest version of dhtmlxSuite TreeGroupConnector and TreeGridGroupConnector DHTMLX Docs

TreeGroupConnector and TreeGridGroupConnector

Default connector for Tree and TreeGrid expects that data in DB is stored with child-parent key relation. But, in some cases, tree or treegrid need to be shown from plain data (by grouping it). Such task can be resolved with help of the TreeGroupConnector or TreeGridGroupConnector.

For example, a table 'products' grouping by category. As result, the top level are 'categories', the second level - 'products', related to the category.

<cfinclude template="../config.cfm">
<cfset tree = createObject("component","dhtmlXConnectors.TreeGroupConnector").init("#datasource#","MySQL")>
<cfset tree.render_table("products2","id","product_name","","category")>
<code cfm>
<cfinclude template="../config.cfm">
<cfset tree = createObject("component","dhtmlXConnectors.TreeGridGroupConnector").init("#datasource#","MySQL")>
<cfset tree.render_table("products2","id","product_name,scales,colour","","category")>


Back to top