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 <prathyush...@ceipal.com
> wrote:
> 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 Implementation and Support Payroll",
> "isParent":"2",
> "exp":5
> },
> {
> "description":" lucene solr",
> "isParent":"2",
> "exp":2
> }
> ]
>
> > }
>
>
>
> How can I form a query as
> *select?q=**:**&fq=(description:Payroll AND sum(exp):[7 TO 10]) AND
> **(description:support
> AND sum(exp):**[3 TO 10]**) *
>
> and get the parent *document id data1* as response.
> I need to sum the experience of child documents only if the description
> contains Payroll keyword
> Please guide me how can I achive the above query and response with my
> indexed documents
> --
>
> Thanks & Regards,
>
> Prathyusha Kondeti | Software Engineer
>
> Software Development
>
>
> [image: website-logo-org.png]
>
> CEIPAL Solutions Pvt Ltd
>
> Prashanthi Towers, 4th Floor, Road No: 92, Jubilee Hills, Hyderabad -
> 500033, INDIA
>
> [O] +91-40-43515100 [M] +91 9848143513 [E] prathyush...@ceipal.com [W]
> www.ceipal.com
>
> <http://www.ceipal.com>
>
> <http://www.ceipal.com>
>
> [image: consider.png]
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If you have received this email in error please notify the system manager.
> This message contains confidential information and is intended only for the
> individual named. If you are not the named addressee you should not
> disseminate, distribute or copy this e-mail. Please notify the sender
> immediately by e-mail if you have received this e-mail by mistake and
> delete this e-mail from your system. If you are not the intended recipient
> you are notified that disclosing, copying, distributing or taking any
> action in reliance on the contents of this information is strictly
> prohibited.
>
--
Sincerely yours
Mikhail Khludnev
