topic Issue with Date Search on CM8 in Alfresco Archive

Issue with Date Search on CM8

popeye — Mon, 09 Jul 2012 08:59:29 GMT

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 checki

Re: Issue with Date Search on CM8

vahe — Mon, 09 Jul 2012 09:19:21 GMT

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>
‍‍‍‍‍‍

Re: Issue with Date Search on CM8

popeye — Tue, 10 Jul 2012 07:21:34 GMT

The "datemode" configuration solved the issue.

Thanks,
Popeye