Bug 1758549 - [RFE] date and time field always shown in UTC time in reports
Summary: [RFE] date and time field always shown in UTC time in reports
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Reporting
Version: 5.10.10
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: GA
: 5.10.z
Assignee: drew uhlmann
QA Contact: Parthvi Vala
Red Hat CloudForms Documentation
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2019-10-04 13:38 UTC by Rahul Chincholkar
Modified: 2020-03-20 18:58 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2020-03-20 18:58:57 UTC
Category: Feature
Cloudforms Team: CFME Core
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)
Report1-UTC.png (128.69 KB, image/png)
2019-10-04 13:39 UTC, Rahul Chincholkar
no flags Details
Report2-UTC.pdf (28.42 KB, application/pdf)
2019-10-04 13:40 UTC, Rahul Chincholkar
no flags Details
Report3.CSV.pdf (343 bytes, text/plain)
2019-10-04 13:41 UTC, Rahul Chincholkar
no flags Details

Description Rahul Chincholkar 2019-10-04 13:38:27 UTC
Description of problem:
Reports created always shows the UTC time for `date and time` fields in a report.

Note: Appliance Time Zone is set to "(GMT+5:30) Kolkata" in 'Configuration'

- See screenshot `Report1-UTC.png` which shows the `Date Created` field in UTC.
- Downloaded PDF report and shows UTC time in the report. (See attachment, Report2-UTC.pdf)
- Downloaded CSV report and shows IST time in the report. (See attachment, Report3.CSV.pdf)

Version-Release number of selected component (if applicable):
5.10.10.0

How reproducible:
Always

Steps to Reproduce:
1. Set Appliance time zone to your timezone in appliance Configuration other than UTC
2. Create a report including `date and time` fields
3. Queue and download PDF and CSV format of the same reports.
4. Notice the timezone different in the downloaded reports.

Actual results:
Report fields are using UTC timezone

Expected results:
Reports should show the timezone configured in "Appliance Time Zone"

Comment 2 Rahul Chincholkar 2019-10-04 13:39:41 UTC
Created attachment 1622555 [details]
Report1-UTC.png

Comment 3 Rahul Chincholkar 2019-10-04 13:40:25 UTC
Created attachment 1622556 [details]
Report2-UTC.pdf

Comment 4 Rahul Chincholkar 2019-10-04 13:41:29 UTC
Created attachment 1622557 [details]
Report3.CSV.pdf

Comment 13 drew uhlmann 2019-11-06 13:55:42 UTC
I think this works, I think it was fixed in 
https://github.com/ManageIQ/manageiq/pull/19285 and https://github.com/ManageIQ/manageiq/pull/18438


Note You need to log in before you can comment on or make changes to this bug.