My Oracle Support Banner

Search Api Only Works When Searching For Strings In Lowercase (Doc ID 1588659.1)

Last updated on JANUARY 03, 2016

Applies to:

Oracle WebCenter Sites - Version 11.1.1.6.1 and later
Information in this document applies to any platform.

Symptoms

Search page is not returning enough results that is expected, eg a search term "BC12" doesn't return results but a search term "bc12" does although the Content asset that hold the data has the word "ABC1234".

For example in Sites 11.1.1.6.1, FirstSiteII:

1. create a Content asset, and set the Headline field to "ABC1234"
2. in Admin tab -> Search -> Configure Asset Type Search screen, enabled the
Content_C index
3. in Admin tab -> Search -> Configure Attributes for Index, enabled the
FSIIHeadline attribute for the Content_C index
4. search for the asset with the following code

5. searchstr = "BC12" and searchfield = "FSIIHeadline", 0 results found
6. searchstr = "bc12" and searchfield = "FSIIHeadline", 1 asset found
7. searchstr = "BC12" and searchfield = "DefaultSearchField", 0 results found
8. searchstr = "bc12" and searchfield = "DefaultSearchField", 1 asset found

This testcase shows the search api only works when searching for strings in lowercase.

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!


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