|Full-Text Search Issue w/ Number or Date Fields|
Tripp W Black on 01/11/2008 at 08:15 AM
Category: Domino Server Issues Troubleshooting, Notes Developer Tips
|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)
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.