Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024740Openbravo ERPA. Platformpublic2013-09-11 12:562013-09-26 16:56
Reportercaristu 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP28Fixed in Version3.0MP28 
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
Summary0024740: Filters for columns with list reference doesn't work properly on HQL defined selectors
DescriptionFilters for columns with list reference doesn't work properly on OBUISEL_Selector that make use of the HQL custom query.
Steps To ReproduceAs 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00248043.0MP28 closed shankarb Filters are not working properly for translated fields 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
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:01caristuResolution time => 1384988400
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 => http://code.openbravo.com/erp/devel/pi/rev/8ab8b14e84724a2fb7b318a93c9c38471591d73a [^]
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

Notes
(0061390)
hgbot   
2013-09-25 12:34   
Repository: erp/devel/pi
Changeset: 8ab8b14e84724a2fb7b318a93c9c38471591d73a
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Sep 25 12:33:35 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8ab8b14e84724a2fb7b318a93c9c38471591d73a [^]

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/CustomQuerySelectorDatasource.java
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/SelectorComponent.java
---
(0061391)
alostale   
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.
(0061397)
hudsonbot   
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: https://code.openbravo.com/erp/devel/main/rev/a06bf757c7ec [^]

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