Dynamically populating Menu Tree from database table

[jlandwerlen]

Perhaps this post will help you.

Perspective Tree

I have a SQL table and used to populate a tree view in vision (for sake of this question I entered bogus data): [treeVision] Query: SELECT a.id, `number` AS `text`, `number` AS `selectedText`, `name` AS `path` FROM tdssql.joblist a INNER JOIN jobcustomer b ON a.custid = b.id WHERE `name` LIKE '%{Root Container.txtlistJobsFilter.text}%' or `number` LIKE '%{Root Container.txtlistJobsFilter.text}%' SQL table: [JobSQL] In vision it was simple, but for the life of me I can’t seem to grasp the …