[ https://issues.apache.org/jira/browse/JCR-952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12769175#action_12769175 ]
Ard Schrijvers commented on JCR-952: ------------------------------------ Yes, agreed > 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 > > 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.