# Dynamically populating Menu Tree from database table

**URL:** <https://forum.inductiveautomation.com/t/dynamically-populating-menu-tree-from-database-table/43573>\
**Category:** Ignition Early Access\
**Tags:** ignition80, database, scripting, perspective\
**Created:** [February 18, 2021, 4:23pm UTC](https://forum.inductiveautomation.com/t/dynamically-populating-menu-tree-from-database-table/43573 "2021-02-18T16:23:22Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [February 19, 2021, 4:03pm UTC](https://forum.inductiveautomation.com/t/dynamically-populating-menu-tree-from-database-table/43573/2 "2021-02-19T16:03:57Z")

</div>

Perhaps this post will help you.

> [@Perspective Tree](http://forum.inductiveautomation.com/t/perspective-tree/38504):
>
> 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 …

---

_[View the full topic](https://forum.inductiveautomation.com/t/dynamically-populating-menu-tree-from-database-table/43573)._