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