External Objects case-sensitive queries

Issue

My queries on External Objects from within Salesforce are case sensitive, making searches where case sensitivity is undesired difficult. Can I use case insensitive search with Heroku Connect?

Resolution

Unfortunately, there really is no way to do this when using External Objects with Heroku Connect.

Here is an example of how this might be worked around when using OData directly.

The eq operator is intended to results that match case-sensitive strings. In order for a query to be case-insensitive, one can use tolower or toupper in order to normalize the text.

An 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
Terms of Service Privacy Cookies © 2019 Salesforce.com