Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025360Openbravo ERPA. Platformpublic2013-12-18 07:512013-12-19 12:32
Reporteralostale 
Assigned Toalostale 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP31 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelAutomated tests
Regression date2013-12-17
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/73475cebe8558161cd85c898ff1958541a585a45 [^]
Triggers an Emergency PackNo
Summary0025360: BP selector drop down is not working
DescriptionIt is not possible to use drop down in Business Partner Selector.

See https://ci.openbravo.com/job/int-gui-pgsql/23/ [^]

This exception is seen in the log:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: and near line 9, column 3 [SELECT bp.name as name,bp.id as bpid, bp.searchKey as value,
   bp.creditLimit - bp.creditUsed as creditAvailable, bp.creditUsed as creditUsed,
   bp.customer as customer, bp.vendor as vendor,
   bp.businessPartnerCategory.name as category
FROM BusinessPartner bp
where bp.client.id in ('0', '23C59575B9CF467C9620760EB255B389')
 AND bp.organization in ('E443A31992CB4635AFCAEABE7183CE85','0','19404EAD144C49A0AF37D54377CF452D','B843C30461EA4501935CB1D125C9C25A')
 AND
  and bp.summaryLevel = false and bp.active=true
 ORDER BY 1]
Steps To ReproduceGo to Sales Invoice
Create new header
Open BP drop down list -> It is shown empty
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-18 07:51alostaleNew Issue
2013-12-18 07:51alostaleAssigned To => alostale
2013-12-18 07:51alostaleModules => Core
2013-12-18 07:51alostaleTriggers an Emergency Pack => No
2013-12-18 07:52alostaleRegression level => Automated tests
2013-12-18 07:52alostaleRegression date => 2013-12-17
2013-12-18 07:52alostaleRelationship addedrelated to 0025196
2013-12-18 07:53alostaleReview Assigned To => AugustoMauch
2013-12-18 07:53alostaleRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/73475cebe8558161cd85c898ff1958541a585a45 [^]
2013-12-18 07:55hgbotCheckin
2013-12-18 07:55hgbotNote Added: 0062755
2013-12-18 07:55hgbotStatusnew => resolved
2013-12-18 07:55hgbotResolutionopen => fixed
2013-12-18 07:55hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f862c525a817af9418ef302c8de135a3d01931db [^]
2013-12-18 10:29AugustoMauchNote Added: 0062767
2013-12-18 10:29AugustoMauchStatusresolved => closed
2013-12-18 10:29AugustoMauchFixed in Version => 3.0MP31
2013-12-19 12:32hudsonbotCheckin
2013-12-19 12:32hudsonbotNote Added: 0062861

Notes
(0062755)
hgbot   
2013-12-18 07:55   
Repository: erp/devel/pi
Changeset: f862c525a817af9418ef302c8de135a3d01931db
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Dec 18 07:54:28 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f862c525a817af9418ef302c8de135a3d01931db [^]

fixed bug 25360: BP selector drop down is not working

  prevent NPE

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java
---
(0062767)
AugustoMauch   
2013-12-18 10:29   
Code reviewed and verified in pi@469ba15fbba3
(0062861)
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