Skip to Content
  2. Mailing Lists
  3. Contributors
  4. Re: Special way of searching for products

Archives

Contributors

Re: Special way of searching for products

Re: Special way of searching for products

Few ideas based on postgresql:

* not sure if it's possible with SIMILAR TO or ~ operators
* investigate extension

regards,

Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik <radovan@skolnik.info> a écrit :
Hello,

I have been asked few times by users if it is possible to search for products 
in a way omitting special characters (like dash or space for exmaple) from 
product's default_code (or even input string). Let me give an example:

Let's say we have a product with default_code like CD-12345-XYZ In current 
situation if user enteres "CD12345" or "CD 12345" nothing is retrieved. Vice 
versa, if the default_code is CD12345XYZ and user enters "CD-12345" or "CD 
12345" nothing is retrieved either. So the solution would be to first remove 
those special characters from the string being searched for and then search 
for default_code transformed with some (SQL?) function.

Is anything like that possible? One idea comes to mind using computed field 
where that stripped deault_code would be stored and extending default search 
to use this. However that would require stored computed field. Any way to 
prevent this?

Thank you. Best regards

	Radovan Skolnik

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe



--
Pierre
by Pierre Verkest - 11:41 - 28 Apr 2021

Reference

  • Special way of searching for products 
    Hello,

I have been asked few times by users if it is possible to search for products 
in a way omitting special characters (like dash or space for exmaple) from 
product's default_code (or even input string). Let me give an example:

Let's say we have a product with default_code like CD-12345-XYZ In current 
situation if user enteres "CD12345" or "CD 12345" nothing is retrieved. Vice 
versa, if the default_code is CD12345XYZ and user enters "CD-12345" or "CD 
12345" nothing is retrieved either. So the solution would be to first remove 
those special characters from the string being searched for and then search 
for default_code transformed with some (SQL?) function.

Is anything like that possible? One idea comes to mind using computed field 
where that stripped deault_code would be stored and extending default search 
to use this. However that would require stored computed field. Any way to 
prevent this?

Thank you. Best regards

	Radovan Skolnik
    by Radovan Skolnik - 10:14 - 28 Apr 2021