nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

CMIS query to query the documents/folders under data dictionary

udayakumar_p

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 Dictionary/*"')

Can anyone suggest the right query to use

Find more posts tagged with

Alfresco Content Services

Accepted answers

kalpesh_c2

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

All comments

kalpesh_c2

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

udayakumar_p

Thanks

franciscoduarte

Hi,

Is there a way to get the folders inside too?

angelborroy

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"

franciscoduarte

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