Full-Text Search Issue w/ Number or Date Fields

Mindwatering Incorporated

Author: Tripp W Black

Created: 01/11/2008 at 08:15 AM

 

Category:
Domino Server Issues Troubleshooting, Notes Developer Tips
Web/HTTP
Views

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