0041700: OtherStoresDetailedStock query has unnecessary JOINs

Description

The query executed in the OtherStoresDetailedStock.java class has multiple JOINs to the same table. This generates a performance problem.

Steps To Reproduce

Open the Stock Screen tab in the Web POS for any product.
Search for other store stock.

Proposed Solution

An unique JOIN should be done for each table.

Tags

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0114319) hgbot (developer) 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 ---

Issue History
Date Modified	Username	Field	Change
2019-08-27 12:40	asiermartirena	New Issue
2019-08-27 12:40	asiermartirena	Assigned To	=> asiermartirena
2019-08-27 12:40	asiermartirena	OBNetwork customer	=> No
2019-08-27 12:40	asiermartirena	Triggers an Emergency Pack	=> No
2019-08-27 12:40	asiermartirena	Tag Attached: Performance
2019-08-29 09:37	hgbot	Checkin
2019-08-29 09:37	hgbot	Note Added: 0114319
2019-08-29 09:37	hgbot	Status	new => resolved
2019-08-29 09:37	hgbot	Resolution	open => fixed
2019-08-29 09:37	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/659fb1dc8534109d2c20fd1c293ed4228b170162 [^]
2019-09-12 09:49	marvintm	Review Assigned To	=> marvintm
2019-09-12 09:49	marvintm	Status	resolved => closed
2019-09-12 09:49	marvintm	Fixed in Version	=> RR19Q4