Full-Text Search

Full-text searches are commonly used all across Domino, and can now be integrated directly into a DQL query via a standalone term in the form: @FTSearch(‘<QUERY>’)or @FTS(‘<QUERY>’)

Where <QUERY> is your full-text syntax query; you must still write the parentheses and the enclosing single quotes as part of DQL’s syntax processing. The function name is case-insensitive.

@FTSearch() is a standalone term that returns the set of documents which matches the given full-text query, meaning that you cannot use any operators after it, only Booleans.

For example:

This query shows an @FTSearch() term being AND’d with a normal date term.

@FTSearch(‘[TextField1] = (hello)’) AND DateField1 > @dt(‘2023-06-12T04:17:31-04:00’)

This query shows an @FTSearch() term being OR’d with an IN-term

IN ALL (‘view1’, ‘view2’) OR @FTS(‘[name] < (b)’)

Since @FTSearch always returns a document set and nothing else, you should not try to use an operator with it like:

@FTSearch(‘[NumberField1] = (120)’) >= 100

This is invalid syntax.

The maximum size for a query string is 256 bytes. DQL will not validate the query syntax, that is handled by the full-text search engine itself.

Syntax rules for full-text queries is the same as the FTSearch() function in LotusScript/ Java classes and the C API. See: How can I refine a search query using operators? in HCL Notes documentation.