How to Ignore Quotation Marks when Searching on a Custom Metadata Field Which has a Two-Word Option Containing a Space in the Drop-Down Option List (Doc ID 2016227.1)

Last updated on JANUARY 05, 2023

Applies to:

Symptoms

With Oracle Text Search (OTS) used in Content Server, a custom metadata field is created which has option list. When this option list contains a two word option with a space, it adds quotation marks while doing a search on the field.

This results in unexpected search results coming back such as no results for "contains" search option and for "does not match", it returns all results.

This variable should not automatically convert drop-down values to queries that do not work and needs to be ignored while searching.

Cause

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