How can I run case-sensitive queries with Heroku External Objects?

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".

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support