Query openCmis range of dates

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.

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

Thanks!

jpotts

This example was taken from the <a href="https://github.com/jpotts/alfresco-developer-series/blob/master/content/content-tutorial-cmis/src/main/java/com/someco/cmis/examples/SomeCoCMISDataQueries.java#L71">source code</a> that accompanies the custom content types tutorial:

System.out.println("Find content of type sc:whitepaper published between 1/1/2006 and 6/1/2007");   
queryString = "select d.cmis:objectId, w.sc:published from sc:whitepaper as d join sc:webable as w on d.cmis:objectId = w.cmis:objectId " +
"where w.sc:published > TIMESTAMP '2006-01-01T00:00:00.000-05:00' " +
                             " and w.sc:published < TIMESTAMP '2007-06-02T00:00:00.000-05:00'";
dumpQueryResults(getQueryResults(queryString));
‍‍‍‍‍‍‍

Jeff