Cmis query confinment

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

leonardo_celati

Hi all, I have a simple WCMQS collection query for retrieving asset marked with custom aspect I did.

select d.*, w.* from cmis:document as d join wzm:inmenu as w on d.cmis:objectId = w.cmis:objectId where w.wzm:menu = true order by w.wzm:rank
‍‍‍

It works fine, but it's retrieving all assets from the repository. Instead I would like to limit the collection query within its ws:root folder.

The assets with custom aspects are located in more than a folder, and the collection is at root folder.

Root (authoring)
+—>collection
+—>info
          +—>home.html (custom aspect)
+—>portfolio
          +—>whatever.html
‍‍‍‍‍‍‍‍

How can I accomplish that ?

kaynezhang

Use IN_TREE() function or CONTAINS() function  to narrow down the search at particular location
for example

select d.*, w.* from cmis:document as d join wzm:inmenu as w on d.cmis:objectId = w.cmis:objectId where w.wzm:menu = true order by w.wzm:rank and CONTAINS(d,'PATH:"//Sites"')
select d.*, w.* from cmis:document as d join wzm:inmenu as w on d.cmis:objectId = w.cmis:objectId where w.wzm:menu = true order by w.wzm:rank and IN_TREE(d, 'workspace://SpacesStore/5aece435-b231-468f-a306-1043fe26894a')
‍‍‍‍