Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017011Openbravo ERPA. Platformpublic2011-05-04 17:292011-05-26 16:59
ReporterAinhoaPagola 
Assigned Toiperdomo 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.4
Product Versionpi 
Target Version3.0MP0Fixed in Version3.0MP0 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017011: Filter expression in OBUISEL selectors not filtering
DescriptionIn the example explained below, the filter expression is only working for the picklist, but not for the search pop-up.
Steps To Reproduce* To test this issue at least 2 products are needed. This products must have an Attribute set. And some transactions with these products are needed. For example, "vino tinto" and "vino blanco".

1) Create a new selector as defined in [1]
- In Defined Selector tab set:
  * Table: "M_transaction"
  * HQL where clause: e.attributeSetValue!='0'
  * Filter Expression: "e.product.id='" + OB.getParameters().get('inpmProductId') + "'"

- In Defined Selector Field create 4 new fields:
  * Movement date - Property: movementDate
  * Identificator - Property: _identifier
  * Attribute - Property: attributeSetValue
  * Article - Property: product.
For all the fields check central maintenance, sortable, filtable and show in grid.

2) Go to Tables and Columns and select OrderLine table.
- Select M_AttributeSetInstance_ID column and change its reference to OBUISEL_Selector Reference.
- Set Reference Serach Key to the new selector.

3) Change to Admin rol. Go to Saler Order. Create a new header. Create a new line selecting the product "vino tinto". The attribute selector will be displayed. Click on the picklist and check that its attributes are displayed. Open the search selector. Every product is displayed - no filtering is done.

[1] http://wiki.openbravo.com/wiki/Projects/Selector/Developers_Manual#Step_1:_Define_a_Reference [^] [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00169803.0MP0 closed iperdomo Property field for OBUISEL selectors not visible in grid 
related to defect 00169793.0MP0 closed iperdomo Property path in OBUISEL selectors fields is not working 
related to defect 00170063.0MP0 closed iperdomo New selector not refreshing properly data 
related to defect 00170103.0MP0 closed iperdomo Default Expression in new selectors not working for search reference type column 
blocks defect 00170083.0MP0 closed maite Not possible to set a column different to the ID with OBUISEL selectors 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-05-04 17:29AinhoaPagolaNew Issue
2011-05-04 17:29AinhoaPagolaAssigned To => alostale
2011-05-04 17:29AinhoaPagolaModules => Core
2011-05-04 17:29AinhoaPagolaOBNetwork customer => Yes
2011-05-04 17:32AinhoaPagolaRelationship addedrelated to 0016980
2011-05-04 17:33AinhoaPagolaRelationship addedrelated to 0016979
2011-05-04 17:35AinhoaPagolaRelationship addedrelated to 0017006
2011-05-04 17:37AinhoaPagolaRelationship addedblocks 0017008
2011-05-04 17:37AinhoaPagolaRelationship addedrelated to 0017010
2011-05-04 17:38AinhoaPagolaIssue Monitored: networkb
2011-05-05 09:06alostaleTarget Version => 3.0RC8
2011-05-05 09:06alostaleAssigned Toalostale => iperdomo
2011-05-05 09:07alostaleStatusnew => scheduled
2011-05-05 10:27gorka_gilTarget Version3.0RC8 => 3.0MP0
2011-05-11 16:44maiteIssue Monitored: maite
2011-05-17 09:15iperdomoPriorityurgent => normal
2011-05-17 13:41iperdomoPrioritynormal => urgent
2011-05-23 11:41hgbotCheckin
2011-05-23 11:41hgbotNote Added: 0037309
2011-05-23 11:41hgbotStatusscheduled => resolved
2011-05-23 11:41hgbotResolutionopen => fixed
2011-05-23 11:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/59534db679e31422f0b6b62684fd5a57a1d20d96 [^]
2011-05-26 07:46hudsonbotCheckin
2011-05-26 07:46hudsonbotNote Added: 0037532
2011-05-26 16:59maiteNote Added: 0037613
2011-05-26 16:59maiteStatusresolved => closed
2011-05-26 16:59maiteFixed in Version => 3.0MP0

Notes
(0037309)
hgbot   
2011-05-23 11:41   
Repository: erp/devel/pi
Changeset: 59534db679e31422f0b6b62684fd5a57a1d20d96
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Mon May 23 11:39:52 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/59534db679e31422f0b6b62684fd5a57a1d20d96 [^]

Fixes issue 17011: Added missing filterClass to request parameters

---
M modules/org.openbravo.userinterface.selector/web/org.openbravo.userinterface.selector/js/ob-selector-item.js
---
(0037532)
hudsonbot   
2011-05-26 07:46   
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/728387046be6 [^]

Maturity status: Test
(0037613)
maite   
2011-05-26 16:59   
verified.
When clicking on the pick-list, its attributes are displayed. And also when opening the search selector