R: problem on oak jcr sql2 query

2017-04-04 Thread Ancona Francesco
to: Re: problem on oak jcr sql2 query Hi Francesco, do you have other indexes within your Oak repo ? No. We haven’t other indexes. It might be that the query engine selects a different index which only acts on [nt:file] nodes. You can try checking the plan [1] for your query and c

Re: problem on oak jcr sql2 query

2017-03-29 Thread Davide Giannella
On 28/03/2017 12:34, Tommaso Teofili wrote: > It might also be useful to enable debug logging > for org.apache.jackrabbit.oak.query, +1 and provide the output somewhere on the web for easy reading. For example gist.github.com works perfectly for this. Davide

Re: problem on oak jcr sql2 query

2017-03-28 Thread Tommaso Teofili
li [mailto:tomm...@apache.org] > Inviato: martedì 28 marzo 2017 10:33 > A: oak-dev@jackrabbit.apache.org > Cc: Diquigiovanni Simone <simone.diquigiova...@siav.it> > Oggetto: Re: problem on oak jcr sql2 query > > Hi Francesco, > > Il giorno lun 27 mar 2017 alle ore 08:5

R: problem on oak jcr sql2 query

2017-03-28 Thread Ancona Francesco
A: oak-dev@jackrabbit.apache.org Cc: Diquigiovanni Simone <simone.diquigiova...@siav.it> Oggetto: Re: problem on oak jcr sql2 query Hi Francesco, Il giorno lun 27 mar 2017 alle ore 08:59 Ancona Francesco < francesco.anc...@siav.it> ha scritto: Sorry. We are using Oak 1.4.10 and solr 4.

Re: problem on oak jcr sql2 query

2017-03-28 Thread Tommaso Teofili
2017 14:56 A: oak-dev@jackrabbit.apache.org Cc: Diquigiovanni Simone <simone.diquigiova...@siav.it> Oggetto: Re: problem on oak jcr sql2 query 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

R: problem on oak jcr sql2 query

2017-03-27 Thread Ancona Francesco
in advance, best regards -Messaggio originale- Da: Tommaso Teofili [mailto:tommaso.teof...@gmail.com] Inviato: venerdì 24 marzo 2017 14:56 A: oak-dev@jackrabbit.apache.org Cc: Diquigiovanni Simone <simone.diquigiova...@siav.it> Oggetto: Re: problem on oak jcr sql2 query It'd be he

Re: problem on oak jcr sql2 query

2017-03-24 Thread Tommaso Teofili
t; Cc: Diquigiovanni Simone <simone.diquigiova...@siav.it> > 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 > “com

Re: problem on oak jcr sql2 query

2017-03-24 Thread Thomas Mueller
abbit.apache.org> Cc: Diquigiovanni Simone <simone.diquigiova...@siav.it> 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 nod

problem on oak jcr sql2 query

2017-03-23 Thread Ancona Francesco
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