nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

select with latest modification date

longinus

Hello All

I 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?

Thanks

Krzysztof

Find more posts tagged with

Alfresco Content Services

Comments

afaust

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

longinus

Cool, thanks.

Any way to limit the results collection to one record?

andy1

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

longinus

Yes, I am using CMIS API.

Thanks for the hint.

Krzysztof