Project:
| View Revisions: Issue #37467 | [ All Revisions ] [ 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: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 |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |