topic Re: CMIS quiery with timestamp question in Alfresco Archive

CMIS quiery with timestamp question

r_hunter — Sun, 08 Jan 2012 09:57:38 GMT

Hi!i need to get last modified documents in alfresco repository using web requesti ve read that document http://wiki.alfresco.com/wiki/CMIS_Query_Language and try to execute query:http://localhost:8080/alfresco/service/cmis/query?q=SELECT * FROM cmis:document WHERE cmis:lastModificationDate > TIM

Re: CMIS quiery with timestamp question

r_hunter — Mon, 09 Jan 2012 07:23:12 GMT

that request return all documents

http://localhost:8080/share/page/feed/components/documentlibrary/feed/all/site/mysite/documentlibrary?path=all‍

but is it possible to limit documents by last modified date?

Re: CMIS quiery with timestamp question

mitpatoliya — Tue, 10 Jan 2012 09:53:21 GMT

This might be because of date format you are using.
Try with other date format
i.e SELECT * FROM cmis:document WHERE cmis:creationDate < TIMESTAMP '2010-04-01T00:00:00.000+00:00'

Also I think if that does not work you can limit the result by IN clause as follow.
SELECT * FROM cmis:document WHERE cmis:creationDate IN ( TIMESTAMP '2010-03-31T12:52:12.123Z' )

Re: CMIS quiery with timestamp question

jpotts — Mon, 20 Feb 2012 23:09:57 GMT

r_hunter, you might want to look at this thread:
https://forums.alfresco.com/en/viewtopic.php?f=45&t=43067

Jeff