Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0002153 | Openbravo ERP | 04. Warehouse management | public | 2007-10-24 19:08 | 2008-06-20 17:49 |
| Reporter | user71 | ||||
| Assigned To | cromero | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | 2.40alpha-r3 | |||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | No | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0002153: Error SELECT in Rpt_Etiquetas_data.xsql | ||||
| Description | My instalation: Openbravo 2.34 Oracle There is an error in SELECT clause in the file Rpt_Etiquetas_data.xsql Where is the next SELECT SELECT M_PRODUCT.M_PRODUCT_ID AS ID, COALESCE(M_PRODUCT_CUSTOMER.NAME, M_PRODUCT.NAME) AS NAME, COALESCE(M_PRODUCT_CUSTOMER.DESCRIPTION, M_PRODUCT.DESCRIPTION) AS DESCRIPTION, COALESCE(M_PRODUCT_CUSTOMER.UPC, M_PRODUCT.UPC) AS UPC, '' AS LOT, '' AS GUARANTEEDATE FROM M_PRODUCT LEFT JOIN M_PRODUCT_CUSTOMER on M_PRODUCT.M_PRODUCT_ID = M_PRODUCT_CUSTOMER.M_PRODUCT_ID WHERE M_PRODUCT.M_PRODUCT_ID = ? AND M_PRODUCT_CUSTOMER.C_BPARTNER_ID = ? must be the another one: SELECT M_PRODUCT.M_PRODUCT_ID AS ID, COALESCE(M_PRODUCT_CUSTOMER.NAME, M_PRODUCT.NAME) AS NAME, COALESCE(M_PRODUCT_CUSTOMER.DESCRIPTION, M_PRODUCT.DESCRIPTION) AS DESCRIPTION, COALESCE(M_PRODUCT_CUSTOMER.UPC, M_PRODUCT.UPC) AS UPC, '' AS LOT, '' AS GUARANTEEDATE FROM M_PRODUCT LEFT JOIN M_PRODUCT_CUSTOMER on M_PRODUCT.M_PRODUCT_ID = M_PRODUCT_CUSTOMER.M_PRODUCT_ID AND M_PRODUCT_CUSTOMER.C_BPARTNER_ID = ? WHERE M_PRODUCT.M_PRODUCT_ID = ? ("AND M_PRODUCT_CUSTOMER.C_BPARTNER_ID = ?" must be in the JOIN and not in the WHERE) because if not exists the data in M_PRODUCT_CUSTOMER for the product al customer selected, it doesn't give any record | ||||
| Steps To Reproduce | |||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2008-06-20 17:49 | plujan | Status | resolved => closed | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||