We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

How to apply time_zone setting to drill through view / flat form?

Answered
uchivoitachi asked on February 8, 2022

Hello Team,
 
We're using Flexmonster + Elasticsearch, recently we have encountered issues related to time_zone setting:
 
date string in Elastisearch: "2000-05-19T05:05:00.000+0000"
Flexmonster mapping(we expect to see the datetime without time zone offset,e.g. 19/05/2000 05:05:00):

mapping: {
            type: "date string",
            caption: "ETB",
            format: "dd/MM/yyyy HH:mm:ss",
            time_zone: "+00:00"
        }

 
Flexmonster pivot view: 19/05/2000 05:05:00 --(Correct)
Flexmonster drill through view:19/05/2000 13:05:00 --Note this is after time zone offset(GMT+8) --(Incorrect)
 
Flexmonster flat form: same as drill through view
 
Here is the question: how to keep the time zone setting of pivot/drill though/flat form consistent?In this case the pivot view is correct,but others are not.
 
thanks a lot!

4 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster February 8, 2022

Hello, Uchivoitachi,
 
Thank you for reporting the described behavior and providing us with the screenshots.
 
We will research possible solutions for this issue and provide you with results ETA March 7.
 
You are welcome to write to us in case further questions arise.
 
Kind regards,
Nadia

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster March 9, 2022

Hello, Uchivoitachi,
 
We are pleased to inform you that the issue with dateTimezoneOffset property not applicable for drill-through when using Elasticsearch was fixed.
 
This is available in the 2.9.20 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-20/
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/ 
 
Please let us know if any questions arise.
 
Kind regards,
Nadia

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster March 16, 2022

Hello, Uchivoitachi,
 
Hope you are doing well.
 
Could you please confirm if the fix works well for you?
 
Looking forward to hearing your feedback.
 
Kind regards,
Nadia

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster March 28, 2022

Hello, Uchivoitachi,
 
Hope you are doing well.
 
We were wondering if you had a chance to test the fix. Could you please confirm if the dateTimezoneOffset property works well for you?
 
We will be glad to hear your feedback.
 
Kind regards,
Nadia

Please login or Register to Submit Answer