jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Klimetschek <aklim...@adobe.com>
Subject Re: jcr sql2 - contains() full text search not working
Date Thu, 19 Jul 2012 19:27:11 GMT
On 27.06.2012, at 17:19, Furst, Carl wrote:

> So here's the sql I use:
> 
> select * from [nt:resource] where  contains([jcr:data], 'include');

The full text index for binary properties is by default aggregated on the node itself, not
on the jcr:data property. You address that with "*" and you need a selector (s in this case):

select * from [nt:resource] as s where contains(s.*, 'include')

(In the former sql1 you could simply to CONTAINS(., 'include') to adress the node itself).

See my recent mail (about xpath, but same index is used): http://markmail.org/message/oc6uootrpxepso4d

Cheers,
Alex


Mime
View raw message