Re: Querying on sum of child documents

2019-02-21 Thread flatmind
Hello Mikhail - Thanks for your help with the query and I was able to get the result. But when I am trying to add another condition to that, it is not showing any results, though there are matching records in the index. But when I execute those queries individually, I am getting the response. This

Re: Querying on sum of child documents

2019-02-20 Thread Mikhail Khludnev
q={!frange l=8}{!parent which=isParent:1 score=total v=$chq}&chq=+isParent:2^=0 AND description:payroll^=0 AND {!func}exp On Wed, Feb 20, 2019 at 7:39 PM flatmind wrote: > Hi > I tried with the below query > > q={!frange l=8}{!parent which=isParent:1 score=total v=$chq} AND chq=+ > isParent:2 A

Re: Querying on sum of child documents

2019-02-20 Thread flatmind
Hi I tried with the below query q={!frange l=8}{!parent which=isParent:1 score=total v=$chq} AND chq=+ isParent:2 AND description:payroll AND {!func}exp I applied lower limit as 8 still the record is coming in the results.Where sum of the child documents matching with "payroll" description is 7

Re: Querying on sum of child documents

2018-02-09 Thread Prath
We need sum of experiences from each child documents. Using this expression "exp:[4 TO 7]" we are directly querying the single child document with the experience between 4 to 7 but not sum of experiences of all child documents.For that we have to do something. Could you please help me out with tha

Re: Querying on sum of child documents

2018-02-06 Thread Mikhail Khludnev
exp=total seems strange it should be score. Then, childquery clauses might need to be appended with ^=0 to suppress unnecessary scoring. Check debugQuery output to make sure if query is parsed as expected. On Tue, Jan 30, 2018 at 10:10 AM, Prath wrote: > Hi, > I used following query > {!parent

Re: Querying on sum of child documents

2018-01-29 Thread Prath
Hi, I used following query {!parent which="isParent:1" exp=total}+description:JSON +exp:[4 TO 7] {!func}exp. It is considering only highest experience from matched descriptions but not sum of matched description experience. Can you please explain me in detail. -- Sent from: http://lucene.472066.

Re: Querying on sum of child documents

2018-01-17 Thread Mikhail Khludnev
Hello, It should be something like {!parent ... score=total}+description:support +exp:[3 TO 7] {!func}exp On Wed, Jan 17, 2018 at 3:05 PM, Prathyusha Kondeti wrote: > Hi, > I have the following indexed documents > { >"id":"data1", >"isParent":"1", >"_childDocuments":[ > { >

Querying on sum of child documents

2018-01-17 Thread Prathyusha Kondeti
Hi, I have the following indexed documents { "id":"data1", "isParent":"1", "_childDocuments":[ { "description": "Benefit and Payroll consultant with HR team support ", "isParent":"2", "exp":2 }, { "description":" ERP Avalon Implementat