Skip to Content
Information
This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

Using wildcard symbols in the advanced search bar

When you specify search criteria to find requests, you can use wildcard symbols as shown in the following table to indicate one or more characters.

Wildcards

In the advanced search bar, wildcard symbols are interpreted as wildcards only when used with the LIKE operator; otherwise, they are interpreted as explicit characters. You must use the percent symbol (%) when you want to include leading or trailing characters in your search. For example, if you want to find all requests submitted by Jill Bobbington, Bobby Fenton, and Bob Comptonson, enter the following text in the advanced search bar:

'Submitter' LIKE "%Bob%ton%"

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

AR System 21.05