View or Database Full-Text Searching Issue:
view URL or LotusScript full-text searches fail for a specific field. This normally occurs when the field contains a number or date.
(FTSearch or Search)
Possible Solutions:
1. If number is stored as text in the field (text field w/ "10" vs. 10), wrap the query in quotes.
2. If you recently performed an update where the data type stored in the field changed (e.g. date --> text or text to date), then you have hosed yourself. The full-text index expects the data type to be ONE type of value for the item: number, text, or date. Run an agent against the old documents and convert the fields to the new datatype. Then throw away the index and rebuild it.
BaseSyntax:
server/folder/app.nsf/view?OpenView&Search=query
Search Syntax:
view&Search=FIELD+WP_CategoryPage+CONTAINS+fieldvalue+AND+FIELD+WP_CategoryPage+CONTAINS+fieldvalue
previous page
|