Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0028436Openbravo ERPA. Platformpublic2014-12-17 11:442014-12-17 11:45
caristu 
AugustoMauch 
urgentmajoralways
newopen 
5
3.0PR14Q3 
 
Core
No
0028436: Web services does not convert the date, time and datetime columns to the timezone of the client when returning the results
Web services does not convert the date, time and datetime columns to the timezone of the client where they are executed.
When saving data on the application, the date is saved with converted to the timezone of the server. This date is converted to the timezone of the client when accessing to the data on the application.

When receiving the result of a web service call, the behavior is different, the date is not converted and is received with the timezone of the client.
1) Having the client in a different timezone of the server, make an update trough web services, for example using the following: http://<server_address>/openbravo/org.openbravo.service.json.jsonrest/Product [^]

  with the attached data

2) Notice that the web service return the "updated" field with the server timezone
A possible solution could be to include a param in the web service call, to specify the client timezone. The date, time and datetime values will be returned converted with that timezone.
No tags attached.
related to design defect 0022022 new AugustoMauch The reports does not convert the date, time and datetime columns to the timezone of the client where they are executed 
txt wsData.txt (127) 2014-12-17 11:45
https://issues.openbravo.com/file_download.php?file_id=7605&type=bug
Issue History
2014-12-17 11:44caristuNew Issue
2014-12-17 11:44caristuAssigned To => AugustoMauch
2014-12-17 11:44caristuModules => Core
2014-12-17 11:44caristuTriggers an Emergency Pack => No
2014-12-17 11:44caristuRelationship addedrelated to 0022022
2014-12-17 11:46caristuFile Added: wsData.txt

There are no notes attached to this issue.