Perspective table questions

[winbetho]

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’?

[jonathan.taylor]

This post will help you a lot:

[Feedback] NEW Perspective Table

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

[winbetho]

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.

[PGriffith]

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.

[winbetho]

Ok. Got it! Thanks!

[william.ivey]

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?