OracleTextSearch Matches Searches Returns More Content Than Expected
(Doc ID 2193394.1)
Last updated on SEPTEMBER 18, 2019
Applies to:Oracle WebCenter Content - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
11g or 12c WebCenter Content configured for OracleTextSearch.
Items may have a metadata field with strings such as the following:
The Matches search on ENT returned not only the items with just ENT in the field but also any items with ENT_UO and ENT UO in their fields.
The Matches search on ENT_UO or ENT UO return the expected items.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|By default the Contains operator and the Matches operator do the same exact search:|
|A. For strings that contain special characters, like ENT_UO, ENT-UO, or ENT&UO, a printjoin could be configured.|
|B. Optimized the field.|
|Follow these steps to optimize the field:|
|Run a Fast rebuild for the changes to get into the current OracleTextIndex:|