Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032592Retail ModulesWeb POSpublic2016-04-05 10:552016-04-20 16:29
Reportermalsasua 
Assigned Tomigueldejuana 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product VersionRR16Q1 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032592: product characteristics filters is not working with a big data
Descriptionin 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
Steps To Reproducein 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)
Proposed Solutionverify 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
Additional Information
TagsNo tags attached.
Relationships
related to defect 0032498 closed Sandrahuguet Openbravo ERP [HGVOL] Improve characteristics performance 
depends on backport 0032643RR16Q2 closed migueldejuana Retail Modules product characteristics filters is not working with a big data 
depends on backport 0032644RR16Q1.1 closed migueldejuana Retail Modules product characteristics filters is not working with a big data 
related to defect 0032609 closed migueldejuana Retail Modules Generic products are not shown in Browse tab 
Attached Files? filtros.ogv (1,020,813) 2016-04-05 10:57
https://issues.openbravo.com/file_download.php?file_id=9237&type=bug
diff issue32592CoreforMd.diff (2,844) 2016-04-06 19:42
https://issues.openbravo.com/file_download.php?file_id=9243&type=bug
diff issue32592PosterminalforMd.diff (1,090) 2016-04-06 19:43
https://issues.openbravo.com/file_download.php?file_id=9244&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-04-05 10:55malsasuaNew Issue
2016-04-05 10:55malsasuaAssigned To => Retail
2016-04-05 10:55malsasuaOBNetwork customer => Yes
2016-04-05 10:55malsasuaResolution time => 1460239200
2016-04-05 10:55malsasuaTriggers an Emergency Pack => No
2016-04-05 10:57malsasuaFile Added: filtros.ogv
2016-04-05 11:40OrekariaProposed Solution updated
2016-04-05 11:40OrekariaStatusnew => acknowledged
2016-04-05 11:45OrekariaRelationship addedrelated to 0032498
2016-04-06 16:54OrekariaStatusacknowledged => scheduled
2016-04-06 16:54OrekariaAssigned ToRetail => migueldejuana
2016-04-06 19:42migueldejuanaFile Added: issue32592CoreforMd.diff
2016-04-06 19:43migueldejuanaFile Added: issue32592PosterminalforMd.diff
2016-04-07 16:59migueldejuanaNote Added: 0085499
2016-04-11 12:14migueldejuanaStatusscheduled => resolved
2016-04-11 12:14migueldejuanaStatusresolved => new
2016-04-11 12:14migueldejuanaStatusnew => scheduled
2016-04-12 16:55hgbotCheckin
2016-04-12 16:55hgbotNote Added: 0085576
2016-04-12 16:55hgbotStatusscheduled => resolved
2016-04-12 16:55hgbotResolutionopen => fixed
2016-04-12 16:55hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/5e2d617c1c91301dc672b12468808748ea11e998 [^]
2016-04-12 16:55hgbotCheckin
2016-04-12 16:55hgbotNote Added: 0085577
2016-04-12 16:55hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/5e2d617c1c91301dc672b12468808748ea11e998 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c3143eef9c51acbb7aa020f8c1c7991d79394655 [^]
2016-04-13 16:41malsasuaRelationship addedrelated to 0032609
2016-04-14 16:46hgbotCheckin
2016-04-14 16:46hgbotNote Added: 0085636
2016-04-14 16:48hgbotCheckin
2016-04-14 16:48hgbotNote Added: 0085638
2016-04-20 16:29marvintmReview Assigned To => marvintm
2016-04-20 16:29marvintmStatusresolved => closed
2016-04-20 16:29marvintmFixed in Version => pi

Notes
(0085499)
migueldejuana   
2016-04-07 16:59   
There is also a problem of performance in Search tab with high number of characteristics.
(0085576)
hgbot   
2016-04-12 16:55   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 5e2d617c1c91301dc672b12468808748ea11e998
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Thu Apr 07 13:29:58 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/5e2d617c1c91301dc672b12468808748ea11e998 [^]

Fixed issue 0032592: 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
---
(0085577)
hgbot   
2016-04-12 16:55   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: c3143eef9c51acbb7aa020f8c1c7991d79394655
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Thu Apr 07 13:30:55 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c3143eef9c51acbb7aa020f8c1c7991d79394655 [^]

Fixed issue 0032592: 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
---
(0085636)
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
---
(0085638)
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
---