jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcel Reutegger <marcel.reuteg...@gmx.net>
Subject Re: SQL case insensitive search using jcr:path
Date Fri, 14 Nov 2008 08:45:56 GMT
Hi Emanuele,

Blanco Emanuele wrote:
> However, if the node is stored as FOOBAR, Foobar, fooBar or so on, searching
> will not return any result. Is there a way to make this search case
> insensitive?

no, that's not possible. as a workaround you can set a string property on the
node, which contains the name. then you can write:

select * from ns:type where jcr:path like '/foo/bar/%' and upper(ns:name) = 'FOOBAR'

> And, last but not least, there is a way to specify a "soundslike" concept,
> always using jcr:path?

this also requires that the node name is available as a property. then you can
write:

select * from ns:type where jcr:path like '/foo/bar/%' and contains(ns:name,
'foobar~')


regards
 marcel

Mime
View raw message