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.