Date not showing hour/minute/second in fields selection

Answered
Ivan Petrovic asked on June 21, 2018

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.
 

5 answers

Public
Iryna Kulchytska Iryna Kulchytska Flexmonster June 21, 2018

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

Public
Ivan Petrovic June 21, 2018

Hi,
Yes I am using your data compressor and not json or csv.
Thanks

Public
Iryna Kulchytska Iryna Kulchytska Flexmonster June 21, 2018

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

Public
Ivan Petrovic June 26, 2018

Hi,
Unfortunately this does not solve our issue/need.
I will trying a couple a things and repost if needed.
 
Thanks
 
Ivan
 
 

Public
Ivan Petrovic June 26, 2018

Hi,
All is good I ended separating the date and the time in 2 filters.
Thanks.
 
Best,
 
Ivan
 

Please login or Register to Submit Answer