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 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