Restricting search criteria with a parametric FTS

Returning a large result set is a common issue with a search system. With a parametric full text search, users can restrict the search criteria by combining Full Text Search and non-FTS fields in a search.

To search with parametric FTS

  1. Open a form in which you want to search records. 
  2. In a field, enter the search criteria and use desired search operators.
    This qualification helps the server filter out irrelevant entries and reduce the size of the result set.

Users can search terms in multiple fields for a QBE search or specify an advanced search like the following example:

:<FTSfield> LIKE "firewall" AND 'Create Date' >= "01/01/21"

This qualification returns all entries that contain firewall and were created on or after January 1, 2021.

 

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