chemistry-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "krzysztoffzielinski@gmail.com"<krzysztoffzielin...@gmail.com>
Subject Re: Query latest document
Date Fri, 15 Dec 2017 12:49:13 GMT
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 <antonyjkx@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 <fmui@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
> 

Mime
View raw message