CMIS Query - Get the PATH from a cmis:document

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.

tremalnaik

Hi,

If I make the next query:

SELECT *  FROM cmis:document WHERE cmis:name LIKE 'name'‍

Nothing of the values returned is the path (it's not al the cmis:document table)

Exists some meaning to recovery the path of there? Thanks

jpotts

The path for a CMIS object has to be reconstructed by invoking the object's "getParents" URL.

For example, suppose you have a cmis:document with a self link of:

http://localhost:8080/alfresco/cmisatom/c0c56a69-abbb-41a4-90fe-c3750b376199/entry?id=workspace%3A%2F%2FSpacesStore%2F20a3a95b-3c14-4f19-b2e3-1b601de139f4%3B1.0‍

If you look at the cmis:document, it will have an "up" URL, otherwise known as the getParents URL. In my example, the up URL looks like this:

http://localhost:8080/alfresco/cmisatom/c0c56a69-abbb-41a4-90fe-c3750b376199/parents?id=workspace%3A%2F%2FSpacesStore%2F20a3a95b-3c14-4f19-b2e3-1b601de139f4%3B1.0‍

Once you have that URL you invoke it with a filter of 'cmisath' and the includeRelativePathSegment set to True, like this:

http://localhost:8080/alfresco/cmisatom/c0c56a69-abbb-41a4-90fe-c3750b376199/parents?id=workspace%3A%2F%2FSpacesStore%2F1a2d2fd7-612d-4105-a33f-55a0df8f1c5d%3B1.0&filter=cmis%3Apath&includeRelativePathSegment=True‍

What you'll get back is a feed of parent entries, even if the object only has a single parent. Each parent entry will contain a path and a relative path segment, which can be concatenated to form the path.

Of course, if you are using a CMIS client library like OpenCMIS (Java) or cmislib (Python), you can just ask the object for its paths and the library does all of this work for you.

Hope that helps,

Jeff