AnsweredAssumed Answered

Query openCmis range of dates

Question asked by jevr on Feb 7, 2014
Latest reply on Feb 7, 2014 by jevr
Hi, i try to query for a custom property type date in alfresco with openCmis, the query works fine, but need to search by a range of dates, i see that the "between"not work in opencmist, how i can search with ranges?

I have a query like that, and this work fine.

"SELECT D.*,alias.customprefix:documentDate FROM cmis:document AS D JOIN customprefix:customAspect AS alias ON D.cmis:objectId = alias.cmis:objectId WHERE alias.customprefix:documentDate = TIMESTAMP '2013-04-22T12:52:12.123Z'"