Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0030455Openbravo ERP04. Warehouse managementpublic2015-07-29 17:222016-06-17 19:38
mfuertes 
markmm82 
urgentmajoralways
closedfixed 
5
pi 
3.0PR16Q3 
aferraz
Core
No
0030455: Filtering not working in Manage Reservation pop-up when selecting more than one record in Attribute Set Value and other column
Filtering not working in Manage Reservation pop-up when selecting more than one record in Attribute Set Value and other column
As group admin role:
   Create a goods receipt and add a product with an attribute set value that has stock in a storage bin. You should open the Product Selector. Eg.: Zumo de Naranja Bio 0,33L
   Change the Storage Bin to another storage bin in the same warehouse
   Define Enable Stock Reservations preference
   Log out and log in
   Create a Sales Order for the product received
   Click on Manage Reservation window
   Select two values in the Attribute Set Value filter
   Check the records are filtered. This is correct.
   Select a value in the Warehouse or Storage Bin filter
   Check all the records are shown. This is wrong.
a) Change the data origin from Datasource (M_StockReservationPEDataSource) to HQL Query

b) Add support for multiple criteria filtering in the methods used by getData() in StockReservationPickAndEditDataSource
No tags attached.
related to defect 0027788 closed AugustoMauch Filters don't work properly on Manage Stock 
related to defect 0033286 acknowledged Triage Platform Base Manage Reservation popup shows wrong filter under some circumstances 
png issue.png (169,260) 2015-07-29 17:22
https://issues.openbravo.com/file_download.php?file_id=8318&type=bug
png

? screencast.mp4 (906,633) 2015-08-12 13:44
https://issues.openbravo.com/file_download.php?file_id=8360&type=bug
Issue History
2015-07-29 17:22mfuertesNew Issue
2015-07-29 17:22mfuertesAssigned To => platform
2015-07-29 17:22mfuertesFile Added: issue.png
2015-07-29 17:22mfuertesModules => Core
2015-07-29 17:22mfuertesTriggers an Emergency Pack => No
2015-07-30 11:06alostaleNote Added: 0079123
2015-07-30 11:06alostaleAssigned Toplatform => mfuertes
2015-07-30 11:06alostaleStatusnew => feedback
2015-08-04 11:19ngarciaDescription Updatedbug_revision_view_page.php?rev_id=9146#r9146
2015-08-12 13:44mfuertesFile Added: screencast.mp4
2015-08-12 13:45mfuertesNote Added: 0079322
2015-08-14 13:40mfuertesStatusfeedback => new
2015-08-17 08:57VictorVillarAssigned Tomfuertes => platform
2015-08-17 08:57VictorVillarReproducibilityhave not tried => always
2015-08-17 08:58VictorVillarIssue Monitored: networkb
2015-08-17 09:57mfuertesAssigned Toplatform => Triage Finance
2015-08-17 09:57mfuertesCategoryB. User interface => 04. Warehouse management
2016-04-05 18:04ngarciaProposed Solution updated
2016-06-02 12:47ngarciaRelationship addedrelated to 0027788
2016-06-02 12:49ngarciaResolution time => 1466632800
2016-06-02 12:49ngarciaAssigned ToTriage Finance => platform
2016-06-02 12:49ngarciaPriorityhigh => urgent
2016-06-02 12:49ngarciaSeverityminor => major
2016-06-02 12:55ngarciaAssigned Toplatform => Triage Finance
2016-06-02 12:56ngarciaProposed Solution updated
2016-06-02 13:06ngarciaSummaryFiltering not working when selecting more than one => Filtering not working in Manage Reservation pop-up when selecting more than one record in Attribute Set Value and other column
2016-06-02 13:06ngarciaDescription Updatedbug_revision_view_page.php?rev_id=12289#r12289
2016-06-02 13:06ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=12291#r12291
2016-06-02 13:06ngarciaProposed Solution updated
2016-06-06 13:16aferrazAssigned ToTriage Finance => markmm82
2016-06-06 17:44markmm82Statusnew => scheduled
2016-06-09 16:11markmm82Note Added: 0087137
2016-06-16 11:20hgbotCheckin
2016-06-16 11:20hgbotNote Added: 0087334
2016-06-16 11:20hgbotStatusscheduled => resolved
2016-06-16 11:20hgbotResolutionopen => fixed
2016-06-16 11:20hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d1bf16311eab6cc19030cc19d2f3d2b11ad43895 [^]
2016-06-16 11:20hgbotCheckin
2016-06-16 11:20hgbotNote Added: 0087335
2016-06-16 11:39aferrazRelationship addedrelated to 0033286
2016-06-16 11:41aferrazReview Assigned To => aferraz
2016-06-16 11:41aferrazNote Added: 0087339
2016-06-16 11:41aferrazStatusresolved => closed
2016-06-16 11:41aferrazFixed in Version => 3.0PR16Q3
2016-06-17 19:38hudsonbotCheckin
2016-06-17 19:38hudsonbotNote Added: 0087626
2016-06-17 19:38hudsonbotCheckin
2016-06-17 19:38hudsonbotNote Added: 0087627

Notes
(0079123)
alostale   
2015-07-30 11:06   
Unable to reproduce in current pi following steps to reproduce.

Please, if you can reproduce it, add more detailed steps as well as any errors you might have in openbravo.log or in javascript.
(0079322)
mfuertes   
2015-08-12 13:45   
Just made a video of the manage reservation window.
(0087137)
markmm82   
2016-06-09 16:11   
Test plan 1:
As group admin role:
   1- Define Enable Stock Reservations preference
   2- Log out and log in
   3- Go to Goods receipt window and create some entries selecting different attributes and storage bins for the same product.
    Add a product with an attribute set value that has stock in a storage bin. You should open the Product Selector.
        Product: Zumo de Naranja Bio 0,33L
        Attribute: L5
        Storage Bin: Rn-0-0-0
    Complete
    Add a product with an attribute set value that has stock in a storage bin. You should open the Product Selector.
        Product: Zumo de Naranja Bio 0,33L
        Attribute: L8
        Storage Bin: Rn-0-0-0
    Complete
    Add a product with an attribute set value that has stock in a storage bin. You should open the Product Selector.
        Product: Zumo de Naranja Bio 0,33L
        Attribute: L8
        Storage Bin: Rn-2-0-0
    Complete
   4- Go to Sales Order window and create a Sales Order for the product received
    Product: Zumo de Naranja Bio 0,33L
   5- Click on Manage Reservation window
    Check the previous goods receipts created for Zumo de Naranja are shown.
   6- Select two values in the Attribute Set Value filter
    Attribute: ==L5 or ==L8
       Check the records are filtered and only shows records for attributes equal to L5 or L8. This is correct.
   7- Select a value in the Warehouse.
    Warehouse: Región Norte
       Check only the records for the selected filters (Warehouse Región Norte and Attributes L5 or L8) are shown. This is correct.

Test plan 2
  Repeat steps 1 to 5.
   6- Select Storage Bin: Rn-0-0-0
    Check the records are filtered and only records for Storage bin Rn-0-0-0 are shown, not other filter is applied. This is correct.
   7- Select two values in the Attribute Set Value filter
    Attribute: ==L5 or ==L8
       Check the records are filtered and only records for Storage bin Rn-0-0-0 and attributes equal to L5 or L8 are shown. This is correct.
   8- Select a value in the Warehouse.
    Warehouse: Región Norte
       Check only the records for the selected filters (selected Storage bin, Warehouse and Attributes) are shown.
   9- Click again in Storage bin selector
    Check that filter ==Rn-0-0-0 is replaced by ==54EB861A446D464EAA433477A1D867A6. The records still correctly filtered, but the Rn-0-0-0 option in the drop down is unselected. It is wrong.
  10- Click at any other filter without change any of them.
    Check some or all records dissapear.

Test plan 3
  Repeat steps 1 to 5.
   6- Select L5 in the Attribute Set Value filter
    Attribute: ==L5
       Check the records are filtered and only records for attributes equal to L5 are shown. This is correct.
   7- Select Storage Bin: Rn-0-0-0
    Check the records are filtered and only records for Storage bin Rn-0-0-0 and attributes equal to L5 are shown. This is correct.
   8- Click again in Attribute Set Value filter
    Check that filter ==L5 is replaced by ==A3D2CFF6B76F49EFA0922456A69CA211. The records still correctly filtered, but the L5 option in the drop down is unselected. It is wrong.
   9- Click at any other filter without change any of them.
    Check all records dissapear.

Test Plan 4 (sometimes test plan 3 is not reproducible after step 7)
 Repeat steps 1 to 5.
   6- Select L5 in the Attribute Set Value filter
    Attribute: ==L5
       Check the records are filtered and only records for attributes equal to L5 are shown. This is correct.
   7a- Select Storage Bin: Rn-0-0-0
    Check the records are filtered and only records for Storage bin Rn-0-0-0 and attributes equal to L5 are shown. This is correct.
   7b- Deselect Storage Bin: Rn-0-0-0
   8- Click again in Attribute Set Value filter
    Check that filter ==L5 is replaced by ==A3D2CFF6B76F49EFA0922456A69CA211. The records still correctly filtered, but the L5 option in the drop down is unselected. It is wrong.
   9- Click at any other filter without change any of them.
    Check all records dissapear.
(0087334)
hgbot   
2016-06-16 11:20   
Repository: erp/devel/pi
Changeset: d1bf16311eab6cc19030cc19d2f3d2b11ad43895
Author: Mark <markmm82 <at> gmail.com>
Date: Thu Jun 09 11:05:00 2016 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/d1bf16311eab6cc19030cc19d2f3d2b11ad43895 [^]

Fixes issue 30455: Add support for multiple filtering in Stock Reservation P&E

Added support for multiple criteria filtering in getGridData method

---
M src/org/openbravo/common/datasource/StockReservationPickAndEditDataSource.java
---
(0087335)
hgbot   
2016-06-16 11:20   
Repository: erp/devel/pi
Changeset: bf09b8450ffa47543e6c56ca33cead56c39162c9
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Jun 15 13:54:21 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/bf09b8450ffa47543e6c56ca33cead56c39162c9 [^]

Related to issue 30455: Code review improvements

Added also support for multiple criteria filtering in getWarehouseFilterData, getStorageFilterData, getAttributeSetValueFilterData and getOrderLineSetValueFilterData methods.
Add criteria.has("fieldName") check to avoid NPE.

---
M src/org/openbravo/common/datasource/StockReservationPickAndEditDataSource.java
---
(0087339)
aferraz   
2016-06-16 11:41   
Code review + Testing OK
(0087626)
hudsonbot   
2016-06-17 19:38   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0dc7be081b1c [^]
Maturity status: Test
(0087627)
hudsonbot   
2016-06-17 19:38   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0dc7be081b1c [^]
Maturity status: Test