Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0024740Openbravo ERPA. Platformpublic2013-09-11 12:562013-09-26 16:56
urgentmajorhave not tried
0024740: Filters for columns with list reference doesn't work properly on HQL defined selectors
Filters for columns with list reference doesn't work properly on OBUISEL_Selector that make use of the HQL custom query.
As system admin:
1) Go to the [Reference] window
2) Look for the Product Simple reference
3) Navigate to the [Defined selector] tab
4) Add a new column with list refenrence in the hql query, for example p.costType as costtype
5) In the [Defined Selector Field] subtab add a new field for the previous defined column. Using the same example, put the following values:

Display Column Alias: costtype
Reference: Cost Type
Clause Left Part: p.costType
Default Expression: "AV"

6) Log-out and Log-in as group admin. Go to the Sales Invoice window, and open the product selector in the lines. Notice that the filter for the recent added column is not working.
No tags attached.
related to defect 00248043.0MP28 closed shankarb Filters are not working properly for translated fields 
Issue History
2013-09-11 12:56caristuNew Issue
2013-09-11 12:56caristuAssigned To => AugustoMauch
2013-09-11 12:56caristuModules => Core
2013-09-11 12:56caristuTriggers an Emergency Pack => No
2013-09-11 13:01caristuTarget Version => 3.0MP29
2013-09-11 13:01caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=5011#r5011
2013-09-11 13:02caristuIssue Monitored: networkb
2013-09-11 18:47caristuPriorityhigh => urgent
2013-09-11 18:47caristuTarget Version3.0MP29 => 3.0MP28
2013-09-19 13:54caristuSeverityminor => major
2013-09-23 08:33alostaleRelationship addedrelated to 0024804
2013-09-25 12:19alostaleAssigned ToAugustoMauch => alostale
2013-09-25 12:34alostaleReview Assigned To => shankarb
2013-09-25 12:34hgbotCheckin
2013-09-25 12:34hgbotNote Added: 0061390
2013-09-25 12:34hgbotStatusnew => resolved
2013-09-25 12:34hgbotResolutionopen => fixed
2013-09-25 12:34hgbotFixed in SCM revision => [^]
2013-09-25 12:35alostaleNote Added: 0061391
2013-09-25 19:58hudsonbotCheckin
2013-09-25 19:58hudsonbotNote Added: 0061397
2013-09-26 16:56shankarbNote Added: 0061423
2013-09-26 16:56shankarbStatusresolved => closed
2013-09-26 16:56shankarbFixed in Version => 3.0MP28

2013-09-25 12:34   
Repository: erp/devel/pi
Changeset: 8ab8b14e84724a2fb7b318a93c9c38471591d73a
Author: Asier Lostalé <asier.lostale <at>>
Date: Wed Sep 25 12:33:35 2013 +0200
URL: [^]

fixed bug 24740: filter list reference columns in HQL defined selectors

  Taking into account this case both in the view generation and in the DataSource

M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/
2013-09-25 12:35   
Tested following steps to reproduce both in English and Spanish (to ensure issue 0024804) does not reproduce here. Working fine in both cases.
2013-09-25 19:58   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: [^]

Maturity status: Test
2013-09-26 16:56   
Code reviewed and verified in pi changeset f497481ca351