jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jukka Zitting (JIRA)" <j...@apache.org>
Subject [jira] Updated: (JCR-638) Support lower-/upper-case functions
Date Thu, 16 Nov 2006 13:55:41 GMT
     [ 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

        

Mime
View raw message