Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023530Openbravo ERP00. Application dictionarypublic2013-04-10 17:202013-04-30 21:05
Reportercaristu 
Assigned Tomtaal 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP23Fixed in Version3.0MP23 
Merge Request Status
Review Assigned Toalostale
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket19985
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023530: Filtering with a multiple value is not working properly
DescriptionIf the value of the filter consists of multiple parts then filtering won't work. The system is only searching on the first part.
Steps To ReproduceAs System Admin:
- Open Tables and Columns
- Select the C_BPARTNER table
- Open its column named Search Key, and check its Used as Record Identifier field.
- Select the C_ORDER table
- Change the reference of its C_BPARTNER_ID column from Search to Table

Compile and restart tomcat.

As F&B Admin:
- Open the Sales Order window
- Notice that in the Business Partner column the name is shown, but if its filter is opened, the options show the whole identifier (Search Key - Name).
- Try to filter that column. It won't work
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00231693.0MP22 closed AugustoMauch Dropdown column filters are not working properly with table reference 
related to defect 0036421 closed alostale Financial Account records are not filtered by name if the filter contains "-" 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-04-10 17:20caristuNew Issue
2013-04-10 17:20caristuAssigned To => AugustoMauch
2013-04-10 17:20caristuModules => Core
2013-04-10 17:20caristuOBNetwork customer => Yes
2013-04-10 17:20caristuSupport ticket => 19985
2013-04-10 17:20caristuResolution time => 1366149600
2013-04-10 17:20caristuTriggers an Emergency Pack => No
2013-04-10 17:24caristuIssue Monitored: networkb
2013-04-10 17:24caristuRelationship addedrelated to 0023169
2013-04-11 13:57AugustoMauchSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4564#r4564
2013-04-11 13:58AugustoMauchSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4565#r4565
2013-04-11 18:55mtaalAssigned ToAugustoMauch => mtaal
2013-04-29 17:00mtaalReview Assigned To => alostale
2013-04-29 17:01hgbotCheckin
2013-04-29 17:01hgbotNote Added: 0058304
2013-04-29 17:01hgbotStatusnew => resolved
2013-04-29 17:01hgbotResolutionopen => fixed
2013-04-29 17:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fe9816e9075614abc9dab971d0850bbd3071d62b [^]
2013-04-30 09:05alostaleNote Added: 0058318
2013-04-30 09:05alostaleStatusresolved => closed
2013-04-30 09:05alostaleFixed in Version => 3.0MP23
2013-04-30 21:05hudsonbotCheckin
2013-04-30 21:05hudsonbotNote Added: 0058384
2019-02-01 14:05caristuRelationship addedrelated to 0036421

Notes
(0058304)
hgbot   
2013-04-29 17:01   
Repository: erp/devel/pi
Changeset: fe9816e9075614abc9dab971d0850bbd3071d62b
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Mon Apr 29 17:01:03 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/fe9816e9075614abc9dab971d0850bbd3071d62b [^]

Fixes issue 23530: Filtering with a multiple value is not working properly
If the reference is a table ref with a display column then use the display column (or in fact its property) as the property to show in the combo box of the filter item, also do the filtering in the grid using this displaycolumn.

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-fk-filter.js
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/FKComboUIDefinition.java
M modules/org.openbravo.service.json/src/org/openbravo/service/json/DataEntityQueryService.java
M modules/org.openbravo.service.json/src/org/openbravo/service/json/DefaultJsonDataService.java
---
(0058318)
alostale   
2013-04-30 09:05   
Code reviewed + verified on pi@5521f678e840

Tested table, tableDir and search references
(0058384)
hudsonbot   
2013-04-30 21:05   
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/3ea22ca7a348 [^]

Maturity status: Test