# Populate Tree View with SQL Query

**URL:** <https://forum.inductiveautomation.com/t/populate-tree-view-with-sql-query/12443>\
**Category:** Ignition\
**Created:** [December 8, 2016, 4:28am UTC](https://forum.inductiveautomation.com/t/populate-tree-view-with-sql-query/12443 "2016-12-08T04:28:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bfaivre](https://avatars.discourse-cdn.com/v4/letter/b/f19dbf/32.png) [@bfaivre](https://forum.inductiveautomation.com/u/bfaivre)\
**Post date:** [December 8, 2016, 4:28am UTC](https://forum.inductiveautomation.com/t/populate-tree-view-with-sql-query/12443/1 "2016-12-08T04:28:20Z")

</div>

Hello,

I’m looking for an example of this subject. I’d like to dynamically populate a Tree View component using a SQL query. Can someone please point me in the right direction of an example?

Thanks in advance!

Brian

---

<div class="post-metadata">

**Author:** ![bfaivre](https://avatars.discourse-cdn.com/v4/letter/b/f19dbf/32.png) [@bfaivre](https://forum.inductiveautomation.com/u/bfaivre)\
**Post date:** [December 9, 2016, 3:30pm UTC](https://forum.inductiveautomation.com/t/populate-tree-view-with-sql-query/12443/2 "2016-12-09T15:30:54Z")

</div>

Realized that my SQL Query that I bind to the Tree View’s Items property just needs to have the columns named like a Tree View would expect - for example, “path”, “text”, “selectedText”, etc.

---

<div class="post-metadata">

**Author:** ![ramkumar.r2](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@ramkumar.r2](https://forum.inductiveautomation.com/u/ramkumar.r2)\
**Post date:** [July 14, 2020, 1:34pm UTC](https://forum.inductiveautomation.com/t/populate-tree-view-with-sql-query/12443/3 "2020-07-14T13:34:53Z")

</div>

Hello there bfaivre. Were you able to solve this? if so, could you please let me know how you were able to do it?