0028436: Web services does not convert the date, time and datetime columns to the timezone of the client when returning the results

Description

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.

Steps To Reproduce

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

Proposed Solution

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.

Tags

No tags attached.

Attached Files

wsData.txt [^] (127 bytes) 2014-12-17 11:45 [Show Content] [Hide Content]

{ 
  data : {
    "entityName":"Product",
    "id":"8A64B71A2B0B2946012B0BC437F60116",
    "weight":9,
    "active":true
  }
}

Relationships [ Relation Graph ] [ Dependency Graph ]

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

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2014-12-17 11:44	caristu	New Issue
2014-12-17 11:44	caristu	Assigned To	=> AugustoMauch
2014-12-17 11:44	caristu	Modules	=> Core
2014-12-17 11:44	caristu	Triggers an Emergency Pack	=> No
2014-12-17 11:44	caristu	Relationship added	related to 0022022
2014-12-17 11:46	caristu	File Added: wsData.txt