jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hsp <piccina...@ibest.com.br>
Subject SQL2 equivalent to XPath
Date Wed, 11 Sep 2013 17:04:09 GMT
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.

Mime
View raw message