Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0032344 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| defect | [Openbravo ERP] A. Platform | minor | random | 2016-02-25 15:07 | 2022-02-01 08:05 | ||||||
| Reporter | alostale | 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 | 0032344: HQL based tables don't can produce incorrect pagination | ||||||||||
| Description | When a grid build on top of a HQL based table is fetched before sorting by any column, id property is not added to the ORDER BY clause. This can cause, in case there are several pages and the default sorting to be done by non-unique values, to return duplicated records in different pages. Id is always appended to guarantee uniqueness in sorting so a record can only be in a given page. Note when a sorting on any column is applied, id field is added to the order by. | ||||||||||
| Steps To Reproduce | 1. Open Return to Vendor window 2. Create a header 3. Open Pick/Edit Lines process -> ERROR: check query executed, it should add id field but it does 4. Sort by Shipment Number -> CORRECT: M_InOutLine_ID column is added to the order by | ||||||||||
| 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 |
| 2016-02-25 15:07 | alostale | New Issue | |
| 2016-02-25 15:07 | alostale | Assigned To | => platform |
| 2016-02-25 15:07 | alostale | Modules | => Core |
| 2016-02-25 15:07 | alostale | Triggers an Emergency Pack | => No |
| 2016-02-25 15:07 | alostale | Status | new => acknowledged |
| 2016-02-25 15:07 | alostale | Relationship added | related to 0032201 |
| 2022-02-01 08:05 | alostale | Assigned To | platform => Triage Platform Base |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |