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.
regards
marcel