Best way to display SQL query as a "table"

Ignition
1

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.

2

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.

image
image1130×779 51 KB

4 Likes
3

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