Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040518Retail ModulesWeb POSpublic2019-04-04 10:252019-04-15 16:39
Reporterasiermartirena 
Assigned Toasiermartirena 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR19Q3 
Merge Request Status
Review Assigned Toadrianromero
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040518: The product characteristic value query does several joins for the same table
DescriptionThere are too much joins to the characteristic table, when an only one is needed. This causes a performance problem.
Steps To ReproduceSet a characteristic with values to a product and load the Web POS (or search for a product in remote).
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-04-04 10:25asiermartirenaNew Issue
2019-04-04 10:25asiermartirenaAssigned To => asiermartirena
2019-04-04 10:25asiermartirenaOBNetwork customer => No
2019-04-04 10:25asiermartirenaTriggers an Emergency Pack => No
2019-04-04 13:27hgbotCheckin
2019-04-04 13:27hgbotNote Added: 0110981
2019-04-04 13:27hgbotStatusnew => resolved
2019-04-04 13:27hgbotResolutionopen => fixed
2019-04-04 13:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/deb69239fcb0b2d31a53fe81f73379ee810686eb [^]
2019-04-15 16:39adrianromeroReview Assigned To => adrianromero
2019-04-15 16:39adrianromeroNote Added: 0111146
2019-04-15 16:39adrianromeroStatusresolved => closed
2019-04-15 16:39adrianromeroFixed in Version => RR19Q3

Notes
(0110981)
hgbot   
2019-04-04 13:27   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: deb69239fcb0b2d31a53fe81f73379ee810686eb
Author: Asier Martirena <asier.martirena <at> openbravo.com>
Date: Thu Apr 04 10:27:53 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/deb69239fcb0b2d31a53fe81f73379ee810686eb [^]

Fixed issue 40518: Performed the product characteristic value query

Avoided to do multiple joins for the same table.

---
M src/org/openbravo/retail/posterminal/master/CharacteristicValue.java
M src/org/openbravo/retail/posterminal/master/CharacteristicValueProperties.java
---
(0111146)
adrianromero   
2019-04-15 16:39   
Verified.