Openbravo Issue Tracking System - Retail Modules
View Issue Details
0032644Retail ModulesWeb POSpublic2016-04-05 10:552016-04-20 16:29
malsasua 
migueldejuana 
highmajoralways
closedfixed 
20Community Appliance
RR16Q1 
RR16Q1.1RR16Q1.1 
marvintm
No
0032644: product characteristics filters is not working with a big data
in a environment with a big volume data:
>6.000 products
>67.000 product characteristic values

when you try to filter the sencond time, the "loading window" is displayed and never is hidden
in environment with
>6.000 products
>67.000 product characteristic values
. go to search tab
. click in one product characteristict (for example, color)
. select one color (for example, blue)
. click in done
. click in color again
. unselect the color blue
. click in done

loading window is displayed and never is hidden
(see video)
verify the remote data code to see if there are improvements that could be applied to the standard flow. e.g:
in the queries:
- change 'in's by 'exists'
- add indexes where missing
No tags attached.
blocks defect 0032592 closed migueldejuana product characteristics filters is not working with a big data 
Issue History
2016-04-11 12:14migueldejuanaTypedefect => backport
2016-04-11 12:14migueldejuanaTarget Version => RR16Q1.1
2016-04-14 16:46hgbotCheckin
2016-04-14 16:46hgbotNote Added: 0085637
2016-04-14 16:46hgbotStatusscheduled => resolved
2016-04-14 16:46hgbotResolutionopen => fixed
2016-04-14 16:46hgbotFixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR16Q1.1/org.openbravo.mobile.core/rev/4704f9b291bcd3c29dc63680d04130b91b537c75 [^]
2016-04-14 16:48hgbotCheckin
2016-04-14 16:48hgbotNote Added: 0085639
2016-04-14 16:48hgbotFixed in SCM revisionhttp://code.openbravo.com/retail/backports/3.0RR16Q1.1/org.openbravo.mobile.core/rev/4704f9b291bcd3c29dc63680d04130b91b537c75 [^] => http://code.openbravo.com/retail/backports/3.0RR16Q1.1/org.openbravo.retail.posterminal/rev/fc1dc424c701db990073bb6008b048e4bef80347 [^]
2016-04-20 16:29marvintmReview Assigned To => marvintm
2016-04-20 16:29marvintmStatusresolved => closed
2016-04-20 16:29marvintmFixed in Version => RR16Q1.1

Notes
(0085637)
hgbot   
2016-04-14 16:46   
Repository: retail/backports/3.0RR16Q1.1/org.openbravo.mobile.core
Changeset: 4704f9b291bcd3c29dc63680d04130b91b537c75
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Thu Apr 14 16:46:21 2016 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR16Q1.1/org.openbravo.mobile.core/rev/4704f9b291bcd3c29dc63680d04130b91b537c75 [^]

Fixes issue 32644, backport of issue 32592: product characteristics filters is not working with a big data

- Show loading... also in characteristics table in Search tab

---
M web/org.openbravo.mobile.core/source/retail/component/ob-retail-searchproductcharacteristic.js
---
(0085639)
hgbot   
2016-04-14 16:48   
Repository: retail/backports/3.0RR16Q1.1/org.openbravo.retail.posterminal
Changeset: fc1dc424c701db990073bb6008b048e4bef80347
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Thu Apr 14 16:47:42 2016 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR16Q1.1/org.openbravo.retail.posterminal/rev/fc1dc424c701db990073bb6008b048e4bef80347 [^]

Fixes issue 32644, backport of issue 32592: product characteristics filters is not working with a big data

-Add an index to product characteristic table to improve search perfomance

---
M web/org.openbravo.retail.posterminal/js/model/productcharacteristicvalue.js
---