Performing a literal search
Unlike accrue searches and word or phrase searches (which are word based), the engine uses a literal search to find requests that match the string of characters based on the contents of the entire field. Literal searches are possible only if the field has been indexed for literal searching, and if it is, only literal searching is possible, not accrue searches or word or phrase searches. Literal searching is useful mainly for performing case-insensitive searching on short character fields, like name fields, with a very small set of requests matching the search criteria. However, you can add a leading or trailing wildcard to increase the scope of a literal search. If you use both a leading and trailing wildcard, a literal search becomes the equivalent of a word or phrase search. The syntax for the search qualification is:
For example, to search for the word firewall, enter:
With this example, a full text search finds requests where the entire content of the field is firewall (or Firewall if searching with case insensitivity).
The following table outlines the expected search results using a literal search.
Results of searches that use a literal search
Qualification | Example data | Matches |
<field> LIKE "firewall" | firewall blocks access | |
firewall will block access | ||
firewall blocking my access | ||
firewall blocked her access | ||
firewall did not block access | ||
have the firewall block access | ||
firewall is not working | ||
try blocking his access | ||
<field> LIKE "firewall will block access" | firewall blocks access | |
firewall will block access | + | |
firewall blocking my access | ||
firewall blocked her access | ||
firewall did not block access | ||
have the firewall block access | ||
firewall is not working | ||
try blocking his access | ||
<field> LIKE "%firewall%" | firewall blocks access | + |
firewall will block access | + | |
firewall blocking my access | + | |
firewall blocked her access | + | |
firewall did not block access | + | |
have the firewall block access | + | |
firewall is not working | + | |
try blocking his access | ||
<field> LIKE "firewall%" | firewall blocks access | + |
firewall will block access | + | |
firewall blocking my access | + | |
firewall blocked her access | + | |
firewall did not block access | + | |
have the firewall block access | ||
firewall is not working | + | |
try blocking his access | ||
<field> LIKE "blocks" | firewall blocks access | |
firewall will block access | ||
firewall blocking my access | ||
firewall blocked her access | ||
firewall did not block access | ||
have the firewall block access | ||
firewall is not working | ||
try blocking his access | ||
<field> LIKE "%blocks%" | firewall blocks access | + |
firewall will block access | ||
firewall blocking my access | ||
firewall blocked her access | ||
firewall did not block access | ||
have the firewall block access | ||
firewall is not working | ||
try blocking his access |