Here's an example SQL search code form meta64. Note it uses "like" instead of "contains" because of Lucene having an issue with 'contains' not working.
https://github.com/Clay-Ferguson/meta64/blob/master/src/main/java/com/meta64/mobile/service/NodeSearchService.java That search code, as you can see, searches nt:base and under specific root node only. But your problem may be that binaries aren't being searched in properly, so be sure Tika is properly enabled. (not sure how, probably is enabled by default). Use "Tika Configuration" as a search term. Best regards, Clay Ferguson wcl...@gmail.com On Sun, Oct 11, 2015 at 1:57 AM, techie2k <developer.spr...@gmail.com> wrote: > Hi, > > I'm using Jackrabbit 2.6.0 and java 1.6 > > Trying to search text from word/pdf/text files, but eventually search fails > with jcr:data. > Only searches in document meta data and not on contents > > SQL-2 query > > select * from [nt:resource] AS resource where contains(resource.[jcr:data], > '*1*') > > Any help on this? > > Attachment repository config and cnd file: > repository.xml > <http://jackrabbit.510166.n4.nabble.com/file/n4663116/repository.xml> > et_nodetypes.cnd > <http://jackrabbit.510166.n4.nabble.com/file/n4663116/et_nodetypes.cnd> > > > > > > > > -- > View this message in context: > http://jackrabbit.510166.n4.nabble.com/Document-search-fails-tp4663116.html > Sent from the Jackrabbit - Users mailing list archive at Nabble.com. >
