0003949: ad_column_identifier don't work in c_location with locations without region selected

Description

In this locations, function returns null.

The problem is in function ad_column_identifier_ref_sql because it return wrong sql.
The sql returned is :
SELECT COALESCE(TO_CHAR(T.Address1), ' ')||' - '||
       COALESCE(TO_CHAR(T.Address2), ' ')||' - '||
       COALESCE(TO_CHAR(T.Postal), ' ')||' - '||
       COALESCE(TO_CHAR(T.City), ' ')||' - '||
       (SELECT 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) ||' - '||
      COALESCE(TO_CHAR(T.IsActive), ' ') AS COLUMN_IDENTIFIER
FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE='es_ES') L, C_Location T
WHERE C_Location_Id=:c_ID

A example of correct sql is:
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),''))||' - '||
CASE WHEN (SELECT COALESCE(TO_CHAR(TT.Name), ' ')
           FROM C_Region TT WHERE TT.C_Region_ID=T.C_Region_ID)
     IS NULL THEN
           ' '
     ELSE (SELECT COALESCE(TO_CHAR(TT.Name), ' ')
            FROM C_Region TT WHERE TT.C_Region_ID=T.C_Region_ID) END ||' - ' || (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)
||' - '||TO_CHAR(COALESCE(TO_CHAR(T.IsActive),'')) 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

Tags

No tags attached.

Attached Files

Wad.java [^] (174,140 bytes) 2008-06-17 08:53

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on

backport

0004018

closed

cromero

ad_column_identifier don't work in c_location with locations without region selected

Notes
(0007724) psarobe (manager) 2008-06-16 10:43	As a workaround and better solution it exists several stored functions (c_location_name, c_location_description, c_location_identifier)

(0007747) cromero (reporter) 2008-06-16 19:02	Reminder sent to: malsasua Could you attach the wad.java final file ?

(0007757) malsasua (developer) 2008-06-17 08:55	done. thanks

(0007797) cromero (reporter) 2008-06-17 14:18	This functionality works perfectly in the trunk, but not in the 2.3x branch. A backport has been created for it.

Issue History
Date Modified	Username	Field	Change
2008-06-12 17:01	malsasua	New Issue
2008-06-12 17:01	malsasua	Assigned To	=> cromero
2008-06-16 10:43	psarobe	Status	new => scheduled
2008-06-16 10:43	psarobe	Note Added: 0007724
2008-06-16 19:02	cromero	Note Added: 0007747
2008-06-17 08:53	malsasua	File Added: Wad.java
2008-06-17 08:55	malsasua	Note Added: 0007757
2008-06-17 13:47	cromero	Target Version	=> 2.40
2008-06-17 13:47	cromero	Status	scheduled => feedback
2008-06-17 13:47	cromero	Status	feedback => scheduled
2008-06-17 14:18	cromero	Status	scheduled => closed
2008-06-17 14:18	cromero	Note Added: 0007797
2008-06-17 14:18	cromero	Resolution	open => out of date
2008-07-01 17:56	anonymous	sf_bug_id	0 => 2007951