jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ard Schrijvers <a.schrijv...@onehippo.com>
Subject Re: SQL CONTAINS function
Date Wed, 06 Oct 2010 10:12:10 GMT
On Wed, Oct 6, 2010 at 10:12 AM,  <Sascha.Theves@innovations.de> wrote:
> Hi all,
>
>
>
> I am using Jackrabbit 1.6.2 and have problems with a SQL statement using
> the "CONTAINS" function. I want to perform a fulltext search on the
> binary content of my files stored in jackrabbit. The files have a
> primary node type of nt:file and the jcr:content child node is of type
> nt:resource. The content of the file is indexed. Now I want to perform a
> fulltext search with the following statement:
>
>
>
> SELECT * FROM nt:base WHERE contains(jcr:data, 'myData')

jcr:data is not indexed as a separate property but only on nodescope
level. Also see [1] where it was discussed lately,

Regards Ard

[1] http://jackrabbit.510166.n4.nabble.com/jcr-data-query-question-td518136.html

>
>
>
> However the result set is always empty. If I rewrite the query to:
>
>
>
> SELECT * FROM nt:base WHERE contains(., 'myData')
>
>
>
> my files will be found.
>
>
>
> My question is:
>
>
>
> Does Jackrabbit support using the CONTAINS function only for several
> attributes like jcr:data or is it only possible to search all indexed
> properties? Or do I misunderstand something?
>
>
>
> Kind regards
>
>
>
> Sascha Theves
> Platform and Technology (INST/EPI)
>
> --
> Innovations Software Technology
> Bosch Group
> Ziegelei 7, 88090 Immenstaad, Germany
> Telefon: +49(0)7545-202-537
> Fax:       +49(0)7545-202-301
> sascha.theves@innovations.de
> <BLOCKED::mailto:sascha.theves@innovations.de>
> www.innovations.de <http://www.innovations.de/>
>
> Executives: Achim Berger, Thomas Cotic, Thomas Schmid
> Register Court Ulm HRB 631888
>
> This message may contain confidential and privileged information. Any
> unauthorized review, use, disclosure or distribution is prohibited. If
> you are not the intended recipient, please inform us immediately and
> destroy this message including all copies thereof.
>
>
>
>



-- 
Hippo
Europe  •  Amsterdam  Oosteinde 11  •  1017 WT Amsterdam  •  +31 (0)20 522 4466
USA  • San Francisco  185 H Street Suite B  •  Petaluma CA 94952-5100
•  +1 (707) 773 4646
Canada    •   Montréal  5369 Boulevard St-Laurent  •  Montréal QC H2T
1S5  •  +1 (514) 316 8966
www.onehippo.com  •  www.onehippo.org  •  info@onehippo.com

Mime
View raw message