On Wed, Oct 6, 2010 at 10:12 AM, <[email protected]> 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 > [email protected] > <BLOCKED::mailto:[email protected]> > 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 • [email protected]
