My datasource is mysql and I am using the latest version of Flexmonster.
I have a column post_date (timestamp in mysql) that is not showing hours/minutes/seconds in flexmonster.
I would like to at least be able to select and filter by hour.
I already added datePattern: “yyyy-MM-dd HH:mm:ss” in the config.
Thank you for posting your question on the forum.
It is really nice that you already added
datePattern: "yyyy-MM-dd HH:mm:ss" in the config.
In order to have a column
post_date showing hours/minutes/seconds in flexmonster, a proper type for the column
post_date should be specified in JSON or CSV data that you return to the flexmonster component. I suppose it should be
"date string" type if you return JSON (https://www.flexmonster.com/doc/data-types-in-json/) or
"ds+" prefix if you return CSV (https://www.flexmonster.com/doc/data-types-in-csv/).
Could you please let me know if you use our compression tool on the back end – Flexmonster Data Compressor? You can find more details about it in the documentation https://www.flexmonster.com/doc/connecting-to-relational-database/.
Your answer will help me provide you with more specific recommendations.
Yes I am using your data compressor and not json or csv.
Thank you for your answer.
The recommendation would be setting the Flexmonster data types prefix
"ds+" explicitly via SQL query alias. Here is the example:
"SELECT segment as 'Segment', post_date as 'ds+Post Date' FROM customers"
Please let me know if it works for you.
Unfortunately this does not solve our issue/need.
I will trying a couple a things and repost if needed.
All is good I ended separating the date and the time in 2 filters.