Stopword at Beginning of Account Search Causes Strange Search Results With Oracle Text Search (Doc ID 856005.1)

Last updated on MAY 24, 2017

Applies to:

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

Symptoms

Using Oracle Text Search with the Accounts field optimized can cause searching irregularities when searching and stopwords are at the beginning of the account search value.  For example, if there are accounts setup like the following:

When a search is performed on the value "any/sd/admin", values were erroneously returned from the "int/sd/admin" and "dept/sd/admin" accounts.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms