chemistry-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Antony Joseph Kitherian Xavier <antony...@entosstech.com>
Subject Re: Query latest document
Date Fri, 15 Dec 2017 04:12:45 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message