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