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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0006885
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementminorhave not tried2009-01-14 15:242009-02-27 06:19
ReporterAinhoaPagolaView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version2.50beta
StatusclosedFix in branchFixed in SCM revision13448
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 8.4Database version8.3Ant version1.7
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0006885: Location selector sets the whole address to null if no Region is choosen in Pgsql

DescriptionIn 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 ReproduceGo 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.
 

TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0006976 closedalostale Location selector sets the whole address to null if no Region is choosen in Pgsql 
has duplicate defect 0007598 closedrafaroda Location field do not show the address if Region is set blank 

-  Notes
(0013304)
AinhoaPagola (reporter)
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 (reporter)
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 (reporter)
2009-02-27 06:19

 Retested in context 79.125.56.185/openbravotrunk

- 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 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker