Issue
My queries on Heroku External Objects from within Salesforce are case sensitive, making searches where case sensitivity is undesired difficult. Can I use case insensitive search with Heroku External Objects?
Resolution
Unfortunately, there isn't a direct way to run case-insensitive queries when using Heroku External Objects with Heroku Connect - see Heroku External Objects: limitations. The eq
operator is intended to results that match case-sensitive strings.
To work around this behavior and achieve case-insensitive querying, you can use tolower
or toupper
in order to normalize the text being compared with eq
. For example:
/opportunities?$filter=tolower(Name) eq tolower('My Opportunity')
This would match Opportunity records with a Name
of "My Opportunity", "MY OPPORTUNITY" or "my opportunity".