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)
+—>collection
+—>info
          +—>home.html (custom aspect)
+—>portfolio
          +—>whatever.html



How can I accomplish that ?

Outcomes