chemistry-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Florian Müller <f...@apache.org>
Subject Re: Query latest document
Date Sat, 16 Dec 2017 17:12:54 GMT
Sure there is. Use paging.
Set the page size to one and fetch the first page.

- Florian


> 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