Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025897Openbravo ERPA. Platformpublic2014-03-04 15:132022-02-01 08:09
Reporteralostale 
Assigned ToTriage Platform Base 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
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
Summary0025897: Transform special characters (such as accents) when filtering
DescriptionWhen filtering, in some occasions it makes sense to consider accented characters identical to non accented ones.

So for example filtering for "Perez" would return records with "Pérez" and "Perez".

But implementing this behavior as default has 2 problems:
1. Performance: this requires to change the DB query to something like select * from table where tranform(column) = transform(param), this causes not to be possible to apply regular indexes defined on table.column.
2. Transformation of special characters can vary depending the language in use
Steps To ReproduceSee 0025740
Proposed Solution* By default current behavior should still be used ('é' != 'e').
* Special characters transformers should be defined in AD, they would be PL function in charge of doing the transformations.
* Using grid configuration is would be possible to use these transformers at system, tab or field level

Note: adaptive filtering should use the same transformations, so it might be required to duplicate the pl code in javascript or to disable adaptive filtering for fields using it.
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0029198 closed AugustoMauch Openbravo ERP Window filters do not work correctly with accentuated words. 
has duplicate feature request 0019027 closed marvintm Openbravo ERP Filter capability should be case insensitive, ignore accents and other odd characters depending on the locale 
has duplicate defect 0037704 closed platform Openbravo ERP Ignore accents in filters and selectors 
has duplicate defect 0040249 closed platform Openbravo ERP Business partner filtering by name discriminate between marked vowel and not marked 
has duplicate defect 0047992 closed Retail Retail Modules Issue with customer search box 
related to feature request 0035839 acknowledged Retail Retail Modules [SER-QA 2593] Remote search does not take into account accent characters 
blocks defect 00257403.0PR14Q2 closed AugustoMauch Openbravo ERP Grid filters does not discriminate accents 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-03-04 15:13alostaleNew Issue
2014-03-04 15:13alostaleAssigned To => AugustoMauch
2014-03-04 15:13alostaleModules => Core
2014-03-04 15:13alostaleTriggers an Emergency Pack => No
2014-03-04 15:14alostaleRelationship addedblocks 0025740
2015-03-10 15:08alostaleRelationship addedhas duplicate 0029198
2016-07-14 12:05alostaleRelationship addedhas duplicate 0019027
2016-07-14 12:06alostaleAssigned ToAugustoMauch => platform
2016-07-14 12:06alostaleStatusnew => acknowledged
2017-04-27 12:55marvintmRelationship addedrelated to 0035839
2018-01-23 13:22alostaleRelationship addedhas duplicate 0037704
2019-02-22 11:00alostaleRelationship addedhas duplicate 0040249
2021-11-22 07:32marvintmRelationship addedhas duplicate 0047992
2022-02-01 08:09alostaleAssigned Toplatform => Triage Platform Base

There are no notes attached to this issue.