OQL case sensitive PostgreSQL

0
This OQL querie works:  'SELECT CRM.EmailAddress Email,       CRM.RecordID RecordID,     CRM.Address Address,     CRM.Fullname Fullname,       CRM.RecordID RecordID,     CRM.ZipCode_City ZipCode_City FROM     AnimalRegister.CRM CRM WHERE     CRM.EmailAddress = ''' + $LowerEmail + ''' ' but lower(CRM.EmailAddress) = ''' + $LowerEmail + ''' doesn't work SELECT lower(CRM.EmailAddress) Email, has no effect, all gave errors. Solution?
asked
1 answers
2

Jan,

 

From the documentation I gather the lower is not a supported operator nor supported function. See https://docs.mendix.com/refguide/oql-operators and https://docs.mendix.com/refguide/oql-functions

So you’ll need to solve this in the model by having the data available or input as lowercase before running the query.

And maybe add the option for support of the lower and upper functions as an idea on the idea forum.

answered