# Using Tree View to display SQL Tags for use in Easy Chart **URL:** \ **Category:** Ignition\ **Created:** [May 3, 2012, 5:36am UTC](https://forum.inductiveautomation.com/t/using-tree-view-to-display-sql-tags-for-use-in-easy-chart/4405 "2012-05-03T05:36:04Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![cgele](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cgele/32/3453_2.png) [@cgele](https://forum.inductiveautomation.com/u/cgele)\ **Post date:** [May 3, 2012, 5:36am UTC](https://forum.inductiveautomation.com/t/using-tree-view-to-display-sql-tags-for-use-in-easy-chart/4405/1 "2012-05-03T05:36:04Z")
I would like to use the tree view to display certain SQL tags that I have created which could then be selected and used by the Easy Chart? Kind of like how the Tag Search Window works. Suggestions? ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [May 3, 2012, 3:44pm UTC](https://forum.inductiveautomation.com/t/using-tree-view-to-display-sql-tags-for-use-in-easy-chart/4405/2 "2012-05-03T15:44:55Z")
Ask and you shall receive. I have attached a small example of how to do this. You need Ignition 7.4.2 to import it. [Demo\_Easy Chart Example\_2012-05-03\_0843.proj](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/7e3965495cd69564b95ed7406f305c4f14bcc6b1.proj) (19.5 KB) ---
**Author:** ![cgele](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cgele/32/3453_2.png) [@cgele](https://forum.inductiveautomation.com/u/cgele)\ **Post date:** [May 3, 2012, 6:47pm UTC](https://forum.inductiveautomation.com/t/using-tree-view-to-display-sql-tags-for-use-in-easy-chart/4405/3 "2012-05-03T18:47:28Z")
This works great! I do have one question. How was the dataset for the Tree View created? Do we have access to the SQL commands that the Tag Search window uses? I’d like to use this function to build the tree view dataset. ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [May 3, 2012, 11:17pm UTC](https://forum.inductiveautomation.com/t/using-tree-view-to-display-sql-tags-for-use-in-easy-chart/4405/4 "2012-05-03T23:17:53Z")
I just statically defined the dataset. You can bind it to a SQL query if you want. ---
**Author:** ![cgele](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cgele/32/3453_2.png) [@cgele](https://forum.inductiveautomation.com/u/cgele)\ **Post date:** [May 4, 2012, 1:26am UTC](https://forum.inductiveautomation.com/t/using-tree-view-to-display-sql-tags-for-use-in-easy-chart/4405/5 "2012-05-04T01:26:33Z")
I’ll work on that. Thanks for all your help. ---
**Author:** ![mokam](https://avatars.discourse-cdn.com/v4/letter/m/34f0e0/32.png) [@mokam](https://forum.inductiveautomation.com/u/mokam)\ **Post date:** [January 4, 2018, 12:32am UTC](https://forum.inductiveautomation.com/t/using-tree-view-to-display-sql-tags-for-use-in-easy-chart/4405/6 "2018-01-04T00:32:04Z")
Hi, Is it possible to get the new link for this file. Thanks. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 4, 2018, 4:01pm UTC](https://forum.inductiveautomation.com/t/using-tree-view-to-display-sql-tags-for-use-in-easy-chart/4405/7 "2018-01-04T16:01:39Z")
The file from 7.4 probably isn’t going to do you much good. The technique covered there has been supplanted by the “Tag Browse Tree” component, which supports dragging and dropping directly to the easy chart: [https://inductiveuniversity.com/video/ad-hoc-charting?7.9](https://inductiveuniversity.com/video/ad-hoc-charting?7.9) ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [January 4, 2018, 4:23pm UTC](https://forum.inductiveautomation.com/t/using-tree-view-to-display-sql-tags-for-use-in-easy-chart/4405/8 "2018-01-04T16:23:41Z")
Paul is correct. We have a new template that uses the Tag Browse Tree in our Cloud Templates repository. You can access the Cloud Templates in the designer under tools menu. The template is called “AdHoc Trend”.