Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004071Openbravo ERP09. Financial managementpublic2008-06-19 12:422008-08-21 18:56
psarobe 
cromero 
highmajoralways
closedfixed 
10XP
2.40alpha-r3 
2.40pi 
No
Core
No
0004071: Not able to see the values inside a combo. Just in postgres
When 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
1. 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
No tags attached.
Issue History
2008-06-19 12:42psarobeNew Issue
2008-06-19 12:42psarobeAssigned To => cromero
2008-06-19 12:42psarobesf_bug_id0 => 1997686
2008-06-19 12:42psarobeOBNetwork customer => No
2008-06-19 12:45psarobeStatusnew => scheduled
2008-06-20 11:04svnbotCheckin
2008-06-20 11:04svnbotNote Added: 0007898
2008-06-20 11:04svnbotStatusscheduled => resolved
2008-06-20 11:04svnbotResolutionopen => fixed
2008-06-20 11:04svnbotsvn_revision => 5236
2008-08-21 18:56psarobeRegression testing => No
2008-08-21 18:56psarobeStatusresolved => closed
2008-08-21 18:56psarobeFixed in Version => trunk

Notes
(0007898)
svnbot   
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 [^]