topic Re: CMIS query returns result from published site in Alfresco Archive

CMIS query returns result from published site

mizage — Tue, 10 Jan 2012 19:45:06 GMT

Running this simple query from a class which extends SectionFactoryCmisImpl returns results from the Editorial and Live Stage.select cmisbjectId from ws:section where ws:displayRSSFeedWidget={0}‍Is there any way to avoid this and make the results stage specific?

Re: CMIS query returns result from published site

bremmington — Wed, 11 Jan 2012 08:45:29 GMT

Yes. A ws:section node has a multi-valued property named ws:ancestorSections that contains the ids of all of its ancestor sections. You want to find the root section of the relevant website and constrain your query so it only returns sections that have the root section id as a value of their ws:ancestorSections property.

Re: CMIS query returns result from published site

mizage — Fri, 13 Jan 2012 15:17:41 GMT

This seems to do the trick:

SELECT d.cmisbjectId FROM ws:section AS d WHERE d.ws:displayRSSFeedWidget={0} AND in_tree(d,{1})

I pass in the root id.