Question regarding CMIS getDescendents

[vinu_kumar]

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

[jpotts]

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

[vinu_kumar]

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

[jpotts]

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

Jeff