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: Case insensitive order by?
Date Tue, 29 May 2007 08:46:45 GMT
Hi James,

James Hang wrote:
> Is it possible to do a case-insensitive order by using an XPATH search?  I
> tried using the fn:lower-case function like this:
> /root//element(*,my:type)
> order by fn:lower-case(@my:property) ascending
> But it doesn't seem to like the fn:lower-case function call within the order
> by clause.  I get a parse exception.  Is there a way around this?

no, the lower-case function is not supported in the order by clause.

please feel free to create a jira issue for this enhancement.

> Or is
> there another way of doing a case-insensitive order by without using the
> fn:lower-case function?

well, you can hold a lower-cased copy of the property aside, which you then use 
for ordering. but that introduces redundant data.


View raw message