You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Raphael Wegmueller (JIRA)" <ji...@apache.org> on 2005/03/08 16:45:54 UTC
[jira] Created: (JCR-56) allow case insensitive searches
allow case insensitive searches
-------------------------------
Key: JCR-56
URL: http://issues.apache.org/jira/browse/JCR-56
Project: Jackrabbit
Type: New Feature
Reporter: Raphael Wegmueller
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.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Closed: (JCR-56) allow case insensitive searches
Posted by "Marcel Reutegger (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/JCR-56?page=history ]
Marcel Reutegger closed JCR-56:
-------------------------------
> allow case insensitive searches
> -------------------------------
>
> Key: JCR-56
> URL: http://issues.apache.org/jira/browse/JCR-56
> Project: Jackrabbit
> 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.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Resolved: (JCR-56) allow case insensitive searches
Posted by "Marcel Reutegger (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/JCR-56?page=history ]
Marcel Reutegger resolved JCR-56:
---------------------------------
Resolution: Fixed
Extended syntax of XPath jcrfn:contains and SQL contains() to accept a second argument.
jcrfn:contains accepts a property name or a '.', whereas the SQL contains function accepts a property name or a '*'.
Examples:
//*[jcrfn:contains(., 'foo')
SELECT * FROM nt:base WHERE CONTAINS(*, 'foo')
-> returns all nodes that have a property that contains 'foo'
//*[jcrfn:contains(@title, 'foo')]
SELECT * FROM nt:base WHERE CONTAINS(title, 'foo')
-> returns all nodes that contain the word 'foo' in a title property
Jackrabbit currently still support the one argument version of the contains function. But support will probably be removed with the next version (0.16.4?) of the JCR spec.
SVN revision: 160047
> allow case insensitive searches
> -------------------------------
>
> Key: JCR-56
> URL: http://issues.apache.org/jira/browse/JCR-56
> Project: Jackrabbit
> 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.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Assigned: (JCR-56) allow case insensitive searches
Posted by "Marcel Reutegger (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/JCR-56?page=history ]
Marcel Reutegger reassigned JCR-56:
-----------------------------------
Assign To: Marcel Reutegger
> allow case insensitive searches
> -------------------------------
>
> Key: JCR-56
> URL: http://issues.apache.org/jira/browse/JCR-56
> Project: Jackrabbit
> 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.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Updated: (JCR-56) allow case insensitive searches
Posted by "Roy T. Fielding (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/JCR-56?page=history ]
Roy T. Fielding updated JCR-56:
-------------------------------
Component: sql
> allow case insensitive searches
> -------------------------------
>
> Key: JCR-56
> URL: http://issues.apache.org/jira/browse/JCR-56
> Project: Jackrabbit
> Type: New Feature
> Components: sql
> Reporter: Raphael Wegmueller
> 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.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira