0018002: Table with multiple references to product table - No key found in parent tab

Openbravo Issue Tracking System - Openbravo ERP
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0018002	Openbravo ERP	00. Application dictionary	public	2011-07-15 14:26	2022-02-01 08:08

Reporter	neil_smith
Assigned To	Triage Platform Base
Priority	high	Severity	major	Reproducibility	always
Status	acknowledged	Resolution	open
Platform		OS	5	OS Version
Product Version	3.0MP0
Target Version		Fixed in Version
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
Modules	Core
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency Pack	No

Summary	0018002: Table with multiple references to product table - No key found in parent tab
Description	I have a table in a module that has 2 references to the product table, M_Product_Abo_ID and M_Product_Cover_ID. In version 3, when creating the tab, there is no way to specify which column is linked to parent column. I want to link M_Product_Cover_ID to M_Product.M_Product_ID in one tab. But I will also want another tab that links M_Product_Abo_ID to M_Product.M_Product_ID. When I compile the window, I get an error [java] 632 [main] INFO org.openbravo.wad.Wad - Processing Window: Product - Tab: Product - id: 180 [java] 2511 [main] INFO org.openbravo.wad.Wad - Processing Window: Product - Tab: Abonnement - id: 700AB46775064E43ACB4EB1AA4A7B7B1 [java] 2703 [main] WARN org.openbravo.wad.Wad - No key found in parent tab: Product My tab simply doesn't work, I thought it would display all the sons, without regard to the selected product. But no, it doesn't display anything! I found out that it automaticaly linked the M_Product_Abo_ID column to the M_Product.M_Product_ID column when I put an HQL where clause, because I made a mistake and it displayed the where clause: Error Exception when creating query select e from dfabo_abo as e where ( (( e.productAbo.id = :alias_0 )) and (e.productCoverId = :alias_1 ) ) and e.organization.id in ('0', 'FF8081813119C14E01311D5A52090592') and e.client.id in ('FF8081813119C14E01311D42D59203AF', '0')order by e.documentNo I corrected my HQL where clause (e.productCover.id), and of course, it still didn't work... So I tried to put the same product in the 2 fields and then it worked... I really don't know what to do so that it works right... Note that the ID of the M_Product_Abo_ID field is smaller than the m_Product_Cover_ID, that's probably why it takes it...
Steps To Reproduce	1) Create a new table with 2 references to the same table, but none using the same name as the key in the referenced table (M_Product_Abo_ID and M_Product_Cover_ID). - The M_Product_Abo_ID is reference 'Search' and reference search key 'Product Complete'. - The M_Product_Cover_ID is reference 'Table' and reference search key 'M_Product (no summary). 2) Add a tab to the product window and try to link the M_Product_Cover_ID field to the M_Product.M_Product_ID field... If your solution works, try linking the M_Product_Abo_ID field to the M_Product.M_Product_ID. I suspect that it takes the column with the smallest ID to do the link.
Proposed Solution	Isn't it possible to select the column in the table that we want to link to the key in the parent column
Additional Information
Tags	No tags attached.
Relationships
Attached Files

Issue History
Date Modified	Username	Field	Change
2011-07-15 14:26	neil_smith	New Issue
2011-07-15 14:26	neil_smith	Assigned To	=> alostale
2011-07-15 14:26	neil_smith	Modules	=> Core
2011-09-19 23:35	psarobe	Status	new => scheduled
2012-03-08 08:21	alostale	Type	defect => design defect
2017-03-31 14:36	alostale	Status	scheduled => acknowledged
2017-04-10 14:34	alostale	Assigned To	alostale => platform
2022-02-01 08:08	alostale	Assigned To	platform => Triage Platform Base

There are no notes attached to this issue.