Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012967Openbravo ERP00. Application dictionarypublic2010-04-14 10:292010-06-15 14:03
Reporternetworkb 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP14 
Target Version2.50MP17Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012967: The hour in a column defined as datetime is not saved properly
DescriptionThe hour in a column defined as datetime is not saved properly
Steps To Reproduce    -Create new module, check it as indevelopment and add a prefix
-Add a new column in the c_bpartner table to save a datetime value
ALTER TABLE c_bpartner ADD COLUMN em_prefix_fechacaducidad timestamp without time zone;
-Add this new column in the application dictionary in the c_bpartner table check
datetime value as reference
-Add this new column as a new field in the header of the partner window.
-Create a template an set is as indevelopment
-Change the definition of the c_bpartner table unchecking the highvolen checkbox.
-Compile the windows and restart tomcat
-Go the the window an fill the new field with a date with tame
-Save it: see that the time is saved with 00:00:00 instead of the time selected
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0010264 closed alostale The datetime reference on column definition window does not work 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-04-14 10:29networkbNew Issue
2010-04-14 10:29networkbAssigned To => alostale
2010-04-14 10:43networkbRelationship addedrelated to 0010264
2010-04-14 10:43networkbTarget Version2.50MP15 => 2.50MP16
2010-04-19 08:30alostaleStatusnew => scheduled
2010-04-19 08:30alostalefix_in_branch => pi
2010-04-22 16:48alostalefix_in_branchpi =>
2010-04-22 16:50alostaleNote Added: 0026582
2010-04-22 17:47hgbotCheckin
2010-04-22 17:47hgbotNote Added: 0026585
2010-04-22 17:47hgbotStatusscheduled => resolved
2010-04-22 17:47hgbotResolutionopen => fixed
2010-04-22 17:47hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6b7c616d7412d814444ac6929221d6ff31a4cf3b [^]
2010-05-03 16:59sureshbabuNote Added: 0026877
2010-05-03 16:59sureshbabuStatusresolved => closed
2010-05-04 00:00anonymoussf_bug_id0 => 2996191
2010-05-11 18:19jpabloaeTarget Version2.50MP16 => 2.50MP17
2010-05-14 15:27hudsonbotCheckin
2010-05-14 15:27hudsonbotNote Added: 0027273
2010-06-04 14:44hgbotCheckin
2010-06-04 14:44hgbotNote Added: 0027966
2010-06-04 14:44hgbotStatusclosed => resolved
2010-06-04 14:44hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/6b7c616d7412d814444ac6929221d6ff31a4cf3b [^] => http://code.openbravo.com/erp/devel/pi/rev/4b269365308019b88e8133e8cf3d1268fc877676 [^]
2010-06-07 21:20hudsonbotCheckin
2010-06-07 21:20hudsonbotNote Added: 0028088
2010-06-07 23:43hudsonbotCheckin
2010-06-07 23:43hudsonbotNote Added: 0028130
2010-06-15 14:03jpabloaeStatusresolved => closed

Notes
(0026582)
alostale   
2010-04-22 16:50   
This issue affects to PostgreSQL but to to Oracle.

The problem is that for inserting/updating date time references, to_date(date, format) function is used. It is correct in Oracle, but in PostgreSQL it returns a date without time.

Proposed solution: use to_timestamp which should work in both databases.
(0026585)
hgbot   
2010-04-22 17:47   
Repository: erp/devel/pi
Changeset: 6b7c616d7412d814444ac6929221d6ff31a4cf3b
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Apr 22 17:04:38 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6b7c616d7412d814444ac6929221d6ff31a4cf3b [^]

fixed bug 12967: The hour in a column defined as datetime is not saved properly

---
M src-wad/src/org/openbravo/wad/Wad.java
---
(0026877)
sureshbabu   
2010-05-03 16:59   
Tested now its working fine
(0027273)
hudsonbot   
2010-05-14 15:27   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/6b7c616d7412 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/36f76c8d7193 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17198.obx [^]
(0027966)
hgbot   
2010-06-04 14:44   
Repository: erp/devel/pi
Changeset: 4b269365308019b88e8133e8cf3d1268fc877676
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Apr 22 17:04:38 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4b269365308019b88e8133e8cf3d1268fc877676 [^]

fixed bug 12967: The hour in a column defined as datetime is not saved properly

---
M src-wad/src/org/openbravo/wad/Wad.java
---
(0028088)
hudsonbot   
2010-06-07 21:20   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/4b2693653080 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/8b43a1f2fff4 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17563.obx [^]
(0028130)
hudsonbot   
2010-06-07 23:43   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/4b2693653080 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/8b43a1f2fff4 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17563.obx [^]