Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019027Openbravo ERPF. Localizationpublic2011-11-09 14:242016-07-14 12:05
Reportericiordia 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityN/A
StatusclosedResolutionduplicate 
PlatformOS5OS Versionany
Product Versionpi 
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
Summary0019027: Filter capability should be case insensitive, ignore accents and other odd characters depending on the locale
DescriptionOpenbravo seach capability should be configurable to:
-Be case sensitive/insensitive
-Trim blank spaces
-Ignore accents and other odd characters (localization packs should be allowed to deploy "replacement characters")

It should be done while taking care of performance (indexes should be created based on that transformation). This configuration should be optional (if not configured the system will not create any infrastructure)
Steps To ReproduceN/A
Proposed SolutionCreate a new windows (at system level) where all these configurations are defined, including a tab for replacement of characters that can be filled by localization packs.

Create a process that generates a db function to transform text as per this definition.

Add a process that generates/refreshes db function indexes (based on the previous function) to all text columns (or to some columns defined in the AD, tbd).

Automate the process to generate the function and create/refresh indexes as soon as the informaiton in the configuration window is updated
Additional Information
TagsPerformance
Relationships
duplicate of feature request 0025897 acknowledged Triage Platform Base Transform special characters (such as accents) when filtering 
related to design defect 0018321 closed alostale On the new selectors the filtering is accent senstitive 
related to defect 00166233.0MP1 closed alostale CustomQuerySelectorDatasource is very inefficient when filtering using a foreign key reference 
related to defect 0020565 closed alostale Ignore accents when retrieving info from any field 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-11-09 14:24iciordiaNew Issue
2011-11-09 14:24iciordiaAssigned To => marvintm
2011-11-09 14:24iciordiaModules => Core
2011-11-09 14:25iciordiaDescription Updatedbug_revision_view_page.php?rev_id=2891#r2891
2011-11-09 16:48shuehnerRelationship addedrelated to 0018321
2011-11-09 16:48shuehnerIssue Monitored: shuehner
2011-11-09 16:50dbazRelationship addedrelated to 0016623
2012-05-22 09:30alostaleTag Attached: Performance
2012-05-22 09:31alostaleRelationship addedrelated to 0020565
2012-05-22 10:12emartinezIssue Monitored: emartinez
2016-07-14 12:05alostaleRelationship addedduplicate of 0025897
2016-07-14 12:05alostaleStatusnew => closed
2016-07-14 12:05alostaleResolutionopen => duplicate

There are no notes attached to this issue.