This is currently not possible. Jackrabbit does not support functions like
fn:lower-case or fn:upper-case. feel free to file a jira issue and request it as
an enhancement. then something like the following would be possible:
select * from nt:base where fn:lower-case(name) = 'the ooga booga'
regards
marcel
Sidu Ponnappa wrote:
Thanks, Marcel. We have another doubt, though.
Say we want to search for a phrase (exact match) on a property(name, in the
example), we'd use something like
select * from nt:base where name='The Ooga Booga'
We now want to make this case insensitive such that
select * from nt:base where name='the ooga booga'
return the same result as the first query.
How could we do this?
Thanks,
Sidu.
On 27/10/06, Marcel Reutegger <[EMAIL PROTECTED]> wrote:
yes, you can. but keep in mind that this is highly jackrabbit specific
(and even
specific to the current query handler implementation) and not
specified in
jsr
170. If jackrabbit will use a different index implementation in the
future
it
might happen that this will not be supported anymore.
select * from nt:base where contains(name, '"Ooga Booga"~3')
regards
marcel
C. K. Ponnappa wrote:
> Hi,
>
> Is there a way I can use Lucene syntax in jackrabbit SQL to include
> proximity searches?
> I need to do something like:
>
> select * from nt:base where (name:'Ooga Booga' )~3
>
> so I get all nodes where the name property has the terms 'Ooga' and
> 'Booga' within 3 words of one another.
>
>
> Thanks,
> Sidu.
>
>
