jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "hsp" <piccina...@ibest.com.br>
Subject Contains searches in sql sintax.
Date Fri, 30 Jun 2006 19:33:34 GMT

I want to know if the fulltext searches returns the child nodes of the nodes that are the
same type I put in sql.
For example, I have the following tree:

|_File1 (my:file)
   |__jcr:content (nt:resource)

If I run the sql : SELECT * FROM my:file WHERE CONTAINS(*,'text'); there is no result,
But if I run the sql : SELECT * FROM nt:resource WHERE CONTAINS(*,'text'); there is a result,

Is there a way to do a search and get the kind of results like I need? (Specifying a kind
of node type, that is not nt:resource but has a child nt:resource).


View raw message