topic Way to access node content by secondary path (not primary) in Alfresco Archive

Way to access node content by secondary path (not primary)

dsnkostic — Wed, 18 Apr 2012 12:07:50 GMT

Hi,Is there any way to access content of Alfresco node based on secondary path, not primary?Here is my situation:I have a folder images where I place my images which are classified under certain sub-folder like:/images/cars/opel.jpg/images/bicycles/twocycle.jpg/images/signs/stop.jpgetc…Now i have an

Re: Way to access node content by secondary path (not primary)

andy — Mon, 23 Apr 2012 09:47:28 GMT

Hi

I was not aware that CMIS only followed primary associations.

You can always use ….CONTAINS('PATH:"<your path>"')
The PATH is the full Alfresco PATH and not the CMIS path made up of names (it is probably for this reason that CMIS only follows primary associations)

Andy

Re: Way to access node content by secondary path (not primary)

dsnkostic — Thu, 26 Apr 2012 13:33:36 GMT

Hi Andy,

Thanks for your interest in my problem.
Can you please be more specific how to create such a query? I tried entering some cmis query into Alfresco node-browser:
Store: workspace://SpacesStore
search type: cmis-alfresco,
query: SELECT * FROM cmis:document WHERE CONTAINS('PATH:"/Company Home/CDLView.jpg"').
However, that query produced no results. Into my understanding, CONTAINS keyword searches inside node content. In this particular example it will search for 'PATH:"/Company Home/CDLView.jpg"' string inside any alfresco node.
Am I doing something wrong.

Also I require that content of given node (based on secondary path) be downloadable from Alfresco by using some available web service (if available). I just want an URL to type in my browser and to get content of my node in my browser (to start download or display image for example).

Thank you for your time!

Re: Way to access node content by secondary path (not primary)

andy — Fri, 27 Apr 2012 08:27:52 GMT

Hi

You need the full path not the CMIS name path.
Go to the node browser and look at the paths it reports.
Each step is

<namespaceprefix>:<ISO9075 encoded assoc QName>

The node browser will show you the pattern

Andy

Re: Way to access node content by secondary path (not primary)

dsnkostic — Fri, 27 Apr 2012 15:39:28 GMT

Hi,

Thank you so much for your hint. I was able now to properly execute query based on path and get node by secondary path.
Query was supposed to be something like this:

SELECT * FROM cmis:document WHERE CONTAINS('PATH:"//app:company_home/cm:CW-Home/cm:CDLView.jpg"')‍

However I still need web service from Alfresco that returns content based on secondary path. There is a service:

Issue Query (query)
GET /alfresco/service/cmis/query?q={q}&includeAllowableActions={includeAllowableActions?}&includeRelationships={includeRelationships?}&renditionFilter={renditionFilter?}&searchAllVersions={searchAllVersions?}&skipCount={skipCount?}&maxItems={maxItems?}‍‍

This service returns results as XML response with reference to node. However, I need service that returns node content not XML response. I might be able to write webscript that mimic behavior that I need, but I was hoping if Alfresco has some out-of-the-box service.

Thanks again. This query will solve some other problems that I had with secondary path, anyway
Cheers