Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026457Openbravo ERPZ. Otherspublic2014-05-05 16:192014-11-07 15:46
Reporterngarcia 
Assigned ToAugustoMauch 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q4Fixed in Version3.0PR14Q4 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customerOBPS
Web browser
ModulesQuery/List widget
Support ticket28324
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026457: Invoices to pay widget shows incorrect Date when the system is in a previous time zone
DescriptionInvoices to pay widget shows incorrect Date when the system is in a previous time zone
Steps To ReproduceAccess the application from a machine with a timezone previous to the timezone of the machine where the application is running
As group admin role:
   Add the Invoices to pay widget in the workspace
   Check that the date shown is one day before the invoice date
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0027501 closed AugustoMauch Time and DateTime fields are not converted to the local timezone in Query/List Widgets 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-05-05 16:19ngarciaNew Issue
2014-05-05 16:19ngarciaAssigned To => jonalegriaesarte
2014-05-05 16:19ngarciaModules => Query/List widget
2014-05-05 16:19ngarciaOBNetwork customer => Yes
2014-05-05 16:19ngarciaSupport ticket => 28324
2014-05-05 16:19ngarciaResolution time => 1405634400
2014-05-05 16:19ngarciaTriggers an Emergency Pack => No
2014-05-05 16:20ngarciaIssue Monitored: networkb
2014-05-19 14:33jonalegriaesarteAssigned Tojonalegriaesarte => pramakrishnan
2014-06-16 12:48jonalegriaesarteTarget VersionPR14Q3 => PR14Q4
2014-07-30 08:53AtulOpenbravoAssigned Topramakrishnan => AtulOpenbravo
2014-07-30 08:53AtulOpenbravoStatusnew => scheduled
2014-07-30 08:53AtulOpenbravofix_in_branch => pi
2014-07-30 10:59ngarciafix_in_branchpi =>
2014-07-30 10:59ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=6216#r6216
2014-08-26 11:55AtulOpenbravoAssigned ToAtulOpenbravo => AugustoMauch
2014-08-28 07:57shankarbAssigned ToAugustoMauch => shankarb
2014-08-28 18:12AugustoMauchRelationship addedrelated to 0027501
2014-08-28 18:12AugustoMauchAssigned Toshankarb => AugustoMauch
2014-08-28 18:35AugustoMauchIssue Monitored: shankarb
2014-08-28 18:35AugustoMauchReview Assigned To => shankarb
2014-08-28 18:37hgbotCheckin
2014-08-28 18:37hgbotNote Added: 0069847
2014-08-28 18:37hgbotStatusscheduled => resolved
2014-08-28 18:37hgbotResolutionopen => fixed
2014-08-28 18:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/65b98d7a5bf570f1f26ff96fc3c25fd3323644b4 [^]
2014-08-28 18:39AugustoMauchNote Added: 0069848
2014-08-29 15:53hudsonbotCheckin
2014-08-29 15:53hudsonbotNote Added: 0069860
2014-09-01 05:59shankarbNote Added: 0069872
2014-09-01 05:59shankarbStatusresolved => closed
2014-09-01 05:59shankarbFixed in Version => 3.0PR14Q4
2014-11-07 15:46eugeniIssue Monitored: eugeni

Notes
(0069847)
hgbot   
2014-08-28 18:37   
Repository: erp/devel/pi
Changeset: 65b98d7a5bf570f1f26ff96fc3c25fd3323644b4
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Fri Aug 29 01:35:03 2014 +0900
URL: http://code.openbravo.com/erp/devel/pi/rev/65b98d7a5bf570f1f26ff96fc3c25fd3323644b4 [^]

Fixes issue 26457: Date columns not properly displayed in query/list widgets

The problem was that all date columns were being stored internally as DateTime column, so they were being treated as such and were being converted to the local timezone. As these dates at a time of 00:00:00, if the client whose timezone < the timezone of the server, the datetime shown was the previous one.

To fix this, Date columns are not sent as proper dates, instead of as DateTimes. This way the date columns will show the same value in all clients, regardless of their time zones.

---
M modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListDataSource.java
---
(0069848)
AugustoMauch   
2014-08-28 18:39   
Test plan:
- Apart from checking that the original issue is not reproducible, check that dateTime parameters are shown properly. To test this you can follow the steps to reproduce this issue: https://issues.openbravo.com/view.php?id=27501 [^]
(0069860)
hudsonbot   
2014-08-29 15:53   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/af520c9729b9 [^]
Maturity status: Test
(0069872)
shankarb   
2014-09-01 05:59   
Code reviewed and verified in pi changeset 611572b5205f