Prospective table component - Render-date-datetime

Hey there everyone,
This is Shubham. i am from india
Regarding this post, I needed your help to resolve the issue of timestamps in the Prospective Table component (I have tried the online solution (set render to date, then set format to datetime), and it's not working).

still the datetime column is in integer (it's showing numbers instead of date)

Please suggest something to correct this.

Regards,
shubham

Hi Shubham,
Can you share more details? How are you getting your data exactly? What it its raw value? Can you show us your table props, especially the datetime part?

1 Like

Make sure that you have set the field property in each column to match the name of the database column. It's case sensitive. In your case it would be something like,
columns.1.field : DateTime
Many of the column features don't work if you don't specify the field property correctly.

Note that that DATETIME is a keyword in SQL so it's not a good name for a data column.

Tips:

  • It's Perspective as in "a point of view", not Prospective as in "likely to happen at a future date". You can edit your post to fix the title and the post with the pencil icon below the post.
  • The Keep it Tidy section of the forum FAQ - Inductive Automation Forum requests that we don't add signatures to posts as your username is automatically displayed. If you want to introduce yourself or state your location, etc., then add that to your user profile.

It worked "columns.1.field: DateTime."
but to make it happen, i have to delete all the columns from the property editor and add one by one with propper naming same as column names in SQL

It would have worked by naming them one by one. You can test this very quickly to see how it works by dropping a table component onto a view and setting the field property for each column in turn.

  • city
  • country
  • population

You can also set each columns.x.header.title to read nicely without underscores or to be different words or language.

1 Like