0037467: subtab in "Purchasing Plan" with a tableDir FK to header fails

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #37467		[ Back to Issue ]
Summary	0037467: subtab in "Purchasing Plan" with a tableDir FK to header fails

Revision	2017-12-14 10:30 by alostale
Steps To Reproduce	1. Install attached module which: - Adds a new table with a MRP_Run_Purchase_ID column being a FK to MRP_Run_Purchase with TableDir referece - Adds a new "Test" tab to "Purchasing Plan" window with that table 2. Open "Purchasing Plan" window 3. Create a record 4. Click on new in Test tab -> ERRORS: * Parent record is not selected in child one * An error can be see in logs: 595dbc4c 330110 [http-bio-8080-exec-1] ERROR org.openbravo.erpCommon.utility.ComboTableData - Error in query SELECT td0.MRP_Run_Purchase_ID AS ID, (COALESCE(TO_CHAR(COALESCE(TO_CHAR(td0.Name),'')),'') \|\| ' - ' \|\| COALESCE(TO_CHAR(COALESCE(TO_CHAR(td1.Name),'')),'') \|\| ' - ' \|\| COALESCE(TO_CHAR(COALESCE(TO_CHAR(td2.Name),'')),'') \|\| ' - ' \|\| COALESCE(TO_CHAR((CASE WHEN td_trl4.Name IS NULL THEN COALESCE(TO_CHAR(td3.Name),'') ELSE COALESCE(TO_CHAR(td_trl4.Name),'') END)),'') \|\| ' - ' \|\| COALESCE(TO_CHAR((CASE WHEN td_trl6.Name IS NULL THEN COALESCE(TO_CHAR(td5.Name),'') ELSE COALESCE(TO_CHAR(td_trl6.Name),'') END)),'') \|\| ' - ' \|\| COALESCE(TO_CHAR(COALESCE(TO_CHAR(td7.Name),'')),'')) AS NAME, '' AS DESCRIPTION FROM MRP_Run_Purchase td0 left join MRP_Planner td1 on td0.MRP_Planner_ID = td1.MRP_Planner_ID AND td1.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td1.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') left join C_BPartner td2 on td0.Vendor_ID = td2.Vendor_ID AND td2.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td2.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') left join M_Product_Category td3 on td0.M_Product_Category_ID = td3.M_Product_Category_ID AND td3.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td3.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') left join M_Product_Category_Trl td_trl4 on td3.M_Product_Category_ID = td_trl4.M_Product_Category_ID AND td_trl4.AD_Language = ? left join M_Product td5 on td0.M_Product_ID = td5.M_Product_ID AND td5.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td5.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') left join M_Product_Trl td_trl6 on td5.M_Product_ID = td_trl6.M_Product_ID AND td_trl6.AD_Language = ? left join C_BPartner td7 on td0.C_BPartner_ID = td7.C_BPartner_ID AND td7.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td7.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') WHERE td0.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td0.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') AND (td0.isActive = 'Y' OR td0.MRP_Run_Purchase_ID = (?) ) AND td0.MRP_Run_Purchase_ID=(?) ORDER BY 2, 2, 2, 2, 2, 2 org.postgresql.util.PSQLException: ERROR: column td2.vendor_id does not exist Position: 950

Revision	2017-12-14 10:30 by alostale
Description	When adding a child tab in "Purchasing Plan", with a FK to MRP_Run_Purchase set as "link to parent column" with TableDir reference. It is not possible to add/edit records in that new tab.

Revision	2017-12-14 10:26 by alostale
Steps To Reproduce	1. Create a table with column MRP_Run_Purchase_ID as foreign key. 2. Define the table in AD with MRP_Run_Purchase_ID as "link to parent column" and TableDir reference. 3. Create a child tab on "Purchasing Plan" window. 4. Compile. 5. Open the new tab on grid view. 6. Add some data. 7. Open the form view. 8. See the openbravo.log

Revision	2017-12-14 10:26 by alostale
Description	When adding adding child tab in "Purchasing Plan", if "link to parent column" (MRP_Run_Purchase_ID) is defined as TableDir reference, it generates an error when child tab form view is selected.