Issue with Date Search on CM8

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

popeye

Hi,
we are using OpenWorkdesk in a Content Manager 8.4.3 environment => my date search is not working. When using the OpenWorkdesk date widget, the format of the date to be searched is "yyyy-MM-dd HH:mm:ss.S". The format required by Content Manager is "yyyy-mm-dd-HH.mm.ss.SSSSSS". I will be checking to see if a shorter version will work, for example, "yyyy-MM-dd" ==> but did you have this issue before? Can you help?

Thanks 🙂

vahe

The OpenWorkdesk support different time formats, also available for searches:
- TimeStamp (e.g. 06/28/2012 12.00)
- Date (e.g. 06/20/2012)
- Time (e.g. 10.20)
It is important to set the right datemode in the searchtemplate:

datemode=usetime|ignoretime|ignoredate‍

To search for the document Create Timestamp (creation date between date1 and date2) you have to use this in your searchtemplate:

<between>
   <whereprop datemode="usetime" editproperty="editable" symname="SYSROOTATTRS.CREATETS" />
   <literal />
</between>
‍‍‍‍‍‍