Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0051039
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2022-11-30 11:182023-01-17 15:54
ReporterXABIER_AGUADOView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0051039: 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.
TagsFASH
Attached Filespng file icon Sorting.png [^] (985,455 bytes) 2022-11-30 11:18

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0144253)
XABIER_AGUADO (developer)
2022-11-30 15:12

 Waiting on the client to provide more info
(0144492)
XABIER_AGUADO (developer)
2022-12-09 10:54

 Updated with the latest requirements
(0144737)
migueldejuana (developer)
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 (developer)
2023-01-11 11:23

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/31 [^]
(0145508)
hgbot (developer)
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 (developer)
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 (developer)
2023-01-17 15:54

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/31 [^]

- Issue History
Date Modified Username Field Change
2022-11-30 11:18 XABIER_AGUADO New Issue
2022-11-30 11:18 XABIER_AGUADO Assigned To => Triage Omni WMS
2022-11-30 11:18 XABIER_AGUADO File Added: Sorting.png
2022-11-30 11:18 XABIER_AGUADO Modules => Core
2022-11-30 11:18 XABIER_AGUADO Triggers an Emergency Pack => No
2022-11-30 11:23 XABIER_AGUADO Tag Attached: FASH
2022-11-30 15:11 XABIER_AGUADO Status new => feedback
2022-11-30 15:12 XABIER_AGUADO Note Added: 0144253
2022-12-09 10:54 XABIER_AGUADO Proposed Solution updated
2022-12-09 10:54 XABIER_AGUADO Note Added: 0144492
2022-12-15 11:48 migueldejuana Note Added: 0144737
2023-01-11 11:23 hgbot Note Added: 0145254
2023-01-12 10:04 vmromanos Status feedback => scheduled
2023-01-12 10:04 vmromanos Assigned To Triage Omni WMS => AtulOpenbravo
2023-01-17 15:54 hgbot Resolution open => fixed
2023-01-17 15:54 hgbot Status scheduled => closed
2023-01-17 15:54 hgbot Note Added: 0145508
2023-01-17 15:54 hgbot Note Added: 0145509
2023-01-17 15:54 hgbot Note Added: 0145510

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker