You may also use the following if you want to fetch latest documents by specific date;
SELECT * FROM cmis:document WHERE cmis:lastModificationDate > TIMESTAMP '2017-11-20T12:00:00.000Z' On Fri, Dec 15, 2017 at 1:49 AM, Florian Müller <f...@apache.org> wrote: > Are you looking for this: > > SELECT cmis:objectId,cmis:lastModificationDate FROM cmis:document ORDER > BY cmis:lastModificationDate DESC > > - Florian > > > > Hello All >> >> Is there a way to query the latest document using CMIS queries? >> e.g. max(modified) ?? or to specify WHERE clause saying latest date??? >> >> Thanks >> Krzysztof >> > -- Antony Joseph Kitherian .X Founder & CEO Entoss Technologies Pte Ltd, Singapore www.entosstech.com