Thanks a lot. So there is no way to limit to only one result returned?
On 2017-12-15 04:12, Antony Joseph Kitherian Xavier <antony...@entosstech.com> wrote: > 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 >
