I am trying to get all partners that have a certain email address. The issue is, however, that the email addresses in our database are not sanitised, and thus that they can contain capital letters. I can not change this in the database.
As capitalisation does not matter for the email protocol, I would like to search on email address case insensitive.
Code:
models.execute_kw(db, uid, password,
'res.partner', 'search_read',
[[['email', operator, email]]],
{'fields': [], 'limit': 20}
Thank you for your response!
PS: Bonus points to additionally remove sensitivity to points (".") for e.g. Gmail addresses.