0020170: Querylist widget: sorting only applies to displayed records (and records in the buffer)

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0020170

Openbravo ERP

A. Platform

public

2012-03-30 13:19

2022-02-01 08:08

Reporter

mirurita

Assigned To

Triage Platform Base

Priority

high

Severity

minor

Reproducibility

always

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

0020170: Querylist widget: sorting only applies to displayed records (and records in the buffer)

Description

When you sort a querylist widget (clicking on the column header) in minimize and maximize views it only sort the records that are displayed (not all).

Steps To Reproduce

1) Add 'Best Sellers' querylist widget to your workspace
2) Edit the querylist widget (click on the top right pencil icon): set 5 as number of rows to display and click on Save button.
3) Click on Product Name column header. The grid will be sorted base on this column.
Last product: Plain Water
First product: Agua con Gas 1L
4) Maximize the widget and realize that there is a product starting with Z (Zumo de Piña)

When you set a number of rows the ordering defined for the query will be applied. But if you click on a column header you expect to get the first X rows (defined in number of rows) after applying the ordering of the column.

In this example you should get

Proposed Solution

Additional Information