Sorry. Made a correction. Lol On Wed, Oct 14, 2015, 10:26 PM Clay Ferguson <[email protected]> wrote:
> 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. > > > > > > > > > >
