Community mailing list archives
Re: domain operator in is case sensitiveby
Skillteam, Houssine BAKKALI
finally i've lowered the case of the field in the db.would be nice to have such operator in the futur.
2016-09-10 12:07 GMT+02:00 Graeme Gellatly <firstname.lastname@example.org>:
Then a functional stored field that is basically str.lower() is the best solution.On Sat, 10 Sep 2016 7:18 PM Houssine BAKKALI <email@example.com> wrote:
Tha list of values can be quiet long. So I'm afraid it's not applicable in my use can.
Thanks for your answer though.Le 9 sept. 2016 11:37 PM, "Daniel Reis" <firstname.lastname@example.org> a écrit :Use an OR with several ILIKEs.
No dia 09/09/2016, às 09:34, Houssine BAKKALI <email@example.com> escreveu:
=ilike operator do not seem to apply on list...for example searching partner with email is in a list of emails but partner that have their email with a letter capitalized aren't returned... Same can go for names...Hi Community,
I was wondering if there is a way to have a domain filter that check if a field value is in a list of value but without taking care of case insensitive way?
Maybe I'm not aware of a operator allowing this
Thanks for your answer