How Do Stop Words in the Oracle Database Affect a Search That Is Done in Content Server with Oracle Text Search?
(Doc ID 876691.1)
Last updated on APRIL 09, 2024
Applies to:
Oracle WebCenter Content - Version 10.0 and laterInformation in this document applies to any platform.
Goal
How do stopwords in the Oracle database affect a search that is done in Content Server with Oracle Text Search?
If a search is done with a stopword like "here" as the value for one field, and Public as the security group, you get all Public items back in the results. This makes sense since stopwords are thrown out of the query.
However, if you search just for the stopword in the one field with no other criteria set, you get no results back at all instead of all items returned.
Why is this?
Solution
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
Goal |
Solution |