Having difficulty to match DATETIME with OTAG REST API queries

Ping_Chen

Hi,

Hope your experience can shed some light on this. We noticed an unexpected behavior of OTAG REST API queries in relation to datetime. We use WEM v16 running on Linux with an Oracle DB.

We defined a "Start Date" field in a CTD (using DATE datatype in Oracle DB and created with "Date and Time Selector Enhanced" widget) so that user can specify a date AND time. We then created a presentation query to retrieve content items by desirable datetime like this:
    http://cmstore-us.com/vgn-webapi/rest/v1/query/0/executesavedquery?queryname=get-editorial-by-date&startDate=06/28/2016

Here "startDate" takes the desired datetime. If the time part of content is 12:00:00 AM, everything is fine when we only specify the mm/dd/yyyy. If the time part is other time, such as 12:00:00 PM, we attempted multiple datetime formats for the "startDate" parameter, such as 06/08/2016 12:00:00 PM" (encoded when executing), but cannot find a way to return the item. 

We are actually more interested in the "before" and/or "after" conditions but it is easier to describe the case for exact match ("is" condition).

 

Thanks,

Ping