Uh Ben....are you sure the asterisks are all correct on that? lol. Seriously, can you check that. I would swear that won't work, but I've been wrong before, and since that one time have always remained humble ever since!
Best regards, Clay Ferguson [email protected] On Wed, Oct 14, 2015 at 9:20 PM, Ben Frisoni <[email protected]> wrote: > @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. > > > > > >
