Conducts a full-text search of all the documents in a database.

Defined in

NotesDatabase

Syntax

Set notesDocumentCollection = notesDatabase.FTSearch( query$, maxdocs%, [ sortoptions% ], [ otheroptions% ] )

Parameters

query$

String. The full-text query. See below for the syntax.

Integer. The maximum number of documents you want returned from the query. Set this parameter to 0 to retrieve all documents (up to 5,000 - see the Usage section for more details) that meet the search criteria.

Integer. Optional. Sorting options. Choose one.
• FT_DATE_ASC (64) sorts by document date in ascending order.
• FT_DATE_DES (32) sorts by document date in descending order.
• FT_DATECREATED_ASC (1543) sorts by document creation date in ascending order.
• FT_DATECREATED_DES (1542) sorts by document creation date in descending order.
• FT_SCORES (8) sorts by relevance score (default).

Integer. Optional. Search options. Combine options by adding.
• FT_DATABASE (8192) includes Domino databases.
• FT_FUZZY (16384) searches for related words. Need not be an exact match.
• FT_FILESYSTEM (4096) includes files that are not Domino databases.
• FT_STEMS (512) uses stem words as the basis of the search.
• FT_THESAURUS (1024) uses thesaurus synonyms.

notesDocumentCollection

NotesDocumentCollection. A collection of documents that match the full-text query, sorted by the selected option.

This method is the same as FTSearchRange less the start parameter.

If the database is not full-text indexed, this method works, but less efficiently. To test for an index, use the IsFTIndexed property in NotesDatabase. If the full-text is not updated after changes are made, it does not fully reflect the content of the database. To create or update an index on a local database, use the UpdateFTIndex method.

This method returns a maximum of 5,000 documents by default. The Notes.ini variable FT_MAX_SEARCH_RESULTS overrides this limit for indexed databases or databases that are not indexed but that are running in an agent on the client. For a database that is not indexed and is running in an agent on the server, you must set the TEMP_INDEX_MAX_DOC Notes.ini variable as well. The absolute maximum is 2,147,483,647.

This method searches all of the documents in a database. To search only documents found in a particular view, use the FTSearch method in NotesView. To search only documents found in a particular document collection, use the FTSearch method in NotesDocumentCollection.

If you don't specify any sort options, the documents are sorted by relevance score. When the collection is sorted by relevance the highest relevance appears first. To access the relevance score of each document in the collection, use FTSearchScore in NotesDocument.

If you ask for a sort by date, you don't get relevance scores. If you pass the resulting DocumentCollection to a NotesNewsletter object, it formats its doclink report with either the document creation date or the relevance score, depending on the sort options.

If the database has a multi-database index, you get a multi-database search. Navigation through the resulting document collection may be slow, but you can create a newsletter from the collection.

If the collection is empty, the Count property for the returned NotesCollection is 0.

Query syntax

To search for a word or phrase, enter the word or phrase as is, except that search keywords must be enclosed in quotes. Remember to escape quotes if you are inside a literal.

Wildcards, operators, and other syntax are permitted. For the complete syntax rules, see "Refining a search query using operators" in Lotus Notes Help. Search for "query syntax" in the Domino Designer Eclipse help system or information center (for example, http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp), both of which include Lotus Notes.

Language cross-reference

FTSearch method in Java Database class

Example
See Also

Collecting documents by searching in LotusScript classes

Glossary