topic Re: How can I get all documents with their respective directory using CMIS? (Como eu consigo buscar todos os documentos com seu respetivo diretório usando CMIS) in Alfresco Archive

How can I get all documents with their respective directory using CMIS? (Como eu consigo buscar todos os documentos com seu respetivo diretório usando CMIS)

gustavosandrade — Thu, 10 Nov 2016 19:36:13 GMT

How can I perform the search of all documents, from a respective site eg 'sispat', and bring the paths of all the documents? I made a query that returns the paths of all folders: SELECT * FROM cmis: folder WHERE CONTAINS ( 'PATH: \ "/ app: company_home / st: sites / cm: sispat / cm: documentLibrary

Re: How can I get all documents with their respective directory using CMIS? (Como eu consigo buscar todos os documentos com seu respetivo diretório usando CMIS)

kaynezhang — Fri, 11 Nov 2016 03:49:17 GMT

Why not just use getDescendant or getFolderTree method of Folder class and iterate folder tree assemble path you self.

Re: How can I get all documents with their respective directory using CMIS? (Como eu consigo buscar todos os documentos com seu respetivo diretório usando CMIS)

jego — Fri, 11 Nov 2016 23:02:00 GMT

Why not selecting all documents with the IN_TREE clause?

Example: SELECT cmis:name FROM cmis:document WHERE IN_TREE(‘folder id’)

I hope this helps.

Re: How can I get all documents with their respective directory using CMIS? (Como eu consigo buscar todos os documentos com seu respetivo diretório usando CMIS)

gustavosandrade — Mon, 14 Nov 2016 18:08:01 GMT

I do not think you understood my doubt. I need to perform all this search in a query and this query should return the document name linked to the path of the same document

Re: How can I get all documents with their respective directory using CMIS? (Como eu consigo buscar todos os documentos com seu respetivo diretório usando CMIS)

gustavosandrade — Mon, 14 Nov 2016 18:09:47 GMT

I do not think you understood my doubt.

 I need to perform all this search in a query and this query should return the
 document name linked to the path of the same document.

Example:
Name Document | PATH
Paper.doc     |/sites/sispat/documentLibary/folder/Paper.doc

Re: How can I get all documents with their respective directory using CMIS? (Como eu consigo buscar todos os documentos com seu respetivo diretório usando CMIS)

jego — Tue, 15 Nov 2016 08:23:40 GMT

I don´t think that this is working with such a document based query because only folders have a path property. Joining documents and folders would help, but I don´t know if Alfresco is supporting joins in the meantime (https://community.alfresco.com/docs/DOC-5898-cmis-query-language#w_cmis3adocument -The Alfresco implementation currently does not support JOIN except as an extension to support aspects. This extension is Alfresco specific.)