topic CMIS Query - Get the PATH from a cmis:document in Alfresco Archive

CMIS Query - Get the PATH from a cmis:document

tremalnaik — Wed, 30 Nov 2011 16:30:02 GMT

Hi,If I make the next queryELECT * 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

Re: CMIS Query - Get the PATH from a cmis:document

jpotts — Tue, 27 Dec 2011 16:27:21 GMT

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

Re: CMIS Query - Get the PATH from a cmis:document

ihanna — Wed, 30 May 2012 16:02:37 GMT

I know what you to do. 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

Hey, I have the same problem as his. I tried what you said but it didn't work. Do you have any alternate solution for this problem? I AM REALLY REALLY FRUSTRATED. I've been facing this for a week now and been researching about it for about 2 days straight. I really want to finish my task. Please help me.

Re: CMIS Query - Get the PATH from a cmis:document

jpotts — Wed, 30 May 2012 16:10:54 GMT

"It didn't work" is not helpful. Can you provide details on what specifically does not work?

Jeff

Re: CMIS Query - Get the PATH from a cmis:document

aowian — Wed, 15 Mar 2017 20:09:13 GMT

In case someone arrives here when looking for how to do this with the OpenCMIS Java library, the call is

CmisObject cmisObject = session.getObject(id);
println(cmisObject.getPaths())‍‍;‍‍

See this StackOverflow for reference.