AnsweredAssumed Answered

howto do a WHERE clause in search?

Question asked by frank_d on Nov 10, 2010

I would like to run a query that returns nodes based on the value of a property of it's subnodes.

So something like: SELECT superNodes WHERE subNode.color="blue"

What would be the best way to approach this? XPath? But I may have understood from elsewhere that the Lucene index is not used in such searches (true?).

Lucene search? I cannot find an example of a query of the kind above.

Also, I am on Alfresco 2.9 so this new CMIS solution is probably of no help.