Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035839Retail ModulesWeb POSpublic2017-04-25 19:152017-04-27 14:00
Reporteradrianromero 
Assigned ToRetail 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035839: [SER-QA 2593] Remote search does not take into account accent characters
DescriptionIn local mode, searchs are done using the browser WEBSQL database and here the funciton OB.UTIL.unAccent() is used to make search in customers, orders etc not dependant on accents and other characters considered "equal" like "ae" and "æ", or "c" and "ç"
In remote mode searchs are done in postgresql side using SQL, and in the server side is not trivial to implement this kind or search.
In any case this topic is in the Retail side and it is the Retail team who has to provide a proposal to fix this and implement it.

Note: Product search does not take into account accent characters even in local model
Steps To Reproduce* In the backend change the name of the business partner "Arturo Montoro" by "Artúro Montoro"
* Log in Web POS, open the customers selector and filter by "Arturo"
* Observe the business partner "Artúro Montoro" is displayed
* Go to the back end and activate the preference "Enable Remote for Customer"
* Log in in Web POS again, open the customers selector and filter by "Arturo"
* Observe that now the business partner "Artúro Montoro" does not appear.
Proposed Solution
Additional Information
TagsSER-QA
Relationships
related to feature request 0025897 acknowledged Triage Platform Base Openbravo ERP Transform special characters (such as accents) when filtering 
related to defect 0047992 closed Retail Retail Modules Issue with customer search box 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-04-25 19:15adrianromeroNew Issue
2017-04-25 19:15adrianromeroAssigned To => Retail
2017-04-25 19:15adrianromeroResolution time => 1494280800
2017-04-25 19:15adrianromeroTriggers an Emergency Pack => No
2017-04-25 19:15adrianromeroTag Attached: SER-QA
2017-04-26 12:31ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2017-04-26 12:31ranjith_qualiantech_comStatusnew => scheduled
2017-04-27 12:55marvintmNote Added: 0096226
2017-04-27 12:55marvintmTypedefect => feature request
2017-04-27 12:55marvintmRelationship addedrelated to 0025897
2017-04-27 14:00ranjith_qualiantech_comStatusscheduled => acknowledged
2017-04-27 14:00ranjith_qualiantech_comAssigned Toranjith_qualiantech_com => Retail
2021-11-22 07:33marvintmRelationship addedrelated to 0047992

Notes
(0096226)
marvintm   
2017-04-27 12:55   
We don't consider this topic to be a simple defect, it's a feature request which should be resolved in a general way across all Openbravo platforms and applications. Check related feature request reported for the platform team.