Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022354Openbravo ERPA. Platformpublic2012-11-20 14:012012-11-27 11:14
Reportereduardo_Argal 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP18 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022354: Default values in columns are not working properly for Date type references
DescriptionWhen defining a column of reference type date and adding a default value, system can not properly format default value and it results into a strange date.
Steps To ReproduceGo to GLJournal table and define the following default value for datedoc column:
@SQL=SELECT COALESCE((SELECT ENDDATE FROM C_PERIOD WHERE C_PERIOD_ID = @C_PERIOD_ID@),to_date(@DateDoc@)) FROM DUAL

go to GL Journal window and in header create a new record. Mind that document date gets a really strange date.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-11-20 14:01eduardo_ArgalNew Issue
2012-11-20 14:01eduardo_ArgalAssigned To => eduardo_Argal
2012-11-20 14:01eduardo_ArgalModules => Core
2012-11-20 14:01eduardo_ArgalOBNetwork customer => No
2012-11-21 08:34marvintmStatusnew => acknowledged
2012-11-21 08:34marvintmStatusacknowledged => scheduled
2012-11-21 08:34marvintmfix_in_branch => pi
2012-11-21 08:34marvintmAssigned Toeduardo_Argal => marvintm
2012-11-21 08:35marvintmReview Assigned To => AugustoMauch
2012-11-21 08:35marvintmfix_in_branchpi =>
2012-11-21 08:35hgbotCheckin
2012-11-21 08:35hgbotNote Added: 0054408
2012-11-21 08:35hgbotStatusscheduled => resolved
2012-11-21 08:35hgbotResolutionopen => fixed
2012-11-21 08:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7006f95b06fda6487b61b2339491027ddd14b199 [^]
2012-11-21 19:58hudsonbotCheckin
2012-11-21 19:58hudsonbotNote Added: 0054439
2012-11-27 11:14AugustoMauchNote Added: 0054517
2012-11-27 11:14AugustoMauchStatusresolved => closed
2012-11-27 11:14AugustoMauchFixed in Version => 3.0MP18

Notes
(0054408)
hgbot   
2012-11-21 08:35   
Repository: erp/devel/pi
Changeset: 7006f95b06fda6487b61b2339491027ddd14b199
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Nov 21 08:35:17 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7006f95b06fda6487b61b2339491027ddd14b199 [^]

Fixed issue 22354. Date default values will work on generated windows.

---
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/DateUIDefinition.java
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/UIDefinition.java
---
(0054439)
hudsonbot   
2012-11-21 19:58   
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/368bcd7fb0a0 [^]

Maturity status: Test
(0054517)
AugustoMauch   
2012-11-27 11:14   
Code reviewed and verified in pi@b43e48d603a9