You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Michael Dürig (JIRA)" <ji...@apache.org> on 2010/12/17 18:48:06 UTC
[jira] Updated: (JCR-952) Support lower and upper case functions in
"order by" clause
[ https://issues.apache.org/jira/browse/JCR-952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Dürig updated JCR-952:
------------------------------
Attachment: JCR-952.patch
tentative patch. Needs cleanup and javadoc
> Support lower and upper case functions in "order by" clause
> -----------------------------------------------------------
>
> Key: JCR-952
> URL: https://issues.apache.org/jira/browse/JCR-952
> Project: Jackrabbit Content Repository
> Issue Type: New Feature
> Components: jackrabbit-core, query
> Affects Versions: 1.3
> Reporter: James Hang
> Priority: Minor
> Attachments: JCR-952.patch
>
>
> The query languages should support lower- and upper-case functions within the "order by" clause. This would provide case-insensitive ordering of query results.
> Example: Find all "nt:base" nodes ordered by the "foo" property, but ignoring case
> In XPath:
> //element(*,nt:base) order by fn:lower-case(@foo)
> In SQL:
> SELECT * FROM nt:base ORDER BY lower(foo)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.