Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026778Openbravo ERP03. Procurement managementpublic2014-06-04 10:182014-11-28 11:59
Reporteralostale 
Assigned ToSandrahuguet 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelProduction - QA Approved
Regression date2014-02-24
Regression introduced in release
Regression introduced by commit http://code.openbravo.com/erp/devel/pi/rev/bda5291496b89b9e1994dd8b09502eb37e617158 [^]
Triggers an Emergency PackNo
Summary0026778: filter in Return to Vendor is not working
DescriptionFilter in Return to Vendor is not working
Steps To Reproduce-Go to Return to Vendor
-Create a new Header
-Click on Pick/Edit Lines
-Try to filter by Product by selecting an item in drop down list
  Error is thrown in backend and no data is retrieved:
595dbc4c 3784763 [http-8080-7] ERROR org.openbravo.service.datasource.DataSourceServlet - unexpected token: t near line 1, column 484 [select iol from MaterialMgmtShipmentInOutLine as iol left join iol.product as join_0 join iol.shipmentReceipt as io where io.businessPartner = :businessPartner and io.processed = true and io.documentStatus <> 'VO' and io.salesTransaction = false and iol.organization in :organizations and not exists (select 1 from OrderLine as ol where ol.salesOrder = :order and ol.goodsShipmentLine = iol) AND ( iol.id = :alias_0 or upper((COALESCE(to_char((select name from ProductTrl as t t.product = join_0 and t.language.language='en_US')), to_char(join_0.name), ''))) = upper(:alias_1) ) ]
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: t near line 1, column 484 [select iol from MaterialMgmtShipmentInOutLine as iol left join iol.product as join_0 join iol.shipmentReceipt as io where io.businessPartner = :businessPartner and io.processed = true and io.documentStatus <> 'VO' and io.salesTransaction = false and iol.organization in :organizations and not exists (select 1 from OrderLine as ol where ol.salesOrder = :order and ol.goodsShipmentLine = iol) AND ( iol.id = :alias_0 or upper((COALESCE(to_char((select name from ProductTrl as t t.product = join_0 and t.language.language='en_US')), to_char(join_0.name), ''))) = upper(:alias_1) ) ]
    at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
    at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
    at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
    at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284)
    at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
    at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
    at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
    at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
    at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
    at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
    at org.openbravo.common.datasource.ReturnToVendorPickAndEditDataSource.getReceiptLines(ReturnToVendorPickAndEditDataSource.java:318)
    at org.openbravo.common.datasource.ReturnToVendorPickAndEditDataSource.getData(ReturnToVendorPickAndEditDataSource.java:189)
Proposed Solution
Additional Information
TagsManual P&E
Relationships
related to defect 0026700 closed shankarb Wrong request after filtering in a field with combo and do blur in other field in pick and edit windows 
related to feature request 0025814 closed Sandrahuguet Create a new return to vendor pick and edit with manual datasource 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-06-04 10:18alostaleNew Issue
2014-06-04 10:18alostaleAssigned To => Sandrahuguet
2014-06-04 10:18alostaleModules => Core
2014-06-04 10:18alostaleOBNetwork customer => No
2014-06-04 10:18alostaleTriggers an Emergency Pack => No
2014-06-04 10:19alostaleRelationship addedrelated to 0026700
2014-06-05 10:49guillermogilTag Attached: Manual P&E
2014-06-09 11:04alostaleRelationship addedrelated to 0025814
2014-06-09 11:05alostaleRegression level => Pre packaging ( pi )
2014-06-09 11:06alostaleRegression date => 2014-02-24
2014-06-09 11:07alostaleRegression introduced by commit => http://code.openbravo.com/erp/devel/pi/rev/bda5291496b89b9e1994dd8b09502eb37e617158 [^]
2014-06-09 12:13alostaleRegression levelPre packaging ( pi ) => Production - QA Approved
2014-06-20 11:55alostalePriorityimmediate => urgent
2014-06-20 11:56alostaleTarget VersionPR14Q3 => PR14Q4
2014-06-20 11:57alostaleNote Added: 0068222
2014-09-29 10:45eduardo_ArgalTarget Version3.0PR14Q4 => 3.0PR15Q1
2014-11-28 11:59SandrahuguetNote Added: 0072109
2014-11-28 11:59SandrahuguetStatusnew => scheduled
2014-11-28 11:59Sandrahuguetfix_in_branch => pi
2014-11-28 11:59SandrahuguetStatusscheduled => closed
2014-11-28 11:59SandrahuguetResolutionopen => no change required

Notes
(0068222)
alostale   
2014-06-20 11:57   
To be fixed by refactoring P&E return windows from manual to HQL datasource
(0072109)
Sandrahuguet   
2014-11-28 11:59   
Fixed in P&E return windows refactor