Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0044682
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 01. General setupmajoralways2020-07-20 14:362020-07-27 10:30
Reportera_singhView Statuspublic 
Assigned Tocberner 
PriorityimmediateResolutionfixedFixed in VersionPR20Q2.1
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget VersionPR20Q2.1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0PR19Q4.4SCM revision 
Review Assigned Toalostale
Web browserGoogle Chrome
ModulesCore
Regression levelProduction - Confirmed Stable
Regression date2019-09-23
Regression introduced in release3.0PR19Q4
Regression introduced by commithttps://gitlab.com/openbravo/product/openbravo/-/commit/4ec715bfa9c6bc0ab7b3e6f644ec05ef4998c721 [^]
Triggers an Emergency PackNo
Summary

0044682: Exported grid csv with enabled creation date column value does not match in the application

DescriptionIn 19Q4.4, despite the preference Local Timezone ID defined, when the user tries to export any of the window grid with enabled Creation Date column.The creation date value exported in the csv file does not matches in the grid.
Steps To ReproduceFollowing steps to be followed:

1. Log in the backoffice as Openbravo/openbravo

2. Go to the Preference window
   a.Preference Property: Local Timezone ID
   b.Property List: Yes
   c.Selected: No
   d.Value: America/New_York

3. From any window grid, enable the Creation Date column and click on the Export to csv toolbar button.

4. The expected value is Creation Date value should be in US Eastern Time Zone but the value is in UTC timezone.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0044640 closedcberner Exported grid csv with enabled creation date column value does not match in the application 

-  Notes
(0121615)
hgbot (developer)
2020-07-27 10:19

Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/110 [^]
(0121619)
hgbot (developer)
2020-07-27 10:30

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 7ae21d01832182cb995772e51fd5a7caab8360e0
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 2020-07-27T10:17:30+02:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/7ae21d01832182cb995772e51fd5a7caab8360e0 [^]

Fixes ISSUE-44682: Sets correct DateTime in window grid exported CSV file

DateTime in export to CSV was wrong, applying local time zone several times instead of once.

It has been fixed by using a function that doesn't try to transform to
UTC in DateTimeUIDefinition, convertToClassicStringInLocalTime. This
function formats the date as is, using the timezone received without
prior conversion to UTC.

fixes regression introduced in commit
4ec715bfa9c6bc0ab7b3e6f644ec05ef4998c721

---
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/DateTimeUIDefinition.java
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DataSourceServlet.java
---
(0121620)
hgbot (developer)
2020-07-27 10:30

Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/110 [^]

- Issue History
Date Modified Username Field Change
2020-07-24 11:19 cberner Type defect => backport
2020-07-24 11:19 cberner Target Version => PR20Q2.2
2020-07-27 10:11 cberner Web browser Google Chrome => Google Chrome
2020-07-27 10:11 cberner Target Version PR20Q2.2 => PR20Q2.1
2020-07-27 10:19 hgbot Note Added: 0121615
2020-07-27 10:25 cberner Review Assigned To => alostale
2020-07-27 10:25 cberner Web browser Google Chrome => Google Chrome
2020-07-27 10:30 hgbot Resolution open => fixed
2020-07-27 10:30 hgbot Status scheduled => closed
2020-07-27 10:30 hgbot Fixed in Version => PR20Q2.1
2020-07-27 10:30 hgbot Note Added: 0121619
2020-07-27 10:30 hgbot Note Added: 0121620


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker