Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0054091Openbravo ERP01. General setuppublic2023-12-11 13:342024-01-08 11:40
ReporterLeyre 
Assigned ToTriage Platform Base 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR24Q1 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2022-03-15
Regression introduced in releasePR22Q2
Regression introduced by commithttps://gitlab.com/openbravo/product/openbravo/-/commit/e7487ed9e5b52d1c32013d2ca0c4bd9a16307bbd [^]
Triggers an Emergency PackNo
Summary0054091: "Payment Out" window - Cannot sort columns by descending order
DescriptionIt is not possible to sort columns by descending order in "Payment Out" window, "Add Details" pop-up. See attached image.
Steps To ReproduceBackend:

1) In Payment Out window, create a new record.
2) Click "Add Details" button and un-tick any selected payment lines. (Make sure there are multiple payment lines in order to see the sorting result).
3) Sort 'Invoice No.' column by descending order -> KO
4) Sort 'Expected Date' column by descending order -> KO
5) Sort any amount column by descending order -> KO
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0054265PR23Q4.2 closed Triage Platform Base Openbravo ERP "Payment Out" window - Cannot sort columns by descending order 
caused by defect 0048357 closed AugustoMauch Retail Modules The sorting configuration of "Add product categories" popup in "discounts and promotions" doesn't work as expected - new fix 
has duplicate defect 0050459 closed gdagnesses Openbravo ERP Cannot filter P&E grids by a field in descending criteria 
Attached Filesjpg invoice_column_not_sort_by_desc.JPG (165,239) 2023-12-11 13:34
https://issues.openbravo.com/file_download.php?file_id=19201&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2023-12-11 13:34LeyreNew Issue
2023-12-11 13:34LeyreAssigned To => Triage Omni OMS
2023-12-11 13:34LeyreFile Added: invoice_column_not_sort_by_desc.JPG
2023-12-11 13:34LeyreModules => Core
2023-12-11 13:34LeyreTriggers an Emergency Pack => No
2023-12-27 17:46aferrazAssigned ToTriage Omni OMS => AtulOpenbravo
2024-01-04 04:13AtulOpenbravoRelationship addedrelated to 0050459
2024-01-04 04:14AtulOpenbravoRelationship addedcaused by 0048357
2024-01-04 04:15AtulOpenbravoRegression level => Production - Confirmed Stable
2024-01-04 04:15AtulOpenbravoRegression date => 2022-03-15
2024-01-04 04:15AtulOpenbravoRegression introduced in release => PR22Q2
2024-01-04 04:15AtulOpenbravoRegression introduced by commit => https://gitlab.com/openbravo/product/openbravo/-/commit/e7487ed9e5b52d1c32013d2ca0c4bd9a16307bbd [^]
2024-01-04 04:17AtulOpenbravoAssigned ToAtulOpenbravo => Triage Platform Base
2024-01-04 04:21AtulOpenbravoNote Added: 0158847
2024-01-08 11:27AugustoMauchRelationship replacedhas duplicate 0050459
2024-01-08 11:40AugustoMauchStatusnew => scheduled
2024-01-08 11:40hgbotResolutionopen => fixed
2024-01-08 11:40hgbotStatusscheduled => resolved
2024-01-08 11:40hgbotFixed in Version => PR24Q1
2024-01-08 11:40hgbotNote Added: 0158931
2024-01-08 11:40AugustoMauchStatusresolved => closed

Notes
(0158847)
AtulOpenbravo   
2024-01-04 04:21   
This issue is similar to https://issues.openbravo.com/view.php?id=50459. [^]
There is sorting problem for P&E grid fields, they cannot be sorted in descending order due to the fix for issue https://issues.openbravo.com/view.php?id=48357 [^]

After testing MR for 50459 https://gitlab.com/openbravo/product/openbravo/-/merge_requests/730, [^] sorting in descending order works correctly for P&E grid fields.
(0158931)
hgbot   
2024-01-08 11:40   
Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: bdb9aee0c9eca26dc8a107908433da686f9611af
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 08-01-2024 11:27:57
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/bdb9aee0c9eca26dc8a107908433da686f9611af [^]

fixes BUG-54091: Cannot filter P&E grids by a field in descending criteria

  In the following cases the sortBy property was not being identified
properly as a property that references to a grid field:

  1) When sorting descending, because the sortBy property starts with
"-"
  2) When sorting by a display field of a grid field and the name of
that display field is not included in the datasource fields. This is the
case of some special property fields (product characteristic property
fields)

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/process/ob-pick-and-execute-datasource.js
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/process/ob-pick-and-execute-grid.js
---