Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017759Openbravo ERPA. Platformpublic2011-06-21 17:082011-08-03 08:03
Reporteregoitz 
Assigned Toadrianromero 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP2Fixed in Version3.0MP2 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesUser Interface Selector
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017759: The popup of selector does not filter properly when defining "start with" filtering
DescriptionThe popup of selector does not filter properly when defining "start with" filtering.
The popup filters only with content.

Steps To Reproduce-Access as System Administratro
-Go to tables and columns window.
-Find c_orderline table, and m_product_id column
-Check the reference assigned to this product.
  The reference is Product.
-go to "defined selector tab" and look that "Popup Text Match Style" combo has the value "start with" selected.

-Logout
-Login as Openbravo admin
-Go to sales order window.
-Create a header and go to lines.
-Click on new.
-Open the product popup select
-Try filtering the products that start with A.
*See that the filtering is done with content instead of "Start with"

The same problem happens while filtering on the selector without open the popup
althogh the filtering is also set to "Starts with"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0035956 closed alostale The numeric field filter does not work with operators in HQL based selectors 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-06-21 17:08egoitzNew Issue
2011-06-21 17:08egoitzAssigned To => alostale
2011-06-21 17:08egoitzModules => User Interface Selector
2011-06-21 17:08egoitzOBNetwork customer => Yes
2011-06-21 17:10egoitzNote Added: 0038417
2011-06-21 17:10egoitzPriorityurgent => high
2011-06-21 17:10egoitzSeveritymajor => minor
2011-06-21 17:10egoitzTarget Version3.0MP3 => 3.0MP2
2011-06-21 17:56egoitzNote Deleted: 0038417
2011-06-21 17:57egoitzSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=2272#r2272
2011-06-27 10:40alostaleStatusnew => scheduled
2011-06-27 10:40alostaleAssigned Toalostale => iperdomo
2011-06-27 10:40alostalefix_in_branch => pi
2011-07-13 13:22iperdomoAssigned Toiperdomo => adrianromero
2011-07-15 13:24hgbotCheckin
2011-07-15 13:24hgbotNote Added: 0039088
2011-07-15 13:24hgbotStatusscheduled => resolved
2011-07-15 13:24hgbotResolutionopen => fixed
2011-07-15 13:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ae37bf8bbd8a2c44eb6fdc5405b938e7fcd2221a [^]
2011-07-15 13:30adrianromeroNote Added: 0039091
2011-08-01 14:19hudsonbotCheckin
2011-08-01 14:19hudsonbotNote Added: 0039602
2011-08-03 08:03egoitzNote Added: 0039792
2011-08-03 08:03egoitzStatusresolved => closed
2011-08-03 08:03egoitzFixed in Version => 3.0MP2
2017-05-25 08:38caristuRelationship addedblocks 0035956

Notes
(0039088)
hgbot   
2011-07-15 13:24   
Repository: erp/devel/pi
Changeset: ae37bf8bbd8a2c44eb6fdc5405b938e7fcd2221a
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Fri Jul 15 13:23:05 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ae37bf8bbd8a2c44eb6fdc5405b938e7fcd2221a [^]

Fixes issue 0017759: The popup of selector does not filter properly when defining "start with" filtering
It has been added to the OBGrid js object the correct operator property in fields and also has been modified the class CustomQuerySelectorDatasource to take into account the operator value

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java
M modules/org.openbravo.userinterface.selector/web/org.openbravo.userinterface.selector/js/ob-selector-item.js
---
(0039091)
adrianromero   
2011-07-15 13:30   
* Testing the issue

Follow the steps to test and verify that now when filtering in the Products selector the criteria is "Starts with", if writting "A", it only shows the products starting by "A"

Verify also that the Business Partners Selector also filters with the criteria "Starts with" In the Business Partners case the error was in the datasource. Previous to this fix, the selector data source for Business partners did not take into account the filter criteria, it was hardcoded.

* Other areas affected

It has been modified only the creation of the selector grid in javascript and the HQL sentence generation in the custom selector datasource, no other areas affected.
(0039602)
hudsonbot   
2011-08-01 14:19   
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/cf2afed6e8ef [^]

Maturity status: Test
(0039792)
egoitz   
2011-08-03 08:03   
Verified. Working properly now.