topic Re: CMIS query to query the documents/folders under data dictionary in Alfresco Forum

CMIS query to query the documents/folders under data dictionary

udayakumar_p — Tue, 13 Mar 2018 20:20:34 GMT

We are trying to fetch the list of folders from Data Dictionary. However the CMIS query does not work. Following are the queries we tried.select * from cmis:folder where CONTAINS('PATH:"//app:company_home/cmata Dictionary/*"')select * from cmis:folder where CONTAINS('PATH:"//app:company_home/Data

Re: CMIS query to query the documents/folders under data dictionary

kalpesh_c2 — Wed, 14 Mar 2018 07:00:25 GMT

Hi,

This will fetch you all the children of data dictionary folder.

SELECT * FROM cmis:folder WHERE CONTAINS('PATH:"//app:company_home/app:dictionary/*"')‍

Thanks,

Kalpesh

ContCentric

Re: CMIS query to query the documents/folders under data dictionary

udayakumar_p — Wed, 14 Mar 2018 19:14:35 GMT

Thanks

Re: CMIS query to query the documents/folders under data dictionary

franciscoduarte — Fri, 22 Oct 2021 13:19:24 GMT

Hi,

Is there a way to get the folders inside too?

Re: CMIS query to query the documents/folders under data dictionary

angelborroy — Fri, 22 Oct 2021 13:53:16 GMT

Sample query with nested folders:

SELECT * FROM cmis:folder WHERE CONTAINS('PATH:"//app:company_home/app:dictionary//*"')

Some other approach described by @afaust in https://hub.alfresco.com/t5/alfresco-content-services-forum/get-all-childs-of-a-node/td-p/76864 (using FTS instead of CMIS syntax)

ANCESTOR:"workspace://SpacesStore/b9f46070-fd06-4a72-8389-e3c76ca574a1" AND TYPE:"cm:folder"

Re: CMIS query to query the documents/folders under data dictionary

franciscoduarte — Fri, 22 Oct 2021 16:24:29 GMT

I made a mistake, I wanted to say documents too and not folders. The title mentions folders/documents but the solution provides only folders.