My Oracle Support Banner

OracleTextSearch Matches Searches Returns More Content Than Expected (Doc ID 2193394.1)

Last updated on MAY 18, 2018

Applies to:

Oracle WebCenter Content - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

11g or 12c WebCenter Content configured for OracleTextSearch.

Items may have a metadata field with strings such as the following:

ENT

ENT_UO

ENT UO

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
 By default the Contains operator and the Matches operator do the same exact search:
Solution
 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:
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.