topic Question regarding CMIS getDescendents in Alfresco Archive

Question regarding CMIS getDescendents

vinu_kumar — Thu, 14 Mar 2013 00:16:38 GMT

Hi, I am using the descendants service api to retrieve the descendants of a folder. I would like to know if it possible to filter documents which have a certain property value.For example: retrieve all the descendants which have custom property 'custom:aPropertyName' with 'VALUE1'.Regards- Vinu

Re: Question regarding CMIS getDescendents

jpotts — Mon, 18 Mar 2013 15:00:48 GMT

The CMIS query language has an IN_TREE predicate that works the same way as the getDescendants call. Unlike getDescendants, though, you can use other predicates to filter your results. For example:

SELECT * FROM cmis:document where cmis:name = 'test-plain-1.txt' and IN_TREE('workspace://SpacesStore/610c4672-eaf7-42c1-a2f1-bc948696760d')

Finds the file named test-plain-1.txt anywhere in a Share site with that ID. You could do the same thing substituting custom:aPropertyName for cmis:name.

Jeff

Re: Question regarding CMIS getDescendents

vinu_kumar — Wed, 20 Mar 2013 00:21:59 GMT

Thanks Jeff, Is it possible to pass the path (/Sites/sitename/documentLibrary) instead of using workspace id? I'm using CMIS services remotely (in a mobile app) and would like to restrict number of calls made to the server.

Regards
- Vinu

Re: Question regarding CMIS getDescendents

jpotts — Thu, 21 Mar 2013 14:20:52 GMT

No, you'll have to fetch the folder, then use its ID to build the query.

Jeff