0027539: Generic product is loaded more than once when it has more that one price

Description

Generic product is loaded more than once when it has more that one price

Steps To Reproduce

-Create a generic product with one variant characteristic and set the price in 3 price lists
-Create the variants
-Include the variants in the assortment

Verify that when you login in Web POS you will get the following error

[SQLTransaction, SQLError]0: SQLTransaction1: SQLErrorcallee: function () {length: 2__proto__: Object x {modelName: "Product", tableName: "m_product", entityName: "Product", source: "org.openbravo.retail.posterminal.master.Product", dataLimit: 300…}constructor: function (){a.apply(this,arguments)}dataLimit: 300entityName: "Product"includeTerminalDate: trueinitialize: function () {modelName: "Product"source: "org.openbravo.retail.posterminal.master.Product"tableName: "m_product"__proto__: x

The problem is that query
// generic products
    products
        .add("select "
            + regularProductsHQLProperties.getHqlSelect()
            + " from Product product left outer join product.image img left join product.oBRETCOProlProductList as pli left outer join product.pricingProductPriceList ppp where exists (select 1 from Product product2 left join product2.oBRETCOProlProductList as pli2, PricingProductPrice ppp2 where product.id = product2.genericProduct.id and product2 = ppp2.product and ppp2.priceListVersion.id = '"
            + priceListVersion.getId() + "' and pli2.obretcoProductlist.id = '"
            + productList.getId() + "')");

in file modules/org.openbravo.retail.posterminal/src/org/openbravo/retail/posterminal/master/Product.java
is returning the same generic product more than once.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0027538

closed

marvintm

Include all products process in window assortment is including generic products

Notes
(0071560) malsasua (developer) 2014-11-11 16:25	it is not reproducible in RR14Q4

Issue History
Date Modified	Username	Field	Change
2014-09-04 02:36	jecharri	New Issue
2014-09-04 02:36	jecharri	Assigned To	=> marvintm
2014-09-04 02:36	jecharri	Resolution time	=> 1416006000
2014-09-04 02:36	jecharri	Triggers an Emergency Pack	=> No
2014-09-04 02:36	jecharri	Relationship added	related to 0027538
2014-11-05 15:44	mario_castello	Assigned To	marvintm => mario_castello
2014-11-05 15:44	mario_castello	Status	new => scheduled
2014-11-05 15:44	mario_castello	fix_in_branch	=> pi
2014-11-11 16:25	malsasua	Review Assigned To	=> malsasua
2014-11-11 16:25	malsasua	Note Added: 0071560
2014-11-11 16:25	malsasua	Status	scheduled => closed
2014-11-11 16:25	malsasua	Resolution	open => unable to reproduce