[ http://issues.apache.org/jira/browse/JCR-638?page=all ]
Jukka Zitting updated JCR-638: ------------------------------ Fix Version/s: 1.2 (was: 1.1.1) > Support lower-/upper-case functions > ----------------------------------- > > Key: JCR-638 > URL: http://issues.apache.org/jira/browse/JCR-638 > Project: Jackrabbit > Issue Type: New Feature > Components: query > Reporter: Marcel Reutegger > Assigned To: Marcel Reutegger > Priority: Minor > Fix For: 1.2 > > > The query languages should support lower- and upper-case functions when > matching property values to string literals. > Example 1: find all nodes with a string property foo with a lower-cased value > that equals 'bar': > In XPath that's: > //*[fn:lower-case(@foo) = 'bar'] > An in SQL: > SELECT * FROM nt:base WHERE LOWER(foo) = 'bar' > Example 2: find all nodes with a string property foo with an upper-cased > value that matches '%JCR%' > XPath: //*[jcr:like(fn:upper-case(@foo), '%JCR%')] > SQL: SELECT * FROM nt:base WHERE UPPPER(foo) LIKE '%JCR%' -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira