| |
|
ftsyntax
** Extracted from the Lotus Knowledge Base **
Domino R5 Supported Syntax for Full Text Searching
The following chart demonstrates the supported syntax for Domino 5.x full text searching:
Full Text Search Syntax Chart
Note the following:
1. Field names must be part of documents in different databases.
2. The key words and operators are not flagged as syntax errors, they are treated as lookup literals.
3. Though current functionality is questionable, reserve words preserved against future functionality.
ADVANCED SEARCH SYNTAX
Precedence rules. Rightmost always takes precedence always, so reversing the order changes results.
| Operator/Expression Syntax | Example | Action |
| ACCRUE with Proximity | Cat ACCRUE Dog Near Water | Find documents that contain both "Cat and Dog, then find Water near Dog |
| ANDs with ORs and NOTs | Cat AND ! Dog OR Fish | Find documents that contain "Cat" but not "Dog" or contain "Fish" |
| Field search with Case Sensitive | FIELD body CONTAINS EXACTCASE Dog OR EXACTCASE fiSH | Find documents whose body field contains a case-sensitive "Dog" or contain anywhere a case-sensitive "fiSH" |
| Weighted search and ORs | TERMWEIGHT 20 Dog OR TERMWEIGHT "Fish" OR TERMWEIGHT 80 Cat | Find documents with either "Dog" or "Fish" or "Cat", rank them by the sum of their termweights |
| ORs and NOTs | Dog OR ! Fish | Find documents that have "Dog" or don't have "Fish", rank those highest for which both conditions are true |
Note that the NEAR proximity parameter is not supported with GTR in R5:
R4.x full-text options no longer supported in R5
- Thesaurus
- The "Stop Word" file option is no longer used when creating a full-text index
- The word proximity/breaking operator "NEAR"
Searching for Header Information (Search by Date Created or Modified)
The "Add Search" button that appears beside the full-text-search entry area in agents allows you to search for documents "By date created" and "By date modified". If you need to write such queries yourself (for instance, to use with the FTSearch method), you can use the following special item names:
| Header Field | Item name |
| CREATION DATE | _CreationDate |
| REVISION DATE | _RevisionDate |
| DB TITLE (domain index only) | _Title |
| DB CATEGORIES (domain index only) | DbCategories |
| NOTE TITLE | _Note_Title |
| AUTHOR | _Note_Author |
For example, to find all documents created before 5 January 2000, you may use either of the following queries:
There are no such field names stored in the document; the dates actually come from the document's header, not from fields. So you can use these names with any document, even though they do not appear among the field items in the Document Properties dialog.
There is no syntax corresponding to the search builder functions to find documents based on the difference from today's date (e.g. "is in the last n days"). Your agent will need to plug in actual dates at runtime (which it can calculate by adjusting today's date). Date formats vary based on user settings, so you must use a format that matches the workstation or server that will evaluate the query. |
|