Function EN Version 5.00

@OpenFtSearch

Database Search

Syntax

@OpenFtSearch(DBHANDLE1;TEXTQUERY2;FNOPTIONS3);
@OpenFtSearch(DBHANDLE1;TEXTQUERY2;FNOPTIONS3;VIEWHANDLESEARCHVIEW4);

Description

Opens in the database with the DBHANDLE DBHANDLE1 a full-text search with the search string TEXT TEXTQUERY2 and the options FN FNOPTIONS3.
The parameter VIEWHANDLE VIEWHANDLESEARCHVIEW4 is reserved.
This @Function is available only as of Notes version 4.5.

TEXT TEXTQUERY2:
The search string can contain the words to search for, or extended syntax can be used to search in specific fields, etc.
For details, see the Notes/Domino documentation for full-text search.

Example:
"printer" or "field Description contains printer"

FN FNOPTIONS3:
DEC   HEX   BIT   Meaning

0000001   000001   01   Reserved   Reserved
0000002   000002   02   Number of hits only   Returns only the number of hits
0000004   000004   03   Reserved   Reserved
0000008   000008   04   Sorted by score   Sorted by score (default)
0000016   000010   05   Return ID table   Returns an IDLIST
0000032   000020   06   Sorted by date   Sorted by date
0000064   000040   07   Sort in ascending order   Sorted in ascending order
0000128   000080   08   Reserved   Reserved
0000256   000100   09   Reserved   Reserved
0000512   000200   10   Stem words in this query   Also searches for stemmed words (e.g. print -> printer, printing, printed …)
0001024   000400   11   Thesaurus words in this query   Thesaurus words in this search
0002048   000800   12   Reserved   Reserved
0004096   001000   13   Reserved   Reserved
0008192   002000   14   Reserved   Reserved
0016384   004000   15   Fuzzy search wanted   Fuzzy search
0032768   008000   16   Reserved   Reserved
0065536   010000   17   Reserved   Reserved
0131072   020000   18   Reserved   Reserved
0262144   040000   19   Domain search   A domain is searched
0524288   080000   20   Reserved   Reserved
1048576   100000   21   Search the file system (used with domain search)   Searches the file system (only in connection with domain search)
2097152   200000   22   Search the DB index (used with domain search)   Searches the database index (only in connection with domain search)

Return value:
If the @Function is executed successfully, an FTSEARCHHANDLE is returned; otherwise @ERROR.

Example: @OpenFtSearch(DBHANDLE1;TEXTQUERY2;FNOPTIONS3);

DBHANDLE1:=@OpenDB("TEST.NSF");
FTSHANDLE:=@OpenFtSearch(DBHANDLE1;"print";8);
FTSHANDLE:=@CloseFtSearch(FTSHANDLE);
DBHANDLE1:=@CloseDB(DBHANDLE1);

A full-text search is opened for the database "TEST.NSF" and the search string "print" opened. The option 8 must be specified.
The full-text search is then closed again (without searching).

Note : This text was machine-translated and may contain inaccuracies.