0025348: ProductSimple selector cannot filter by Unit Price nor List Price

Description

In Invoice Line Product selector it is not possible to filter by Unit Price nor List Price

Steps To Reproduce

*Create a Sales Invoice
*Open Product Selector in lines
*Try to filter by any of those 2 fields

No records are shown
This error is logged:
org.hibernate.QueryException: could not resolve property: netListPrice of: Product [select p.searchKey as searchKey, p.id as id, plv as priceListVersion, plv.name as priceListVersionName, c.id as currency, pp.priceLimit as priceLimit, p.name as productName,p.uOM as uOM, pp.standardPrice as standardPrice, pp.listPrice as netListPrice, pl.salesPriceList as salesPriceList, p.characteristicDescription as chDescription, gp.name as genericProduct
from PricingProductPrice pp
join pp.product p
join pp.priceListVersion plv
join plv.priceList pl
left join pl.currency c
left join p.genericProduct gp
where p.isGeneric = 'N'
and pp.client.id in ('0', '44FE6AC078E14A6CA5A1189E01E67FB5')
AND pp.organization in ('825BF275D875406288FE248FC7D41136','0')
AND ( pl.salesPriceList = true AND c.id = '102')
AND (lower(p.characteristicDescription) LIKE '%["2cf4d8b74cd94779bd2cb1c53f14f2c3"]%'
AND p.netListPrice = 0)
ORDER BY 4]
at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:81)

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0025196

3.0MP31

closed

AugustoMauch

The product characteristics filter does not work on the produtsimple selector

Notes
(0062746) hgbot (developer) 2013-12-17 16:32	Repository: erp/devel/pi Changeset: 754999c5e3bc5a0d3a47585b052a9e3b27491427 Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Tue Dec 17 16:31:40 2013 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/754999c5e3bc5a0d3a47585b052a9e3b27491427 [^] fixed bug 25348: ProductSimple selector cannot filter by Price columns --- M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml ---

(0062747) dmiguelez (viewer) 2013-12-17 16:36	Code Review + Testing Ok

(0062858) hudsonbot (viewer) 2013-12-19 12:32	A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b878bb51dc09 [^] Maturity status: Test

Issue History
Date Modified	Username	Field	Change
2013-12-17 16:29	alostale	New Issue
2013-12-17 16:29	alostale	Assigned To	=> alostale
2013-12-17 16:29	alostale	Modules	=> Core
2013-12-17 16:29	alostale	OBNetwork customer	=> No
2013-12-17 16:29	alostale	Triggers an Emergency Pack	=> No
2013-12-17 16:30	alostale	Relationship added	related to 0025196
2013-12-17 16:32	alostale	Review Assigned To	=> dmiguelez
2013-12-17 16:32	hgbot	Checkin
2013-12-17 16:32	hgbot	Note Added: 0062746
2013-12-17 16:32	hgbot	Status	new => resolved
2013-12-17 16:32	hgbot	Resolution	open => fixed
2013-12-17 16:32	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/754999c5e3bc5a0d3a47585b052a9e3b27491427 [^]
2013-12-17 16:36	dmiguelez	Note Added: 0062747
2013-12-17 16:36	dmiguelez	Status	resolved => closed
2013-12-19 12:32	hudsonbot	Checkin
2013-12-19 12:32	hudsonbot	Note Added: 0062858