Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041700Retail ModulesWeb POSpublic2019-08-27 12:402019-09-12 09:49
Reporterasiermartirena 
Assigned Toasiermartirena 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR19Q4 
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
Summary0041700: OtherStoresDetailedStock query has unnecessary JOINs
DescriptionThe query executed in the OtherStoresDetailedStock.java class has multiple JOINs to the same table. This generates a performance problem.
Steps To ReproduceOpen the Stock Screen tab in the Web POS for any product.
Search for other store stock.
Proposed SolutionAn unique JOIN should be done for each table.
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-08-27 12:40asiermartirenaNew Issue
2019-08-27 12:40asiermartirenaAssigned To => asiermartirena
2019-08-27 12:40asiermartirenaTriggers an Emergency Pack => No
2019-08-27 12:40asiermartirenaTag Attached: Performance
2019-08-29 09:37hgbotCheckin
2019-08-29 09:37hgbotNote Added: 0114319
2019-08-29 09:37hgbotStatusnew => resolved
2019-08-29 09:37hgbotResolutionopen => fixed
2019-08-29 09:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/659fb1dc8534109d2c20fd1c293ed4228b170162 [^]
2019-09-12 09:49marvintmReview Assigned To => marvintm
2019-09-12 09:49marvintmStatusresolved => closed
2019-09-12 09:49marvintmFixed in Version => RR19Q4

Notes
(0114319)
hgbot   
2019-08-29 09:37   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 659fb1dc8534109d2c20fd1c293ed4228b170162
Author: Asier Martirena <asier.martirena <at> openbravo.com>
Date: Tue Aug 27 14:06:08 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/659fb1dc8534109d2c20fd1c293ed4228b170162 [^]

Fixed issue 41700: Avoid to do unnecessary multiple JOINs

---
M src/org/openbravo/retail/posterminal/stock/OtherStoresDetailedStock.java
---