Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025348Openbravo ERP07. Sales managementpublic2013-12-17 16:292013-12-19 12:32
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025348: ProductSimple selector cannot filter by Unit Price nor List Price
DescriptionIn 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)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00251963.0MP31 closed AugustoMauch The product characteristics filter does not work on the produtsimple selector 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-12-17 16:29alostaleNew Issue
2013-12-17 16:29alostaleAssigned To => alostale
2013-12-17 16:29alostaleModules => Core
2013-12-17 16:29alostaleOBNetwork customer => No
2013-12-17 16:29alostaleTriggers an Emergency Pack => No
2013-12-17 16:30alostaleRelationship addedrelated to 0025196
2013-12-17 16:32alostaleReview Assigned To => dmiguelez
2013-12-17 16:32hgbotCheckin
2013-12-17 16:32hgbotNote Added: 0062746
2013-12-17 16:32hgbotStatusnew => resolved
2013-12-17 16:32hgbotResolutionopen => fixed
2013-12-17 16:32hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/754999c5e3bc5a0d3a47585b052a9e3b27491427 [^]
2013-12-17 16:36dmiguelezNote Added: 0062747
2013-12-17 16:36dmiguelezStatusresolved => closed
2013-12-19 12:32hudsonbotCheckin
2013-12-19 12:32hudsonbotNote Added: 0062858

Notes
(0062746)
hgbot   
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   
2013-12-17 16:36   
Code Review + Testing Ok
(0062858)
hudsonbot   
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