datatree

Webix JS
#1

hi, i have this select that produce this result

SELECT property_id,property_name,aisurvey_property_elements.`element_name`,aisurvey_asset.`asset_name`
FROM aisurvey_property 
INNER JOIN aisurvey_property_elements ON aisurvey_property.`property_id` = `aisurvey_property_elements`.`fk_property_id`
INNER JOIN aisurvey_asset ON `aisurvey_property_elements`.`element_id` = aisurvey_asset.`fk_elements_id`
ORDER BY property_name
105  CROVETTO        ELEMENTO 1              ASSET 1               
105  CROVETTO        ELEMENTO 2              ASSET 2        
105  CROVETTO        ELEMENTO 3              ASSET 3                
101  FLAMINIA          ELEMENTO 1              ASSET 4
101  FLAMINIA          ELEMENTO 2              ASSET 5
101  FLAMINIA          ELEMENTO 3              ASSET 6

I would like to build a DataTree with checkbox with the following 3 levels .
How can I do?
Thank you

#2

The tree components expect to receive the hierarchical data.
http://docs.webix.com/datatree__loading_data.html

It can load a plain data as well, and group it to the tree later
http://docs.webix.com/datatree__loading_data.html#loadinglinearlistlikedata