Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0025897
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformminorhave not tried2014-03-04 15:132022-02-01 08:09
ReporteralostaleView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0025897: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
has duplicate defect 0029198 closedAugustoMauch Openbravo ERP Window filters do not work correctly with accentuated words. 
has duplicate feature request 0019027 closedmarvintm Openbravo ERP Filter capability should be case insensitive, ignore accents and other odd characters depending on the locale 
has duplicate defect 0037704 closedplatform Openbravo ERP Ignore accents in filters and selectors 
has duplicate defect 0040249 closedplatform Openbravo ERP Business partner filtering by name discriminate between marked vowel and not marked 
has duplicate defect 0047992 closedRetail Retail Modules Issue with customer search box 
related to feature request 0035839 acknowledgedRetail Retail Modules [SER-QA 2593] Remote search does not take into account accent characters 
blocks defect 00257403.0PR14Q2 closedAugustoMauch Openbravo ERP Grid filters does not discriminate accents 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2014-03-04 15:13 alostale New Issue
2014-03-04 15:13 alostale Assigned To => AugustoMauch
2014-03-04 15:13 alostale Modules => Core
2014-03-04 15:13 alostale Triggers an Emergency Pack => No
2014-03-04 15:14 alostale Relationship added blocks 0025740
2015-03-10 15:08 alostale Relationship added has duplicate 0029198
2016-07-14 12:05 alostale Relationship added has duplicate 0019027
2016-07-14 12:06 alostale Assigned To AugustoMauch => platform
2016-07-14 12:06 alostale Status new => acknowledged
2017-04-27 12:55 marvintm Relationship added related to 0035839
2018-01-23 13:22 alostale Relationship added has duplicate 0037704
2019-02-22 11:00 alostale Relationship added has duplicate 0040249
2021-11-22 07:32 marvintm Relationship added has duplicate 0047992
2022-02-01 08:09 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker