Hi,
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.
Hi Ivan,
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/managing-data-presentation-json) or "ds+"
prefix if you return CSV (https://www.flexmonster.com/doc/managing-data-presentation-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.
Kind regards,
Iryna
Hi,
Yes I am using your data compressor and not json or csv.
Thanks
Ivan,
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.
Kind regards,
Iryna
Hi,
Unfortunately this does not solve our issue/need.
I will trying a couple a things and repost if needed.
Thanks
Ivan
Hi,
All is good I ended separating the date and the time in 2 filters.
Thanks.
Best,
Ivan