jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Hang (JIRA)" <j...@apache.org>
Subject [jira] Created: (JCR-952) Support lower and upper case functions in "order by" clause
Date Tue, 29 May 2007 18:36:16 GMT
Support lower and upper case functions in "order by" clause
-----------------------------------------------------------

                 Key: JCR-952
                 URL: https://issues.apache.org/jira/browse/JCR-952
             Project: Jackrabbit
          Issue Type: New Feature
          Components: query
    Affects Versions: 1.3
            Reporter: James Hang
            Priority: Minor


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