@techie2k Not sure if you have any specific index configurations set. But give this a try: select * from [nt:resource] AS resource where contains*(resource.*,**'*1*')*
jackrabbit adds binary properties content to the index of the node itself. Hope that helps. Cheers On Sun, Oct 11, 2015 at 10:05 AM, Clay Ferguson <[email protected]> wrote: > 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 > [email protected] > > > On Sun, Oct 11, 2015 at 1:57 AM, techie2k <[email protected]> > 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. > > >
