topic Re: select with latest modification date in Alfresco Forum

select with latest modification date

longinus — Thu, 14 Dec 2017 17:07:09 GMT

Hello AllI have a similar document type stored in couple of folders. I would like select the most recent one using CMIS queries.Is there a way to accomplish that?ThanksKrzysztof

Re: select with latest modification date

afaust — Fri, 15 Dec 2017 09:08:27 GMT

Just sort your query based on cmis:lastModificationDate in descending order and select the first...

i.e.: SELECT * from cmis:document D WHERE (IN_FOLDER(D, 'folderId1') OR IN_FOLDER(D, 'folderId2') ....) ORDER BY D.cmis:lastModificationDate DESC

Re: select with latest modification date

longinus — Fri, 15 Dec 2017 17:34:56 GMT

Cool, thanks.

Any way to limit the results collection to one record?

Re: select with latest modification date

andy1 — Fri, 05 Jan 2018 11:14:22 GMT

You should be able to use paging and limits on the request. The CMIS browser binding uses the maxItems and skipCount parameters. I have assumed you are using the CMIS API as you do not say .....

Andy

Re: select with latest modification date

longinus — Fri, 05 Jan 2018 13:40:10 GMT

Yes, I am using CMIS API.

Thanks for the hint.

Krzysztof