0032344: HQL based tables don't can produce incorrect pagination

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0032344

Openbravo ERP

A. Platform

public

2016-02-25 15:07

2022-02-01 08:05

Reporter

alostale

Assigned To

Triage Platform Base

Priority

normal

Severity

minor

Reproducibility

random

Status

acknowledged

Resolution

open

Platform

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

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

Proposed Solution

Additional Information