Skip to Content

Default language.

Searching in a field indexed for FTS

In most cases, performing a qualified search on a field indexed for FTS returns results consistent with a database search. Users can still use the search strings and search patterns they are already familiar with.

The search method that the FTS engine uses depends on the following factors:

  • The original search criteria entered by the user
  • The query-by-example (QBE) match settings of the field
  • The FTS Search Options setting of the server
  • The type of full text index created for the field

FTS uses these factors to determine the final search criteria. Succeeding factors override preceding factors. For example, if a user includes a leading wildcard as part of a full text search but the FTS Search Options setting is set to Ignore Leading Wild Card, FTS ignores the wildcard that the user entered. See Using the query-by-example method for more information.

The FTS engine uses the final search criteria to search the contents of all requests indexed for that field, and it uses one of the following search methods:

  • Word or phrase search
  • Accrue search
  • Literal search
Warning

Note

All the following examples use FTS in the Advanced Search Bar, not QBE. They assume that the FTS Search Option is set to Query Unchanged.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

Remedy Action Request System 20.02