Searches in a field indexed for FTS

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

Related topics

Running-searches

Finding-a-request-by-example

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

 

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