Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005236Openbravo ERPZ. Otherspublic2008-09-24 15:532009-05-18 15:25
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityN/A
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Versionpi 
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
Summary0005236: Sorting by more than one column is not working in at least Product Complete & Business Partner Selector
DescriptionSorting by more than one column does not work the grid is only sorted by the first column
Steps To Reproduce-> Info -> Product Complete
-> Sort by i.e. Unit
-> Sort additionally by i.e. Key (with Strg)

the second sorting criteria is not applied
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0008579 closed shuehner SQL injection in selectors 
depends on backport 0005301 closed shuehner Sorting by more than one column is not working in at least Product Complete & Business Partner Selector 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-24 15:53shuehnerNew Issue
2008-09-24 15:53shuehnerAssigned To => cromero
2008-09-24 15:53shuehnersf_bug_id0 => 2126457
2008-09-24 15:53shuehnerRegression testing => No
2008-09-29 10:31psarobeStatusnew => scheduled
2008-09-29 10:31psarobeAssigned Tocromero => dbaz
2008-09-29 10:31psarobefix_in_branch => trunk
2008-12-23 02:22dbazNote Added: 0011684
2008-12-23 02:22dbazAssigned Todbaz => gorka_gil
2009-02-10 17:00gorka_gilAssigned Togorka_gil => shuehner
2009-02-13 17:20shuehnerNote Added: 0013485
2009-05-15 12:28shuehnerNote Added: 0016382
2009-05-18 15:24shuehnerRelationship addedrelated to 0008579
2009-05-18 15:25shuehnerStatusscheduled => closed
2009-05-18 15:25shuehnerNote Added: 0016426
2009-05-18 15:25shuehnerResolutionopen => no change required

Notes
(0011684)
dbaz   
2008-12-23 02:22   
This problem seems to affect only to Information (selector) windows

It seems to be a problem with the ORDER BY of the SQL of each Information (selector) because:
* The issue only affects Information windows (relation windows run ok)
* It affects both r2.40 (Dojo 0.4.3) and r2.50 (Dojo 1.2.x), so the issue it is not a javascript problem (because it fails with different functions)
(0013485)
shuehner   
2009-02-13 17:20   
dbaz is right, the parameter are sent properly to the backend, but not correctly handled for the selectors in the case of multiple sort columns. Each selector has to be checked/fixed individually.
(0016382)
shuehner   
2009-05-15 12:28   
List of selectors where does not work:
Account selector
Account Element Value
Business partner
Business Partner multiple
Debt/Payment
Invoice
Invoice Line
Locator
Order
Orderline
Product multiple
Project
Shipment/Receipt line
(0016426)
shuehner   
2009-05-18 15:25   
No change required as the fix for issue 8579 did introduce the necessary changes for all selectors to be able to support sorting by more then one column.