Default language.

Searching in a field indexed for FTS

In most cases, performing a qualified search on a field indexed for  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  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  Search Options setting of the server
  • The type of full text index created for the field

 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  Search Options setting is set to Ignore Leading Wild Card,  ignores the wildcard that the user entered. See Using the query-by-example method for more information.

The  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*