0005352: Malformed ORDER BY clause in some reports - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0005352	Openbravo ERP	07. Sales management	public	2008-10-01 10:29	2008-12-13 20:30

Reporter	rafaroda
Assigned To	Hennadzi
Priority	low	Severity	trivial	Reproducibility	always
Status	closed	Resolution	fixed
Platform		OS	20	OS Version	Ubuntu 7.10
Product Version	pi
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	0005352: Malformed ORDER BY clause in some reports
Description	The following reports (Java files) form a malformed ORDER BY clause: 1) ReportDimensionalAnalysesPDF.java 2) ReportInvoiceCustomerDimensionalAnalyses.java 3) ReportInvoiceCustomerDimensionalAnalysesJR.java 4) ReportInvoiceCustomerDimensionalPDF.java 5) ReportInvoiceVendorDimensionalAnalysesJR.java 6) ReportMaterialDimensionalAnalysesJR.java 7) ReportPurchaseDimensionalAnalysesJR.java 8) ReportRefundInvoiceCustomerDimensionalAnalyses.java 9) ReportRefundSalesDimensionalAnalyses.java 10) ReportRefundSalesDimensionalAnalysesPDF.java 11) ReportSalesDimensionalAnalyzeJR.java 12) ReportSalesOrderDimensionalPDF.java 13) ReportShipmentDimensionalAnalyzeJR.java
Steps To Reproduce	For 11) ReportSalesDimensionalAnalyzeJR.java: * Put a break point in the line 'String strHaving = "";' in order to evaluate 'strOrderby' variable at this point. * Go to 'Sales Management \|\| Analysis Tools \|\| Sales Dimensional Report': A1) Select 1 dimension (Product) and 'Standard' check-box: strOrderby = ORDER BY NIVEL1 (Correct) B1) Select 1 dimension (Product) and 'By Ascending Amount' check-box: strOrderby = ORDER BY AMOUNT ASC (Correct) C1) Select 1 dimension (Product) and 'By Descending Amount' check-box: strOrderby = ORDER BY AMOUNT DESC (Correct) A2) Select 2 dimensions (Product Group and Product) and 'Standard' check-box: strOrderby = ORDER BY NIVEL1,NIVEL1,NIVEL2 (Wrong: NIVEL1 is repeated) B2) Select 2 dimensions (Product Group and Product) and 'By Ascending Amount' check-box: strOrderby = ORDER BY NIVEL1,NIVEL1,AMOUNT ASC (Wrong: NIVEL1 is repeated) C2) Select 2 dimensions (Product Group and Product) and 'By Descending Amount' check-box: strOrderby = ORDER BY NIVEL1,NIVEL1,AMOUNT DESC (Wrong: NIVEL1 is repeated) Since the only problem here is that the SQL is malformed (the report does not crash and the data are shown correctly) this defect will not be backported.
Proposed Solution	Patch attached for ReportSalesDimensionalAnalyzeJR.java.
Additional Information
Tags	No tags attached.
Relationships
Attached Files	patch-ReportSalesDimensionalAnalyzeJR.diff (754) 2008-10-01 10:29 https://issues.openbravo.com/file_download.php?file_id=299&type=bug

Issue History
Date Modified	Username	Field	Change
2008-10-01 10:29	rafaroda	New Issue
2008-10-01 10:29	rafaroda	Assigned To	=> Hennadzi
2008-10-01 10:29	rafaroda	sf_bug_id	0 => 2139916
2008-10-01 10:29	rafaroda	File Added: patch-ReportSalesDimensionalAnalyzeJR.diff
2008-10-01 10:29	rafaroda	Regression testing	=> No
2008-10-01 10:29	rafaroda	Status	new => scheduled
2008-10-01 10:29	rafaroda	fix_in_branch	=> trunk
2008-10-01 12:58	svnbot	Checkin
2008-10-01 12:58	svnbot	Note Added: 0009299
2008-10-01 12:58	svnbot	Status	scheduled => resolved
2008-10-01 12:58	svnbot	Resolution	open => fixed
2008-10-01 12:58	svnbot	svn_revision	=> 8120
2008-12-13 20:30	psarobe	Status	resolved => closed

Notes