AnsweredAssumed Answered

Cmis query confinment

Question asked by leonardo.celati on Apr 16, 2014
Latest reply on Apr 16, 2014 by 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)
          +—>home.html (custom aspect)

How can I accomplish that ?