Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017010Openbravo ERPA. Platformpublic2011-05-04 17:212011-05-26 17:44
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 customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017010: Default Expression in new selectors not working for search reference type column
DescriptionIf a default expression is set for a field in a OBUISEL type selector, and this field is a search type (such as product id) the filtering is not properly done.

It works OK with the pick-list icon, but if the magnifying glass icon is clicked, in the pop-up no values are retrieved because the filtering is not fine.

In my example, when I open the search pop-up, I get "Vino Tinto 0.75L" default filter on the "article" column, which is correct, but no results are displayed. And there should be. If a delete an "L" (so I get "Vino Tinto 0.75" in the filter, I do get results.
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'
- In Defined Selector Field create 4 new fields:
  * Movement date - Property: movementDate
  * Identificator - Property: _identifier
  * Attribute - Property: attributeSetValue
  * Article - Property: product. Default Expresion: OB.getParameters().get('inpmProductId'). With this default expresion, the filter should show only the attributes of the selected product.
For all the fileds 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 Search 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. Click on the magnifying glass icon. The search pop up will be displayed. Check that it is filtering the article column with "Vino Tinto 0.75L". But - no results.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00170113.0MP0 closed iperdomo Filter expression in OBUISEL selectors not filtering 
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 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:21AinhoaPagolaNew Issue
2011-05-04 17:21AinhoaPagolaAssigned To => alostale
2011-05-04 17:21AinhoaPagolaModules => Core
2011-05-04 17:32AinhoaPagolaRelationship addedrelated to 0016980
2011-05-04 17:33AinhoaPagolaRelationship addedrelated to 0016979
2011-05-04 17:34AinhoaPagolaRelationship addedblocks 0017006
2011-05-04 17:35AinhoaPagolaRelationship deletedblocks 0017006
2011-05-04 17:35AinhoaPagolaRelationship addedrelated to 0017006
2011-05-04 17:37AinhoaPagolaRelationship addedrelated to 0017008
2011-05-04 17:37AinhoaPagolaIssue Monitored: networkb
2011-05-04 17:37AinhoaPagolaRelationship addedrelated to 0017011
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:45maiteIssue Monitored: maite
2011-05-17 09:15iperdomoPriorityurgent => normal
2011-05-17 13:41iperdomoPrioritynormal => urgent
2011-05-23 13:36iperdomoNote Added: 0037327
2011-05-23 13:36iperdomoStatusscheduled => resolved
2011-05-23 13:36iperdomoFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/59534db679e31422f0b6b62684fd5a57a1d20d96 [^]
2011-05-23 13:36iperdomoResolutionopen => fixed
2011-05-26 17:44maiteNote Added: 0037620
2011-05-26 17:44maiteStatusresolved => closed
2011-05-26 17:44maiteFixed in Version => 3.0MP0

Notes
(0037327)
iperdomo   
2011-05-23 13:36   
This issue gets fixed with same change issue 0017011
(0037620)
maite   
2011-05-26 17:44   
verified.
If you set a "Default Expression" you should specify which field are you using to identify it in Property field, for example:
* default expression like: OB.getParameters().get('inpmProductId')
* then property should be: product.id