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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0025378
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2013-12-19 17:282014-01-20 06:26
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version3.0PR14Q2
StatusclosedFix in branchFixed in SCM revision9c5fe282d29c
ProjectionnoneETAnoneTarget Version3.0PR14Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toshankarb
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0025378: 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
TagsNo tags attached.
Attached Filesdiff file icon issue-25378.diff [^] (1,215 bytes) 2013-12-19 17:52 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00252483.0MP31 closedalostale Error after sorting by a computed column 
depends on defect 00251823.0PR14Q2 closedalostale Query in org drop down in the list field is having bad performance 

-  Notes
(0062880)
alostale (manager)
2013-12-19 17:29

 When fixing this issue ensure 0025248 and 0025182 still work
(0062882)
alostale (manager)
2013-12-19 17:52

 Attached fix (dependent on fix for 0025182)
(0063235)
alostale (manager)
2014-01-07 13:49

 Executed test cases:
*Case defined in steps to reproduce
*Test cases defined for issue 0025182
(0063277)
hgbot (developer)
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 (developer)
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 (reporter)
2014-01-20 06:26

 Code reviewed and verified in pi changeset 6e2d2a007761.

- Issue History
Date Modified Username Field Change
2013-12-19 17:28 alostale New Issue
2013-12-19 17:28 alostale Assigned To => AugustoMauch
2013-12-19 17:28 alostale Modules => Core
2013-12-19 17:28 alostale Triggers an Emergency Pack => No
2013-12-19 17:28 alostale Relationship added related to 0025248
2013-12-19 17:29 alostale Relationship added related to 0025182
2013-12-19 17:29 alostale Note Added: 0062880
2013-12-19 17:51 alostale Relationship replaced depends on 0025182
2013-12-19 17:51 alostale Assigned To AugustoMauch => alostale
2013-12-19 17:51 alostale Target Version => 3.0MP32
2013-12-19 17:52 alostale File Added: issue-25378.diff
2013-12-19 17:52 alostale Note Added: 0062882
2014-01-07 13:49 alostale Note Added: 0063235
2014-01-08 08:26 hgbot Checkin
2014-01-08 08:26 hgbot Note Added: 0063277
2014-01-08 08:26 hgbot Status new => resolved
2014-01-08 08:26 hgbot Resolution open => fixed
2014-01-08 08:26 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9c5fe282d29c9c8ba248bc2ea8cd4a25f9495500 [^]
2014-01-08 12:20 alostale Review Assigned To => shankarb
2014-01-17 15:49 hudsonbot Checkin
2014-01-17 15:49 hudsonbot Note Added: 0063482
2014-01-20 06:26 shankarb Note Added: 0063522
2014-01-20 06:26 shankarb Status resolved => closed
2014-01-20 06:26 shankarb Fixed in Version => 3.0MP32

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker