You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Marcel Reutegger (JIRA)" <ji...@apache.org> on 2006/11/16 11:37:36 UTC
[jira] Created: (JCR-638) Support lower-/upper-case functions
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
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
[jira] Resolved: (JCR-638) Support lower-/upper-case functions
Posted by "Marcel Reutegger (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/JCR-638?page=all ]
Marcel Reutegger resolved JCR-638.
----------------------------------
Fix Version/s: 1.1.1
Resolution: Fixed
Added in revision: 475677
> 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.1.1
>
>
> 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
[jira] Updated: (JCR-638) Support lower-/upper-case functions
Posted by "Jukka Zitting (JIRA)" <ji...@apache.org>.
[ 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