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 FTS and non-FTS fields in a search. Doing so helps the server filter out irrelevant entries and dramatically 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.