Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032201Openbravo ERPA. Platformpublic2016-02-11 11:412016-02-25 15:08
ReporterAtulOpenbravo 
Assigned Toplatform 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032201: Unnescessary performance penalty while sorting and filtering column of HQL Datasources used in P&E windows
DescriptionIn case of sort or filter applied in foreign key column of HQL Datasource used in P&E window raises unnecessary performance penalty and that affects all the P&E windows. In "Return To Vendor" or "Return From Customer" window when sorting / filtering Return Reason column separate left clauses needs to be implemented in order to handle both ID and first IDENTIFIER column from the entity, filter by id and sort by first identifier column.
Steps To ReproduceIn case of sort or filter applied in foreign key column of HQL Datasource used in P&E window raises unnecessary performance penalty and that affects all the P&E windows.In "Return To Vendor" or "Return From Customer" window when sorting / filtering Return Reason column separate left clauses needs to be implemented in order to handle both ID and first IDENTIFIER column from the entity, filter by id and sort by first identifier column.
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0032157 closed AtulOpenbravo Not possible to sort by unit price in Return from Customer p&e 
related to defect 0032344 acknowledged Triage Platform Base HQL based tables don't can produce incorrect pagination 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-02-11 11:41AtulOpenbravoNew Issue
2016-02-11 11:41AtulOpenbravoAssigned To => platform
2016-02-11 11:41AtulOpenbravoModules => Core
2016-02-11 11:41AtulOpenbravoTriggers an Emergency Pack => No
2016-02-11 11:58vmromanosNote Added: 0084100
2016-02-11 12:01vmromanosRelationship addedrelated to 0032157
2016-02-11 12:03vmromanosTag Attached: Performance
2016-02-25 15:07alostaleRelationship addedrelated to 0032344
2016-02-25 15:08alostaleNote Added: 0084513
2016-02-25 15:08alostaleStatusnew => closed
2016-02-25 15:08alostaleResolutionopen => no change required

Notes
(0084100)
vmromanos   
2016-02-11 11:58   
Order by clause when we open the P&E for the first time:

ORDER BY obSelected desc, obSelected desc, io.movementDate desc, io.documentNo desc, iol.lineNo



Order by clause when we order by any of the columns, for example the name (notice the final iol.id):

ORDER BY obSelected desc, iol.product.name desc , iol.id
(0084513)
alostale   
2016-02-25 15:08   
The problem is not what this issue reports, but that sometimes id column is not added to the fetch query, see issue 0032344