Best way to display SQL query as a "table"

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.

Usually, tables are used to display query data. Bind the table’s data property to the named query. Check out Inductive University for free training if you haven’t already.


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

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

1 Like