You need to sign in to do that
Don't have an account?
Eric Blaxton 11
How to pass single quote in Odata 4.0 query
Hi and thanks in advance.
I wrote an OData query and it worked until I added a Not Contains filter
Thank you,
Eric
I wrote an OData query and it worked until I added a Not Contains filter
String exclude = 'Variance';
and%20not%20contains(shortDescription,'+ exclude +')Resulting query is:
not%20contains(shortDescription,Variance)My question is how do I get single quotes around the variable.
Thank you,
Eric
I created a variable which contains the single quotes like this:
Then in the Odata 4.0 query I added the variable like this:
All Answers
Any SOQL query for the external object should be in below format.
Reference:
https://help.salesforce.com/articleView?id=odata_query_string_options.htm&type=5#system_query_option_count
Thanks,
I created a variable which contains the single quotes like this:
Then in the Odata 4.0 query I added the variable like this: