Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0006885 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 02. Master data management | minor | have not tried | 2009-01-14 15:24 | 2009-02-27 06:19 | |||
| Reporter | AinhoaPagola | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.50beta | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 13448 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.5 | |||
| OS Version | Ubuntu 8.4 | Database version | 8.3 | Ant version | 1.7 | |||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0006885: Location selector sets the whole address to null if no Region is choosen in Pgsql | |||||||
| Description | In the Location selector if a region is not selected the whole location/address is set to null although there can be data in the other fields. | |||||||
| Steps To Reproduce | Go to Master Data Management || Business Partner Go to Location/Address tab. Click in the icon of the location/address to enter a location. In the pop-up fill all the fields except for the Region. You wont be able to do that with Spain as country. A country with no regions available must be choosen, for example Saint Lucia. Click Ok and verify that the address is set to null. Please notice that if you save it you can see it This does not happen with Oracle. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0013304) AinhoaPagola (viewer) 2009-02-10 13:21 |
The problem is that the sql_record_identifier created for c_location table is not correct. select tablename, sql_record_identifier from ad_table where tablename = 'C_Location'; It is actually: "SELECT TO_CHAR(COALESCE(TO_CHAR(T.Address1),''))||' - '|| TO_CHAR(COALESCE(TO_CHAR(T.Address2),''))||' - '|| TO_CHAR(COALESCE(TO_CHAR(T.Postal),''))||' - '|| TO_CHAR(COALESCE(TO_CHAR(T.City),''))||' - '|| (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_Region TT WHERE TT.C_Region_ID=T.C_Region_ID) ||' - '|| (SELECT (SELECT COALESCE(TO_CHAR(MAX(TTT.Name)), TO_CHAR(TT.Name)) FROM C_Country_Trl TTT WHERE TTT.C_Country_ID=TT.C_Country_ID AND TTT.AD_LANGUAGE=L.AD_LANGUAGE) FROM C_Country TT WHERE TT.C_Country_ID=T.C_Country_ID) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, C_Location T WHERE C_Location_ID=':c_ID'" The region "part" should be something like this: ||' - '|| (SELECT COALESCE((SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_Region TT WHERE TT.C_Region_ID=T.C_Region_ID),'')) ||' - '|| |
|
(0013815) svnbot (viewer) 2009-02-20 11:42 |
Repository: openbravo Revision: 13448 Author: alostale Date: 2009-02-20 11:42:23 +0100 (Fri, 20 Feb 2009) fixed bug 0006885: Location selector sets the whole address to null if no Region is choosen in Pgsql --- U trunk/src-db/database/model/functions/AD_COLUMN_IDENTIFIER_REF_SQL.xml U trunk/src-db/database/model/functions/C_CHK_OPEN_PERIOD.xml U trunk/src-db/database/sourcedata/AD_MESSAGE.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=13448&sc=1 [^] |
|
(0014121) sureshbabu (viewer) 2009-02-27 06:19 |
Retested in context 79.125.56.185/openbravotrunk |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-01-14 15:24 | AinhoaPagola | New Issue | |
| 2009-01-14 15:24 | AinhoaPagola | Assigned To | => AinhoaPagola |
| 2009-01-14 15:24 | AinhoaPagola | sf_bug_id | 0 => 2507131 |
| 2009-01-14 15:24 | AinhoaPagola | OBNetwork customer | => No |
| 2009-01-14 15:24 | AinhoaPagola | Regression testing | => No |
| 2009-01-19 10:59 | psarobe | Proposed Solution updated | |
| 2009-01-19 10:59 | psarobe | Status | new => scheduled |
| 2009-01-19 10:59 | psarobe | fix_in_branch | => trunk |
| 2009-01-28 17:07 | AinhoaPagola | Assigned To | AinhoaPagola => gmauleon |
| 2009-02-10 13:21 | AinhoaPagola | Note Added: 0013304 | |
| 2009-02-10 13:21 | AinhoaPagola | fix_in_branch | trunk => |
| 2009-02-10 13:21 | AinhoaPagola | Steps to Reproduce Updated | |
| 2009-02-10 13:22 | AinhoaPagola | Assigned To | gmauleon => alostale |
| 2009-02-20 11:42 | svnbot | Checkin | |
| 2009-02-20 11:42 | svnbot | Note Added: 0013815 | |
| 2009-02-20 11:42 | svnbot | Status | scheduled => resolved |
| 2009-02-20 11:42 | svnbot | Resolution | open => fixed |
| 2009-02-20 11:42 | svnbot | svn_revision | => 13448 |
| 2009-02-24 12:53 | psarobe | Relationship added | has duplicate 0007598 |
| 2009-02-27 06:19 | sureshbabu | Status | resolved => closed |
| 2009-02-27 06:19 | sureshbabu | Note Added: 0014121 | |
| 2009-02-27 06:19 | sureshbabu | Fixed in Version | => trunk |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |