[jira] Updated: (JCR-56) allow case insensitive searches

["Carsten Ziegeler (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/JCR-56?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Carsten Ziegeler updated JCR-56:
--------------------------------

    Reporter: Raphael Wegmueller  (was: Raphael Wegmueller)

> allow case insensitive searches
> -------------------------------
>
>                 Key: JCR-56
>                 URL: https://issues.apache.org/jira/browse/JCR-56
>             Project: Jackrabbit Content Repository
>          Issue Type: New Feature
>          Components: sql
>            Reporter: Raphael Wegmueller
>            Assignee: Marcel Reutegger
>            Priority: Minor
>
> would be nice to be able to search specific properties like a fulltext search, e.g. with an ignore-case flag, so you could find a subset of the results of
>   select * from nt:base where contains('bla')
> using something like
>   select * from nt:base where jcr:bla like '%bla%'
> (currently, the value must contain 'bla' exactly as it is to be found by the second query)
> i suggest to extend the contains function with an additional argument for the property to search in, e.g.
>   select * from nt:base where contains('bla',jcr:bla)
> this could then also easily be used in XPath.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.