Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032940Openbravo ERPA. Platformpublic2016-05-12 12:262016-06-17 19:37
Reportercaristu 
Assigned Tocaristu 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q3 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032940: Not possible to filter string fields in Custom Query Selectors using equals operator
DescriptionIs not possible to filter string fields in Custom Query Selectors using equals operator
Steps To Reproduce1) Create a new business partner, with name = a
2) Go to [Sales Order] window
3) Create a new record in the header
4) Open the business partner selector pop-up
5) Type the following in the business partner name filter: ==a. Notice that in this case just the newly created business partner must be shown. But all the business partners that contains 'a' on their name are displayed instead.
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0032941 acknowledged Triage Platform Base Unexpected behavior when typing = character on selector string fields 
related to defect 0032942 acknowledged Triage Platform Base Is not possible to perform numeric comparisons on numeric filters in Custom Query Selectors 
related to defect 0035956 closed alostale The numeric field filter does not work with operators in HQL based selectors 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-05-12 12:26caristuNew Issue
2016-05-12 12:26caristuAssigned To => caristu
2016-05-12 12:26caristuOBNetwork customer => No
2016-05-12 12:26caristuModules => Core
2016-05-12 12:26caristuTriggers an Emergency Pack => No
2016-05-12 12:27caristuTag Attached: Performance
2016-05-12 12:29caristuSummaryNot possible to filter in Custom Query Selectors using equals operator => Not possible to filter string fields in Custom Query Selectors using equals operator
2016-05-12 12:29caristuDescription Updatedbug_revision_view_page.php?rev_id=12067#r12067
2016-05-12 12:34caristuSeveritymajor => minor
2016-05-12 12:43caristuRelationship addedrelated to 0032941
2016-05-12 12:47caristuRelationship addedrelated to 0032942
2016-05-12 14:00hgbotCheckin
2016-05-12 14:00hgbotNote Added: 0086400
2016-05-12 14:01hgbotStatusnew => resolved
2016-05-12 14:01hgbotResolutionopen => fixed
2016-05-12 14:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4631e87e35e753bae2704be096a2326b6657d562 [^]
2016-05-12 14:01caristuReview Assigned To => AugustoMauch
2016-05-18 16:35AugustoMauchNote Added: 0086553
2016-05-18 16:35AugustoMauchStatusresolved => closed
2016-05-18 16:35AugustoMauchFixed in Version => 3.0PR16Q3
2016-06-17 19:37hudsonbotCheckin
2016-06-17 19:37hudsonbotNote Added: 0087534
2017-05-25 08:38caristuRelationship addedrelated to 0035956

Notes
(0086400)
hgbot   
2016-05-12 14:00   
Repository: erp/devel/pi
Changeset: 4631e87e35e753bae2704be096a2326b6657d562
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Thu May 12 13:59:40 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4631e87e35e753bae2704be096a2326b6657d562 [^]

fixes issue 32940: allow iEquals operator in Custom Query Selectors
The criteria is being sent properly by the client side, but the iEquals operator was not being considered by the CustomQuerySelectorDatasource. It was filtering using a contains criteria instead.

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java
---
(0086553)
AugustoMauch   
2016-05-18 16:35   
Code reviewed and verified in pi@4631e87e35e7
(0087534)
hudsonbot   
2016-06-17 19:37   
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/0dc7be081b1c [^]
Maturity status: Test