Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0035431 | Openbravo ERP | A. Platform | public | 2017-03-06 10:43 | 2022-02-01 08:05 | |||||||
| Reporter | inigosanchez | |||||||||||
| Assigned To | Triage Platform Base | |||||||||||
| Priority | normal | Severity | minor | Reproducibility | have not tried | |||||||
| Status | acknowledged | Resolution | open | |||||||||
| Platform | OS | 5 | OS Version | |||||||||
| Product Version | ||||||||||||
| 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 | 0035431: Data in widgets is not sorted properly under some circumstances | |||||||||||
| Description | Data in widgets are not sorted properly under some circumstances. When the query that generates the data of the widget has not an 'order by' clause the data is not sorted properly. The problem can be found in updateSortByFields() method in QueryListDataSource class. This method is used to updates the order by clause of the HQL query and it is not managed properly the reported case. | |||||||||||
| Steps To Reproduce | 1) Install the "com.openbravo.support.test" module and update to the revision 15 (tag Issue29452). 1.1) Path https://code.openbravo.com/erp/mods/com.openbravo.support.test/ [^] 2) Log in as F&B International Group Admin 3) Add the "All invoices" widget into the workspace 4) Sort Business Partner by clicking in 'Business Partner' column header. 4.1) Note than "No items to show" message is showed. 5) Log out and Log in as System Administrator. 6) Go to Widget window > Select "All Invoices" widget > Go to Query subtab. 7) Add a "order by" clause in query. (e.g. add to the end of the hql query 'order by inv.businessPartner.id desc'). 8) Log out and Log in as F&B International Group Admin. 8.1) Note than "All Invoices" widget is sorted properly. (In this case by Business Partner ID) 9) Sort Amount by clicking in 'Amount' column header. 9.1) Note than data is sorted properly.(In this case by Business Partner ID + Amount) | |||||||||||
| Proposed Solution | ||||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| 2017-03-06 10:43 | inigosanchez | New Issue | ||||||||||
| 2017-03-06 10:43 | inigosanchez | Assigned To | => platform | |||||||||
| 2017-03-06 10:43 | inigosanchez | Modules | => Core | |||||||||
| 2017-03-06 10:43 | inigosanchez | Triggers an Emergency Pack | => No | |||||||||
| 2017-03-07 11:02 | inigosanchez | Relationship added | related to 0029452 | |||||||||
| 2017-04-07 09:03 | alostale | Status | new => acknowledged | |||||||||
| 2017-04-07 09:03 | alostale | Summary | Data in widgets are not sorted properly under some circumstances => Data in widgets is not sorted properly under some circumstances | |||||||||
| 2022-02-01 08:05 | alostale | Assigned To | platform => Triage Platform Base | |||||||||
| There are no notes attached to this issue. |