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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0004071
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2008-06-19 12:422008-08-21 18:56
ReporterpsarobeView Statuspublic 
Assigned Tocromero 
PriorityhighResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision5236
ProjectionnoneETAnoneTarget Version2.40
OSWindowsDatabasePostgreSQLJava version
OS VersionXPDatabase version8.2Ant version
Product Version2.40alpha-r3SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0004071: Not able to see the values inside a combo. Just in postgres

DescriptionWhen an identifier is empty PostgreSQL doesn't use the coalesce function and you cannot see the rest of the identifiers. For example:

Identifiers: Name of the bank - Account of the bank
If the account of the bank is empty the combo box Bank should show: Name of the bank -
But what it shows you is null.
In oracle works fine
Steps To Reproduce1. Go to financial management->Receivables and payables->Setup->Bank
2. Select an existing bank->Move to bank account tab.
3. Notice the Displayed Account is null (this only happens if the bank was created before 2.40)
4. Go to transactions folder and click bankstatement
5. Click new. Notice the bank combo does not show anything
6. Go back to setup->Bank. Select the same bank and move to bank account bank
7. Mark show spanish and save. Note the Displayed Account is filled
8. go back again to bankstatement and click new. Notice that now the bank combo is filled
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0007898)
svnbot (viewer)
2008-06-20 11:04

Repository: openbravo
Revision: 5236
Author: cromeroherrero
Date: 2008-06-20 11:04:01 +0200 (Fri, 20 Jun 2008)

Fixed bug 4071: Not able to see the values inside a combo. Just in postgres
Modified the ComboTableData class in order to inserrt a necessary COALESCE for PostgreSQL
Also modified the view AD_TABLE_POST_V in the same way.

---
U trunk/src/org/openbravo/erpCommon/utility/ComboTableData.java
U trunk/src-db/database/model/views/AD_TABLE_POST_V.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=5236&sc=1 [^]

- Issue History
Date Modified Username Field Change
2008-06-19 12:42 psarobe New Issue
2008-06-19 12:42 psarobe Assigned To => cromero
2008-06-19 12:42 psarobe sf_bug_id 0 => 1997686
2008-06-19 12:42 psarobe OBNetwork customer => No
2008-06-19 12:45 psarobe Status new => scheduled
2008-06-20 11:04 svnbot Checkin
2008-06-20 11:04 svnbot Note Added: 0007898
2008-06-20 11:04 svnbot Status scheduled => resolved
2008-06-20 11:04 svnbot Resolution open => fixed
2008-06-20 11:04 svnbot svn_revision => 5236
2008-08-21 18:56 psarobe Regression testing => No
2008-08-21 18:56 psarobe Status resolved => closed
2008-08-21 18:56 psarobe Fixed in Version => trunk


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker