0036205: Error fired after selecting the CalloutClass in the Linked Items section of the Callout window

Description

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

1) 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 Solution

The 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'"

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

design defect

0033305

new

Triage Platform Base

Linked Items do not take into account HQL where clause

Notes
(0097220) hgbot (developer) 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 (developer) 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 (developer) 2017-06-09 14:01	Code review and tested in pi@d5b16e274d2c

Issue History
Date Modified	Username	Field	Change
2017-06-08 13:36	caristu	New Issue
2017-06-08 13:36	caristu	Assigned To	=> caristu
2017-06-08 13:36	caristu	Modules	=> Core
2017-06-08 13:36	caristu	Triggers an Emergency Pack	=> No
2017-06-08 13:38	caristu	Relationship added	related to 0033305
2017-06-08 13:51	hgbot	Checkin
2017-06-08 13:51	hgbot	Note Added: 0097220
2017-06-08 13:51	hgbot	Status	new => resolved
2017-06-08 13:51	hgbot	Resolution	open => fixed
2017-06-08 13:51	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/e1cdf33211c8428fe81a759ffb8e165c9b114b88 [^]
2017-06-08 13:51	caristu	Review Assigned To	=> inigosanchez
2017-06-09 02:49	hudsonbot	Checkin
2017-06-09 02:49	hudsonbot	Note Added: 0097262
2017-06-09 14:01	inigosanchez	Note Added: 0097289
2017-06-09 14:01	inigosanchez	Status	resolved => closed
2017-06-09 14:01	inigosanchez	Fixed in Version	=> 3.0PR17Q3