Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0022354
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorsometimes2012-11-20 14:012012-11-27 11:14
Reportereduardo_ArgalView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in Version3.0MP18
StatusclosedFix in branchFixed in SCM revision7006f95b06fd
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0022354: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0054408)
hgbot (developer)
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 (viewer)
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 (administrator)
2012-11-27 11:14

 Code reviewed and verified in pi@b43e48d603a9

- Issue History
Date Modified Username Field Change
2012-11-20 14:01 eduardo_Argal New Issue
2012-11-20 14:01 eduardo_Argal Assigned To => eduardo_Argal
2012-11-20 14:01 eduardo_Argal Modules => Core
2012-11-20 14:01 eduardo_Argal OBNetwork customer => No
2012-11-21 08:34 marvintm Status new => acknowledged
2012-11-21 08:34 marvintm Status acknowledged => scheduled
2012-11-21 08:34 marvintm fix_in_branch => pi
2012-11-21 08:34 marvintm Assigned To eduardo_Argal => marvintm
2012-11-21 08:35 marvintm Review Assigned To => AugustoMauch
2012-11-21 08:35 marvintm fix_in_branch pi =>
2012-11-21 08:35 hgbot Checkin
2012-11-21 08:35 hgbot Note Added: 0054408
2012-11-21 08:35 hgbot Status scheduled => resolved
2012-11-21 08:35 hgbot Resolution open => fixed
2012-11-21 08:35 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7006f95b06fda6487b61b2339491027ddd14b199 [^]
2012-11-21 19:58 hudsonbot Checkin
2012-11-21 19:58 hudsonbot Note Added: 0054439
2012-11-27 11:14 AugustoMauch Note Added: 0054517
2012-11-27 11:14 AugustoMauch Status resolved => closed
2012-11-27 11:14 AugustoMauch Fixed in Version => 3.0MP18

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker