03 Troubleshooting
Client
Full-text search issues
- Full-text indexes containing multiple code pages (when more than one language is present in the indexed database) display duplicate search results when the query is searching on a specific field and the field is a date or a numeric field.
- The search by example feature (Fill Out Example Form button) returns a non-fatal error when used in the Personal Address book.
- Search results in categorized views may not appear as single documents. This occurs when using the "sort by" options "Keep current order" or "Show all documents." To see your result documents, expand the Category triangle or expand the view categories (View->Expand All) prior to executing search.
- After a full-text search, sortable columns work only if using the "sort by" options "Keep current order" or "Show all documents."
- The full-text search message is misleading when Search finds more than the Maximum Results Limit. If you set the Maximum Results Limit to 20 and Search finds 25 documents, the status bar should display "More than 20 documents found." Currently it reports, "20 documents found."
- Performing a full-text search for a word written in Chinese, Korean and Japanese characters may not work if a document has the word but there is a carriage return in the middle of a it. For an example, if your search word consists of three Chinese characters and a document has this word with a carriage return after the first character, Notes does not find the document.
- Currently there is no way to perform a full-text search for a search word of pattern : double byte string 1 + single byte space + double byte string 2. "Double bytes strings" means a series of Chinese, Korean, or Japanese characters. In order to search for a word pattern like this, use the following pattern with the "Fuzzy search" option enabled : double byte string 1 + double byte string 2.
- By default, the "Fuzzy search" option finds words that match 75% or more of a search word. You can change the value of this option by using the "matchinglevel" operator. For example, if you search using the string "matchinglevel 80 user", the results reflect words where "user" makes up 80% of the word.
- You cannot use wild card characters (* or ?) when searching for words written in Chinese, Korean, or Japanese.
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"