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:

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