I need to search fulltext in a SQL2, in the same way I doing with XPath.

Xpath:
//element(*, nt:file)[jcr:contains(jcr:content,'term')]

this search will give me all nt:file nodes that has a child jcr:content with
a @jcr:data indexed with that term.

In SQL2 I am trying without sucess, like:

SELECT * FROM [nt:file] WHERE CONTAINS (.jcr:content, 'term')

but it's like I can not refer to a content relative to a child node...

Any help helps...
Regards



--
View this message in context: 
http://jackrabbit.510166.n4.nabble.com/SQL2-equivalent-to-XPath-tp4659518.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Reply via email to