It'd be helpful to also know the version of Oak and Solr you're using and, possibly, sample content you expect the query to match.
Thanks, Tommaso Il giorno ven 24 mar 2017 alle ore 14:54 Thomas Mueller <[email protected]> ha scritto: > Could you post the index definition please? > > > From: Ancona Francesco <[email protected]> > Reply-To: "[email protected]" <[email protected]> > Date: Thursday, 23 March 2017 at 15:19 > To: "[email protected]" <[email protected]> > Cc: Diquigiovanni Simone <[email protected]> > Subject: problem on oak jcr sql2 query > > Hi all, > we use SolrSrerver for fulltext searches; both on metadata both on content > binary. > In general i have to find all nodes nt:file that contain the word > “company” or all nodes that have childs nt:resource that contain the same > word. > > Unfortunately if upload e file (so a node that is a nt:resource) and i use > this query > SELECT p.* FROM [nt:file] as p where contains(p.*,''company ') > > Solr find result but the RowIterator doesn’t return anything. > > Instead the above query works > SELECT p.* FROM [nt:resource] as p where contains(p.*,'company') > But doesn’t find nt:file nodes > > Can you help me ? > > Thanks in advance. > > > [cid:[email protected]] > Francesco Ancona | Software Dev. Dept. (SP) - Software Architect > tel. +39 049 8979797 <049%20897%209797> | fax +39 049 8978800 > <049%20897%208800> | cel. +39 3299060325 <329%20906%200325> > e-mail: [email protected] | www.siav.it< > https://na01.safelinks.protection.outlook.com/?url=www.siav.it&data=02%7C01%7C%7Caed3cadf483741e2971708d471f7b284%7Cfa7b1b5a7b34438794aed2c178decee1%7C0%7C0%7C636258756051666135&sdata=GFXjC%2BgyoIh37AXmGYhYdORtXp1dFiA5v0hoghgbtBw%3D&reserved=0 > > > > I contenuti di questa e-mail e dei suoi allegati sono confidenziali e > riservati esclusivamente ai destinatari. > L'utilizzo per qualunque fine del presente messaggio e degli allegati così > come la relativa divulgazione senza l'autorizzazione del mittente sono > vietati. > Se avete ricevuto questa e-mail per errore, vi preghiamo di distruggerla e > di comunicarcelo. > I dati personali sono trattati esclusivamente per le finalità della > presente comunicazione in conformità con la legislazione vigente (D.lgs. > 196/2003 "Codice Privacy"). > Per informazioni: SIAV S.p.A. – [email protected] – 049 8979797 > <049%20897%209797> > > The contents of this e-mail and its attachments are confidential and > reserved exclusively to the recipients. > The use for any purpose of this message and attachments as well as its > disclosure without the consent of the sender is prohibited. > If you have received this email in error, please destroy it and notify us. > Personal data shall be processed solely for the purposes of this notice in > accordance with current legislation (Legislative Decree no. 196/2003 > "Code"). > For more information: SIAV S.p.A. – [email protected] – 049 8979797 > <049%20897%209797> > >
