This documentation supports the 20.02 version of Remedy Action Request (AR) System.

To view an earlier version, select the version from the Product version menu.

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:


Use this wildcard:To match these characters:
% (Percent)Matches any string of 0 or more characters. For example: J%son matches Jackson, Johnson, Jason, and Json.
_ (Underscore)Matches any single character. For example: B_b matches Bab, Bob, and Bub.
- (Hyphen)Indicates a range. Always use within square brackets ([]).
[ ] (Square brackets)Matches any single character within a specified range or set. For example, [a-f] matches the range of characters a through f, and [abcf] matches the set of characters a, b, c, or f.
[^] (Square brackets with caret)Matches any single character not within a specified range or set. For example, [^a-f] matches all characters except the range a through f, and [^abcf] matches all characters except a, b, c, or f.

 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%"


Square brackets and the symbols associated with them do not work with Oracle databases.

Was this page helpful? Yes No Submitting... Thank you