# Perspective table questions

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-questions/29237>\
**Category:** Ignition\
**Created:** [October 21, 2019, 11:09am UTC](https://forum.inductiveautomation.com/t/perspective-table-questions/29237 "2019-10-21T11:09:31Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![winbetho](https://avatars.discourse-cdn.com/v4/letter/w/ac91a4/32.png) [@winbetho](https://forum.inductiveautomation.com/u/winbetho)\
**Post date:** [October 21, 2019, 11:09am UTC](https://forum.inductiveautomation.com/t/perspective-table-questions/29237/1 "2019-10-21T11:09:31Z")

</div>

Hi!

I just started to learn Perspective so I took a SQL query I used before in another Ignition page, converted it to a named query and tested it in a table. It works but how do i change the columns header? And how do I change the format so I get the date in format ‘2019-10-21 12:00:00’?

---

<div class="post-metadata">

**Author:** ![jonathan.taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jonathan.taylor/32/4048_2.png) [@jonathan.taylor](https://forum.inductiveautomation.com/u/jonathan.taylor)\
**Post date:** [October 21, 2019, 11:58am UTC](https://forum.inductiveautomation.com/t/perspective-table-questions/29237/2 "2019-10-21T11:58:15Z")

</div>

This post will help you a lot:

> [@\[Feedback\] NEW Perspective Table](http://forum.inductiveautomation.com/t/feedback-new-perspective-table/21199):
>
> The new Perspective table component is here, and it’s loaded with tons of exciting features. These features include multiple headers and footers, expandable subviews, single and multi sort, frozen columns and rows, editability, selection, filtering, pagination, and much more. We are opening this discussion for any feedback you may have regarding the table component, questions, and feature requests. We’d love to hear what you think, so let us know! Below is an overview of the table component …

Also, you could change the column header without doing anything in the table by adjusting the named query:

> SELECT tableColumn AS newHeader FROM table

---

<div class="post-metadata">

**Author:** ![winbetho](https://avatars.discourse-cdn.com/v4/letter/w/ac91a4/32.png) [@winbetho](https://forum.inductiveautomation.com/u/winbetho)\
**Post date:** [October 21, 2019, 1:34pm UTC](https://forum.inductiveautomation.com/t/perspective-table-questions/29237/3 "2019-10-21T13:34:46Z")

</div>

I would like to see how it is done by properies, I tried to change add columns and then change the header.title but it wont change.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4c89fd14d4d881bd6060afbd2405e75e1a61ea2b.png)

---

<div class="post-metadata">

**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:** [October 21, 2019, 1:51pm UTC](https://forum.inductiveautomation.com/t/perspective-table-questions/29237/4 "2019-10-21T13:51:29Z")

</div>

You need to set the `field` property in that column object to the appropriate column in your table’s data. The mapping of column definitions to data definitions is strictly key:value - `columns[1]` does not “know” it needs to be associated with `data[1]`, because you might be hiding certain fields or want to rearrange your data structure.

---

<div class="post-metadata">

**Author:** ![winbetho](https://avatars.discourse-cdn.com/v4/letter/w/ac91a4/32.png) [@winbetho](https://forum.inductiveautomation.com/u/winbetho)\
**Post date:** [October 21, 2019, 2:21pm UTC](https://forum.inductiveautomation.com/t/perspective-table-questions/29237/5 "2019-10-21T14:21:13Z")

</div>

Ok. Got it! Thanks!

---

<div class="post-metadata">

**Author:** ![william.ivey](https://avatars.discourse-cdn.com/v4/letter/w/aca169/32.png) [@william.ivey](https://forum.inductiveautomation.com/u/william.ivey)\
**Post date:** [July 14, 2020, 2:45pm UTC](https://forum.inductiveautomation.com/t/perspective-table-questions/29237/6 "2020-07-14T14:45:54Z")

</div>

I am seeing very slow performance with Perspective tables using large datasets (using named queries). I was under the impression that the paging feature would help with a faster loading than what I am seeing. A dataset with \> 20,000 records really makes the Perspective view slow to a crawl.

Any thoughts or ideas on how to improve performance with this in mind?