Description of problem: When using the Date Created field in a report it is reflecting UTC instead of the settings for the user like the UI shows in the report tree (see screenshot) Version-Release number of selected component (if applicable): 5.9.2.4 How reproducible: Always Steps to Reproduce: 1. Change timezone under My Settings 2. Create a report with the date created field 3. Run report Actual results: Reports tree shows report ran with EDT In the report view the date created field shows UTC Expected results: Date created should match Timezone settings within the appliance Additional info: Timezone has been set in the Configuration and My Settings sections of the UI
Ryan, We should be using the User's timezone found in the users table, settings column in the display => timezone section {:display => {:timezone => XXX}} This is what should be displayed in the UI for the user's display settings. It looks like it's falling back to the UTC. Do you have an environment where this is happening? Is the data in the report in the correct timezone or are you saying the metadata about the report is showing the incorrect timezone for when the report was run? I'd like to take a look because I'm not sure what happening here.
I've was looking at this bug and do have environment
PR: https://github.com/ManageIQ/manageiq/pull/18438
New commit detected on ManageIQ/manageiq/master: https://github.com/ManageIQ/manageiq/commit/8753ecf2c0d4f067dda35c9d4b9d54a2f309a185 commit 8753ecf2c0d4f067dda35c9d4b9d54a2f309a185 Author: Yuri Rudman <yrudman> AuthorDate: Wed Feb 6 13:18:21 2019 -0500 Commit: Yuri Rudman <yrudman> CommitDate: Wed Feb 6 13:18:21 2019 -0500 Fixed: Timezone set-up in MySettings was not honored when displaying date fields in the report. Fixes https://bugzilla.redhat.com/show_bug.cgi?id=1599849 app/models/miq_report/generator/html.rb | 10 +- 1 file changed, 5 insertions(+), 5 deletions(-)
FIXED. Verified on 5.11.0.7.
*** Bug 1759776 has been marked as a duplicate of this bug. ***
The needinfo request[s] on this closed bug have been removed as they have been unresolved for 500 days