jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Dürig (JIRA) <j...@apache.org>
Subject [jira] Commented: (JCR-952) Support lower and upper case functions in "order by" clause
Date Wed, 22 Dec 2010 14:37:05 GMT

    [ https://issues.apache.org/jira/browse/JCR-952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12974217#action_12974217
] 

Michael Dürig commented on JCR-952:
-----------------------------------

XPath queries of the following form are now supported:

//element(*,nt:base) order by fn:lower-case(@foo)
//element(*,nt:base) order by fn:upper-case(@foo)

Meaning the property used for sorting is first converted to lower (upper) case before comparison
takes place. 



> 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
>            Assignee: Michael Dürig
>            Priority: Minor
>             Fix For: 2.3.0
>
>         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.


Mime
View raw message