Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036205Openbravo ERPA. Platformpublic2017-06-08 13:362017-06-09 14:01
Reportercaristu 
Assigned Tocaristu 
PrioritylowSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q3 
Merge Request Status
Review Assigned Toinigosanchez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0036205: Error fired after selecting the CalloutClass in the Linked Items section of the Callout window
DescriptionThe following error appears in the UI after selecting the CalloutClass in the Linked Items section of the Callout window:

@CODE=0@ERROR: column reference "action" is ambigous Position: 641

And the following exception is raised in the console:

 SELECT (AD_Model_Object.AD_Model_Object_ID) AS ID, (AD_COLUMN_IDENTIFIER(?,TO_CHAR(AD_Model_Object.AD_Model_Object_ID),?)) AS NAME, tab1.AD_TAB_ID AS AD_TAB_ID, tab1.AD_WINDOW_ID AS AD_WINDOW_ID, table1.NAME AS TABLENAME, menu1.NAME AS AD_MENU_NAME, tab1.UIPATTERN FROM AD_Model_Object LEFT OUTER JOIN AD_TAB tab1 ON (tab1.AD_TAB_ID = ?) LEFT OUTER JOIN AD_TABLE table1 ON (tab1.AD_TABLE_ID = table1.AD_TABLE_ID) LEFT OUTER JOIN AD_MENU menu1 ON (menu1.AD_WINDOW_ID = tab1.AD_WINDOW_ID) WHERE AD_Model_Object.AD_Callout_ID = ? AND 1=1 AND Action='C' AND EXISTS (SELECT 1 FROM AD_Callout WHERE AD_Callout.AD_Callout_ID = AD_Model_Object.AD_Callout_ID) AND AD_Model_Object.AD_ORG_ID IN ('0') AND AD_Model_Object.AD_CLIENT_ID IN ('0') ORDER BY 2Exception:org.postgresql.util.PSQLException: ERROR: column reference "action" is ambiguous


Steps To Reproduce1) As system administrator, go to the Callout window
2) Open any callout in form view, and display the Linked Items section
3) Click on the "Callout Class" link
Proposed SolutionThe Linked Items feature makes use of the sql where clause defined in the tab. Fix the where clause of the Callout Class: use "AD_Model_Object.Action='C'" instead of "Action='C'"
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0033305 new Triage Platform Base Linked Items do not take into account HQL where clause 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-06-08 13:36caristuNew Issue
2017-06-08 13:36caristuAssigned To => caristu
2017-06-08 13:36caristuModules => Core
2017-06-08 13:36caristuTriggers an Emergency Pack => No
2017-06-08 13:38caristuRelationship addedrelated to 0033305
2017-06-08 13:51hgbotCheckin
2017-06-08 13:51hgbotNote Added: 0097220
2017-06-08 13:51hgbotStatusnew => resolved
2017-06-08 13:51hgbotResolutionopen => fixed
2017-06-08 13:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e1cdf33211c8428fe81a759ffb8e165c9b114b88 [^]
2017-06-08 13:51caristuReview Assigned To => inigosanchez
2017-06-09 02:49hudsonbotCheckin
2017-06-09 02:49hudsonbotNote Added: 0097262
2017-06-09 14:01inigosanchezNote Added: 0097289
2017-06-09 14:01inigosanchezStatusresolved => closed
2017-06-09 14:01inigosanchezFixed in Version => 3.0PR17Q3

Notes
(0097220)
hgbot   
2017-06-08 13:51   
Repository: erp/devel/pi
Changeset: e1cdf33211c8428fe81a759ffb8e165c9b114b88
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Thu Jun 08 13:50:16 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e1cdf33211c8428fe81a759ffb8e165c9b114b88 [^]

fixed bug 36205: Linked Items referencing Callout Class were not working

Update the SQL where clause of the Callout Class sub tab to avoid the unambiguous reference to the action column

---
M src-db/database/sourcedata/AD_TAB.xml
---
(0097262)
hudsonbot   
2017-06-09 02:49   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/682983c2eead [^]
Maturity status: Test
(0097289)
inigosanchez   
2017-06-09 14:01   
Code review and tested in pi@d5b16e274d2c