Custom query search recognize '=' but not the '<' and '>' operands (Doc ID 3050108.1)

Last updated on OCTOBER 01, 2024

Applies to:

Symptoms

When using the Query Builder Advanced options with DATABASE.METADATA search engine and searching with equal to (=) operator, the query works as expected but when "<" (lesser than) or ">" (greater then) operators are used it fails.

Example of a modified Query Text:
=========================
dDocType <matches> 'Document' <AND> dSecurityGroup <matches> 'Test' <AND> xIdcProfile <matches> 'Test' and dFileSize < '1000'

=========================

Error noted is:

Content Server Request Failed.
Unable to retrieve search results. The query text is invalid.

Cause

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