# Best way to display SQL query as a "table"

**URL:** <https://forum.inductiveautomation.com/t/best-way-to-display-sql-query-as-a-table/63419>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [August 24, 2022, 8:13pm UTC](https://forum.inductiveautomation.com/t/best-way-to-display-sql-query-as-a-table/63419 "2022-08-24T20:13:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![I\_Rock\_Well](https://avatars.discourse-cdn.com/v4/letter/i/7c8e57/32.png) [@I\_Rock\_Well](https://forum.inductiveautomation.com/u/I_Rock_Well)\
**Post date:** [August 24, 2022, 8:13pm UTC](https://forum.inductiveautomation.com/t/best-way-to-display-sql-query-as-a-table/63419/1 "2022-08-24T20:13:17Z")

</div>

Complete Perspective (and Ignition noob AND database noob here).

I have a working named query that I want to display in perspective. The dataset has an unknown number of rows, and includes a timestamp of which I do need the date and the time including seconds.

I started creating a table component, but am now wondering if I am overcomplicating it. Could I simply use a label, and transform the data somehow? Or is there another way?

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [August 24, 2022, 8:18pm UTC](https://forum.inductiveautomation.com/t/best-way-to-display-sql-query-as-a-table/63419/2 "2022-08-24T20:18:42Z")

</div>

Usually, tables are used to display query data. Bind the table’s data property to the named query. Check out [Inductive University](https://www.inductiveuniversity.com) for free training if you haven’t already.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/a/fab5ec592db3f133a64726300cc65016e0363b00.png)

---

<div class="post-metadata">

**Author:** ![I\_Rock\_Well](https://avatars.discourse-cdn.com/v4/letter/i/7c8e57/32.png) [@I\_Rock\_Well](https://forum.inductiveautomation.com/u/I_Rock_Well)\
**Post date:** [August 25, 2022, 1:36pm UTC](https://forum.inductiveautomation.com/t/best-way-to-display-sql-query-as-a-table/63419/3 "2022-08-25T13:36:22Z")

</div>

Thanks! My disconnect was that I did my binding for each individual component of the data property 🤪

All good now and I realize I am stupid and not Perspective.