Performing a literal search

Unlike accrue searches and word or phrase searches (which are word-based), the FTS 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 

 ~|

 ~|

 ~|

 |

|

 |

|

 |

|

 |

|

 |

|

 |

|