Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0035431 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| defect | [Openbravo ERP] A. Platform | minor | have not tried | 2017-03-06 10:43 | 2022-02-01 08:05 | ||||||
| Reporter | inigosanchez | View Status | public | ||||||||
| Assigned To | Triage Platform Base | ||||||||||
| Priority | normal | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Any | Database | Any | Java version | |||||||
| OS Version | Database version | Ant version | |||||||||
| Product Version | SCM revision | ||||||||||
| Review Assigned To | |||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| 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) | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |