Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025378Openbravo ERPA. Platformpublic2013-12-19 17:282014-01-20 06:26
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q2Fixed in Version3.0PR14Q2 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025378: drop down filter doesn't work in FK property columns
DescriptionIt is not possible to filter using drop down list a property column with a FK reference.

Drop down list is not shown at all.

Note that it is possible to filter by typing in filter's text field.

This exception is raisen:
1f923ef8 569769 [http-8080-3] ERROR org.openbravo.base.exception.OBException - Exception when creating query select distinct join_0._computedColumns.cCBP.id, join_0._computedColumns.cCBP.name from Order as e left join e._computedColumns.cCBP as join_0 where ( (( ( e._computedColumns.cCRule = :alias_0 ) )) and (e.salesTransaction=true AND e.transactionDocument.return= false AND e.transactionDocument.sOSubType NOT LIKE 'OB') ) and e.organization.id in ('E443A31992CB4635AFCAEABE7183CE85', '0', 'DC206C91AA6A4897B44DA897936E0EC3', '7BABA5FF80494CAFA54DEBD22EC46F01', 'BAE22373FEBE4CCCA24517E23F0C8A48', '19404EAD144C49A0AF37D54377CF452D', 'B843C30461EA4501935CB1D125C9C25A', '2E60544D37534C0B89E765FE29BC0B43') and e.client.id in ('23C59575B9CF467C9620760EB255B389', '0') and e.active='Y' order by join_0._computedColumns.cCBP.name,join_0._computedColumns.cCBP.id
org.hibernate.QueryException: could not resolve property: _computedColumns of: BusinessPartner [select distinct join_0._computedColumns.cCBP.id, join_0._computedColumns.cCBP.name from Order as e left join e._computedColumns.cCBP as join_0 where ( (( ( e._computedColumns.cCRule = :alias_0 ) )) and (e.salesTransaction=true AND e.transactionDocument.return= false AND e.transactionDocument.sOSubType NOT LIKE 'OB') ) and e.organization.id in ('E443A31992CB4635AFCAEABE7183CE85', '0', 'DC206C91AA6A4897B44DA897936E0EC3', '7BABA5FF80494CAFA54DEBD22EC46F01', 'BAE22373FEBE4CCCA24517E23F0C8A48', '19404EAD144C49A0AF37D54377CF452D', 'B843C30461EA4501935CB1D125C9C25A', '2E60544D37534C0B89E765FE29BC0B43') and e.client.id in ('23C59575B9CF467C9620760EB255B389', '0') and e.active='Y' order by join_0._computedColumns.cCBP.name,join_0._computedColumns.cCBP.id]
Steps To Reproduce-Install attached module
-Open Sales Order window
-Filter by EM_CC_BP (FK reference)
  -It works by typing in filter text field
  -It fails trying to open drop down list -> Fails
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00252483.0MP31 closed alostale Error after sorting by a computed column 
depends on defect 00251823.0PR14Q2 closed alostale Query in org drop down in the list field is having bad performance 
Attached Filesdiff issue-25378.diff (1,215) 2013-12-19 17:52
https://issues.openbravo.com/file_download.php?file_id=6584&type=bug
Issue History
Date ModifiedUsernameFieldChange
2013-12-19 17:28alostaleNew Issue
2013-12-19 17:28alostaleAssigned To => AugustoMauch
2013-12-19 17:28alostaleModules => Core
2013-12-19 17:28alostaleTriggers an Emergency Pack => No
2013-12-19 17:28alostaleRelationship addedrelated to 0025248
2013-12-19 17:29alostaleRelationship addedrelated to 0025182
2013-12-19 17:29alostaleNote Added: 0062880
2013-12-19 17:51alostaleRelationship replaceddepends on 0025182
2013-12-19 17:51alostaleAssigned ToAugustoMauch => alostale
2013-12-19 17:51alostaleTarget Version => 3.0MP32
2013-12-19 17:52alostaleFile Added: issue-25378.diff
2013-12-19 17:52alostaleNote Added: 0062882
2014-01-07 13:49alostaleNote Added: 0063235
2014-01-08 08:26hgbotCheckin
2014-01-08 08:26hgbotNote Added: 0063277
2014-01-08 08:26hgbotStatusnew => resolved
2014-01-08 08:26hgbotResolutionopen => fixed
2014-01-08 08:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9c5fe282d29c9c8ba248bc2ea8cd4a25f9495500 [^]
2014-01-08 12:20alostaleReview Assigned To => shankarb
2014-01-17 15:49hudsonbotCheckin
2014-01-17 15:49hudsonbotNote Added: 0063482
2014-01-20 06:26shankarbNote Added: 0063522
2014-01-20 06:26shankarbStatusresolved => closed
2014-01-20 06:26shankarbFixed in Version => 3.0MP32

Notes
(0062880)
alostale   
2013-12-19 17:29   
When fixing this issue ensure 0025248 and 0025182 still work
(0062882)
alostale   
2013-12-19 17:52   
Attached fix (dependent on fix for 0025182)
(0063235)
alostale   
2014-01-07 13:49   
Executed test cases:
*Case defined in steps to reproduce
*Test cases defined for issue 0025182
(0063277)
hgbot   
2014-01-08 08:26   
Repository: erp/devel/pi
Changeset: 9c5fe282d29c9c8ba248bc2ea8cd4a25f9495500
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Jan 07 13:28:07 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/9c5fe282d29c9c8ba248bc2ea8cd4a25f9495500 [^]

fixed bug 25378: drop down filter doesn't work in FK property columns

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0063482)
hudsonbot   
2014-01-17 15:49   
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/9669102eb541 [^]
Maturity status: Test
(0063522)
shankarb   
2014-01-20 06:26   
Code reviewed and verified in pi changeset 6e2d2a007761.