Help on JCR_SQL2

[Zhou Wu <zw...@yahoo.com>]

1. Could any one help me translate the following XPATH query

//element(*, nt:file)[jcr:contains(jcr:content, 'someword')]/rep:excerpt(.)

to JCR_SQL2? Even for JCR_SQL, I tried
http://people.apache.org/~mreutegg/jcr-query-translator/translator.html, it
gives the error: 'Child axis not supported in SQL: Child axis not supported
in SQL'.

2. Also could any one give some JOIN examples in JCR_SQL2?
-- 
View this message in context: http://www.nabble.com/Help-on-JCR_SQL2-tp25208950p25208950.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Re: Help on JCR_SQL2

[Thomas Müller <th...@day.com>]

Hi,

> 2. Also could any one give some JOIN examples in JCR_SQL2?

See http://svn.apache.org/viewvc/jackrabbit/trunk/jackrabbit-spi-commons/src/test/resources/org/apache/jackrabbit/spi/commons/query/sql2/test.sql2.txt?view=co

Regards,
Thomas