In UCM 10g, with CS10gr35CoreUpdate Build 115, and MS SQL Database: Underscores In "matches" Search Criteria Fail with an Exra Space in the Search Query
(Doc ID 1563637.1)
Last updated on APRIL 09, 2024
Applies to:
Oracle WebCenter Content - Version 10.0 and laterInformation in this document applies to any platform.
Symptoms
On : 10.1.3.5.0 version, Content Server
ACTUAL BEHAVIOR
---------------
When performing a 'matches' search in a non-indexed custom metadata field, items with an underscore character (_) do not return after having installed CS10gr3CoreUpdate Bundle build 115, even though the items can be found in repository manager.
EXPECTED BEHAVIOR
-----------------------
It is expected that the matches search pulls back matching content items in fields whether or not they have an underscore character in them or not.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Point your browser at a vanilla 10g content server running Build-115 with database full-text indexing.
* Check in a document with the value "with_some_underscores" in its xComments non-indexed field.
* Check in a document with the value "hasNoUnderscores" in its xComments non-indexed field.
* Point a browser at this content server's "standard search" form.
* Run a "matches" search in xComments for "hasNoUnderscores". This item is found in the content server.
* Run a "matches" search in xComments for "with_some_underscores". This item is not found in the content server.
* Open up the RepositoryMananager applet and filter xComments for "with_some_underscores". RepoMan on the content server can find this item.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot search as they have in the past
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 |
Cause |
Solution |
References |