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