My Oracle Support Banner

How To Set Date Type Field Value As Query Condition When Calling GET_SEARCH_RESULTS Via RIDC (Doc ID 2283447.1)

Last updated on OCTOBER 10, 2018

Applies to:

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

Goal

When trying to search via RIDC with Date type field condition (e.g. dInDate > `2017-07-05 07:08:17`, it fails with the following error (Unable to parse date (!syUnableToParseDate))

getSearchResults: binder#toString:{UserDateFormat=iso8601, IdcService=GET_SEARCH_RESULTS, UserTimeZone=UTC, QueryText=(dDocTitle <contains> `test` <or> <ftx>test</ftx>) <and> dInDate = `2017/07/05 23:45`, UserLocale=English-US}
oracle.stellent.ridc.protocol.ServiceException: Unable to retrieve search results. Unable to parse date '2017/07/05 23:45'.
    at oracle.stellent.ridc.protocol.ServiceResponse.getResponseAsBinder(ServiceResponse.java:146)
    at jp.oracle.support.wcc.ridcsamples.SearchSample.getSearchResults(SearchSample.java:75)
    at jp.oracle.support.wcc.ridcsamples.SearchSample.testmain(SearchSample.java:48)
    at jp.oracle.support.wcc.ridcsamples.SearchSample.main(SearchSample.java:41)



This article describes how to set Date type field as query condition (e.g. dInDate > `{Date string}`) to search contents without the error.

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
References


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