Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0051039Openbravo ERP04. Warehouse managementpublic2022-11-30 11:182023-01-17 15:54
ReporterXABIER_AGUADO 
Assigned ToAtulOpenbravo 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0051039: Distribution Order AWO : Filter by "Date to" and "Date From" is are not chronologically ordered
DescriptionWhen opening the Distribution Order window in AWO, I choose to filter by "Date to" or "Date From"
Results are not ordered by date
When searching by Date To/ Date From the results should be chronologically ordered, example :
I search for "From 11-11-2022", the results should be :

11-11-11-2022

14-11-2022

16-11-2022

The current results are not properly ordered by date:


16-11-2022

14-11-2022

11-11-11-2022
Steps To ReproduceLog in on AWO
On the menu, select Distribution Order Issue
On the filters, select Date From and introduce a Date
Results are not properly sorted
Proposed SolutionToday all sorts are by document number instead of date (newest at top) and this should be fixed.
Additional Information
TagsFASH
Relationships
Attached Filespng Sorting.png (985,455) 2022-11-30 11:18
https://issues.openbravo.com/file_download.php?file_id=17899&type=bug
Issue History
Date ModifiedUsernameFieldChange
2022-11-30 11:18XABIER_AGUADONew Issue
2022-11-30 11:18XABIER_AGUADOAssigned To => Triage Omni WMS
2022-11-30 11:18XABIER_AGUADOFile Added: Sorting.png
2022-11-30 11:18XABIER_AGUADOModules => Core
2022-11-30 11:18XABIER_AGUADOTriggers an Emergency Pack => No
2022-11-30 11:23XABIER_AGUADOTag Attached: FASH
2022-11-30 15:11XABIER_AGUADOStatusnew => feedback
2022-11-30 15:12XABIER_AGUADONote Added: 0144253
2022-12-09 10:54XABIER_AGUADOProposed Solution updated
2022-12-09 10:54XABIER_AGUADONote Added: 0144492
2022-12-15 11:48migueldejuanaNote Added: 0144737
2023-01-11 11:23hgbotNote Added: 0145254
2023-01-12 10:04vmromanosStatusfeedback => scheduled
2023-01-12 10:04vmromanosAssigned ToTriage Omni WMS => AtulOpenbravo
2023-01-17 15:54hgbotResolutionopen => fixed
2023-01-17 15:54hgbotStatusscheduled => closed
2023-01-17 15:54hgbotNote Added: 0145508
2023-01-17 15:54hgbotNote Added: 0145509
2023-01-17 15:54hgbotNote Added: 0145510

Notes
(0144253)
XABIER_AGUADO   
2022-11-30 15:12   
Waiting on the client to provide more info
(0144492)
XABIER_AGUADO   
2022-12-09 10:54   
Updated with the latest requirements
(0144737)
migueldejuana   
2022-12-15 11:48   
We are ordering only by documentNO -> orderByClause: "documentNo desc".
it should be ordered also by creationDate desc because documentNo is part of an increasing sequence but we should add also date clause to be sure:

orderByClause: "orderDateFrom desc, documentNo desc"
orderByClause: "orderDateTo desc,documentNo desc"

As you can see, in both cases must be ordered descending.
All date filters work like this. We should follow the same approach, see an example:

I search for "From 11-11-2022", the results should be :

16-11-2022

14-11-2022

11-11-2022

I search for "To 16-11-2022", the results should be :

16-11-2022

14-11-2022

11-11-2022
(0145254)
hgbot   
2023-01-11 11:23   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/31 [^]
(0145508)
hgbot   
2023-01-17 15:54   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders [^]
Changeset: 88fd5b3095559fe104fa671c95f115b6226fb542
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 17-01-2023 14:53:44
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/commit/88fd5b3095559fe104fa671c95f115b6226fb542 [^]

Fixes BUG-0051039: Distribution Order AWO : Filter by "Date to"
and "Date From" is are not chronologically ordered

**Add order by orderdate desc along with documentNo desc when
displaying DO's in DO OTF AWO FE.

---
M web/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/source/components/obawo-distributionorderfilter-selector.js
---
(0145509)
hgbot   
2023-01-17 15:54   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders [^]
Changeset: 21832d3bc51590c8032714cf1b3400dfcba922d0
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 17-01-2023 14:53:44
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/commit/21832d3bc51590c8032714cf1b3400dfcba922d0 [^]

Fixes BUG-0051039: Distribution Order AWO : Filter by "Date to"
and "Date From" is are not chronologically ordered

**Add order by creationDate desc along with documentNo desc when
displaying DO's in DO OTF AWO FE.
**Update license year text.

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/distributionorders/mobile/datasources/DistributionOrderProperties.java
M web/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/source/components/obawo-distributionorderfilter-selector.js
---
(0145510)
hgbot   
2023-01-17 15:54   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/31 [^]