Setting t_stamp format for dynamic dataset in perspective tables

Hello,
Data for my perspective table is being served from the database through a script with a number of conditions to make table interaction dynamic. Users can choose which columns to have on the table and deselect them at will. Time stamp is one of the columns that can either be selected or deselected. My problem is that the timestamp is not being displayed in a datetime format. The most common solution that I've seen in the forum is setting the field for the time column; the problem is that my columns are not static.
Is there another way for setting the formats for the timestamps?


I believe the simplest solution would be to format the Timestamp column as a string bind to the data property.

Consider moving the table's data binding to a custom property, then dynamically generating both props.data and props.columns using the column names and types from the dataset. (I would use my Integration Toolkit expression functions to do this without scripting overhead.)

1 Like