Using Wildcards in Search
ASM is entirely SQL based and supports wildcard searches using defined Wildcards.
Last updated
Was this helpful?
ASM is entirely SQL based and supports wildcard searches using defined Wildcards.
Last updated
Was this helpful?
You can use the following Wildcards in your searches:
% Percent Symbol (except as noted )
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
Known Issue: Unexpected Behavior. Using wildcards (%) in the Global Search widget causes Self-Service Portal Menus to behave unpredictably. This is resolved in ASM 10.6.9.14628.
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
Search the related table/or linked tables for the data to call back.
What is searched is determined by the entity you are actively searching, exceot for as noted in the below.