jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Nuescheler" <david.nuesche...@gmail.com>
Subject Re: Searching binary data
Date Mon, 04 Sep 2006 09:10:35 GMT
Hi Roy,

first of all I think this is rather a post for the user list
than the dev list of Jackrabbit.

On 9/2/06, Roy Russo <roy.russo@jboss.com> wrote:
> Running in to a problem when searching jcr:data types...
>
> "select * from portalcms:content where jcr:data like '%JBoss%'";

I assume that in your example you want to issue
a fulltext search looking for "JBoss", correct?

So your query should look like this:

select * from nt:resource where contains(*,'JBoss')

See page 296: 8.5.4.5 CONTAINS
of the JCR v1.0 spec

regards,
david

Mime
View raw message