16.2 RestAPI Search V2 Date and Time Formats?

ICW

Question: how do I use modifydate search with time filter.  Or can someone explain what format for Date and Time I should use to find a document modified on '2080113 at 15:18:07' using RestAPI Search 16.2 V2?

The following works fine, but how do I add date format to this search:

v2/search?where=((OTSubType:144) AND (Attr_131158_4:WSD-5830720-00) AND (OTModifyDate:='20180123 *'))

I get a hitlist of 7 items with above and would like to filter by time in addition to date above.

Thanks, Roger

Steve Brezina

Hi Roger,

Time values are extracted into separate fields from the date component, OTModifyTime in this case. However, time fields are dropped by default during indexing to save space. Unfortunately, you'll need to comment out this line from [OTHome]/config/LLFieldDefinitions.txt and re-index first.

REMOVE OTModifyTime

The field format is HHMMSS

Regards,

   Steve