Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0025348
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminoralways2013-12-17 16:292013-12-19 12:32
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision754999c5e3bc
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0025348: 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)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00251963.0MP31 closedAugustoMauch 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 (developer)
2013-12-17 16:36

Code Review + Testing Ok
(0062858)
hudsonbot (developer)
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 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker