Wildcard Characters
Wildcard characters can be used in filter expressions.
The following wildcard characters can be used:
?Matches any single character.*Matches any string of zero or more characters.
If you want to search for a string that actually contains these characters, you must escape them using \.
For example, the string "fr\?d" (with the ? character escaped) results in a query using "fr?d".
Unsupported Characters
You cannot filter or sort on an expression containing a single quote character, and you cannot escape the quote character using \. For example, filtering on the following expression returns an error:
(priority = 1) OR ((priority < 12) AND (priority > 4)) OR (description='fred o’shea')
To filter on a string like this, use a wildcard character, such as
'fred o*shea' or
'fred o?shea'.