Query Builder Cannot Parse Date Field To Date Field (Doc ID 1964150.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Symptoms

You want to find the content items where one metadata date field is greater than or equal to another date field.  When you test the query, you get an error Content Server cannot parse the query with the error character being one greater than the length of the query.

Example:  xTestDate>=xCompareDate  This will fail at character 24.            xTestDate>=`01/13/10 12:00 AM`  Will work.    

Cause

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 hundreds of Community platforms