You can't join results along the child axis in SQL. I don't remember the exact section of JCR specification, but it is mentioned there. You would need to construct such query in xpath.
HTH, Jan On Jul 30, 2012, at 2:59 PM, Mohan Suresh (via Magnolia Forums) wrote: > when I tried the following SQL query in the JCR Querying interface, I got > "[b]Invalid combination of jcr:path clauses[/b]" error. Is there any other > option to compare multiple combination of values with a single property? > > [i]select * from nt:base where (jcr:path like '%/demo-project/%' or jcr:path > like '%/demo-features/%') [/i] > > -- > Context is everything: > http://forum.magnolia-cms.com/forum/thread.html?threadId=16b3ec13-f180-4084-a85e-a57e8982f62f > > > ---------------------------------------------------------------- > For list details, see http://www.magnolia-cms.com/community/mailing-lists.html > Alternatively, use our forums: http://forum.magnolia-cms.com/ > To unsubscribe, E-mail to: <[email protected]> > ---------------------------------------------------------------- ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
