Using Wildcards in Search
ASM is entirely SQL based and supports wildcard searches using defined Wildcards.
Wildcards Accepted
You can use the following Wildcards in your searches:
% Percent Symbol
Match Any Sequence of Characters. Represents zero or more characters in a search.
Example: %out – All results that contain the word “out” at the end
Example: %out% – All results that contain the word “out” in any position
Example: Out% – All results that start with the word “Out”; Outlook, OutBound
_ Underscore
Matches a Single Character. Represents a single character in a search.
Example: SXY_0091 – All results where this reference is contained: SXY90091, SXY80091, SXY70091, and so on.
[ ] Square Brackets
Match Any Single Character within a Range or Set
Example: [JM]on - Jon, or Mon
Example:[A-D] - All items that start with A, B, C, or D
[^] Caret Enclosed in Square Brackets
Exclude Characters within a Range or Set
Example: [^Out]% - All results that do not start with “Out”
"-" Hyphen
Match or define a Range of Characters within Square Brackets.
Example: [A-F]% - Anything that starts with A through F
Example: [0-9]% - Anything that starts with 0 - 9
What is searched?
What is searched is determined by the entity you are searching.
Global Search (Portal)
Calls/Tickets = Description, Comments, Solution's Summary Requests = Title, Description, Authorization Comments Tasks = Description and History Knowledge = Title, Abstract, Solution, Additional Information field Bulletins = Body of the Bulletin
Text Based, Field-Level Searches
Search the related table/or linked tables for the data to call back.
Last updated