Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032643Retail ModulesWeb POSpublic2016-04-05 10:552016-04-20 16:29
Reportermalsasua 
Assigned Tomigueldejuana 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product VersionRR16Q1 
Target VersionRR16Q2Fixed in VersionRR16Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032643: 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
blocks defect 0032592 closed migueldejuana product characteristics filters is not working with a big data 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-04-11 12:14migueldejuanaTypedefect => backport
2016-04-11 12:14migueldejuanaTarget Version => RR16Q2
2016-04-18 13:40hgbotCheckin
2016-04-18 13:40hgbotNote Added: 0085708
2016-04-18 13:40hgbotStatusscheduled => resolved
2016-04-18 13:40hgbotResolutionopen => fixed
2016-04-18 13:40hgbotFixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR16Q2/org.openbravo.mobile.core/rev/b1b9eed762c6500e16442acbbd59a5e2fa961351 [^]
2016-04-18 13:43migueldejuanaNote Added: 0085709
2016-04-20 16:29marvintmReview Assigned To => marvintm
2016-04-20 16:29marvintmStatusresolved => closed
2016-04-20 16:29marvintmFixed in Version => RR16Q2

Notes
(0085708)
hgbot   
2016-04-18 13:40   
Repository: retail/backports/3.0RR16Q2/org.openbravo.mobile.core
Changeset: b1b9eed762c6500e16442acbbd59a5e2fa961351
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Mon Apr 18 13:40:18 2016 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR16Q2/org.openbravo.mobile.core/rev/b1b9eed762c6500e16442acbbd59a5e2fa961351 [^]

Fixed issue 0032643: 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
---
(0085709)
migueldejuana   
2016-04-18 13:43   
author Miguel de Juana <miguel.dejuana@openbravo.com>
Mon Apr 18 13:41:08 2016 +0200 (69 seconds ago)
changeset 6243 943696586270
parent 6242 202b0d7e2a03
Fixed issue 00325643: product characteristics filters is not working with a big data

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

https://code.openbravo.com/retail/backports/3.0RR16Q2/org.openbravo.retail.posterminal/rev/943696586270 [^]