Hello everyone,
I am new here, I am having problems with the display of Date Type data in the perspective tables, the rendering does not work for me. Does anyone have an idea what I'm doing wrong?
I am reading the data from the alarm database and displaying it in a table... attached image.
Thank you.
Where does the data come from ?
This looks like alarm events, are you using the system.alarm.* functions ?
If you go back to the Dataset Editor and use the Copy to clipboard button, what is the type of the eventtime column? It needs to be L (long) and not str.
For example:
"#NAMES"
"City","Population","Timezone","GMTOffset","TimeStamp"
"#TYPES"
"str","I","str","I","L"
"#ROWS","5"
"New York","8363710","EST","-5","1712910740411"
"Los Angeles", ...
I'm wondering if this is an SQLite issue and you might need to get a grow-up's database.
Actually, I've just remembered, you can check the datatype by clicking a cell in the Dataset editor.
Brain slow today: Notice that Dataset Editor is showing all the numeric columns right-justified but eventtime is left justified. I think it's a string.
Good stuff. There's a "Solution" link below my post. If you hit that it will help future readers / searchers. Thanks.
