Named Query Table Date Time Column

Ignition
1

I am returning date and time in a named query to a perspective table:

named query result set:
image

but the column data displays something like this:
image

Any idea how to fix this?

2

In the table's columns property, configure that column to render dates. Under the hood, Ignition datetime values are UTC milliseconds, and since JSON doesn't have that, they are transmitted as long integers. Ignition's components (most of them) understand how to deal with them, but for some components, they need a cue. (You might actually want to display 64-bit integers in a table.)

3

I configured it as date column but I still get the same result

image
image1371×573 97.4 KB

4

ok resolved, I had to provide the field name i.e. column name:

image

image
image862×416 27.8 KB

2 Likes
5

Yes, that is required for every column in columns for reliable behavior.