Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
MIME-Version: 1.0
In-Reply-To: <KL1PR0302MB2502ADE9C1F4EB644A3B6FBC9D4A0@KL1PR0302MB2502.apcprd03.prod.outlook.com>
References: <KL1PR0302MB250202B81C07FB976F57E7AF9D4B0@KL1PR0302MB2502.apcprd03.prod.outlook.com>
 <CAF8TkC5DmMfQ_SGgZ6SDPO=mVbY6fFPjw7RNBPwHUm5Rk+9G4Q@mail.gmail.com> <KL1PR0302MB2502ADE9C1F4EB644A3B6FBC9D4A0@KL1PR0302MB2502.apcprd03.prod.outlook.com>
From: Mikhail Khludnev <mkhl@apache.org>
Date: Tue, 31 Jan 2017 11:03:32 +0300
Message-ID: <CAF8TkC40a9_m7tDO-nGZmGR-pqRTu5sL4K-u1X5kbs72tO=eKQ@mail.gmail.com>
Subject: Re: Return specific field from child documents.
To: solr-user <solr-user@lucene.apache.org>
Content-Type: multipart/alternative; boundary=001a114a97044a972805475f5e69
archived-at: Tue, 31 Jan 2017 08:03:36 -0000

--001a114a97044a972805475f5e69
Content-Type: text/plain; charset=UTF-8

it should be something like
emp.q={!child of=content_type:parent}{!terms f=contact_id v=$row.id}

On Tue, Jan 31, 2017 at 10:30 AM, Preeti Bhat <preeti.bhat@shoregrp.com>
wrote:

> Hi Mikhail,
>
> I was trying to restrict the data from child documents due to one of the
> request of the client where they would need the specific fields as output.
> The below query gives me the firstName and Last Name as expected but not
> the email which is part of the child document.
> http://localhost:8984/solr/Contact/select?fl=FirstName,
> LastName,email,%20[child%20parentFilter=content_type:
> parent%20]&indent=on&q={!parent%20which=%22content_
> type:parent%22}%20email:%22temper.t@tempest.com%22&wt=json
>
> I did try the sub query, but its returning only the parent document. Not
> sure if I am missing something here.
>
> http://localhost:8984/solr/Contact/select??fl=id,
> FirstName,email,emp:[subquery]&emp.rows=10&emp.fl=email&emp.
> q={!term%20f=contact_id%20v=$row.id}&indent=on&q=%7b!
> parent%20which=%22content_type:parent%22%7d%20email:%
> 22temper.t@tempest.com%22&wt=json&expandMacros=true
>
> I am expecting the result to be something like this. Could you please
> advise.
> {
>         "FirstName":"temptest",
>         "LastName":"temper",
> "_childDocuments_":[
> { "email":["temper.t@tempest.com"]
> },
> {"email":["temper.ttttt@tempt.com"]
> }
> ]
> }
>
> Thanks and Regards,
> Preeti Bhat
>
> -----Original Message-----
> From: Mikhail Khludnev [mailto:mkhl@apache.org]
> Sent: Monday, January 30, 2017 5:49 PM
> To: solr-user
> Subject: Re: Return specific field from child documents.
>
> Hello,
>
> You hardly get any gain limiting child field output. You can do that with
> [subquery] result transformer.
>
> On Mon, Jan 30, 2017 at 11:09 AM, Preeti Bhat <preeti.bhat@shoregrp.com>
> wrote:
>
> > Hi All,
> >
> > I am trying out the nested documents concept for SOLR. I am able to
> > show the specific field for the parent document like
> > "FirstName","LastName" but I am not able to show the specific field in
> fl for child.
> >
> > I would like to retrieve the email from the _childDocuments. Could
> > someone please advise.
> >
> > Q=+FirstName:"etr4tr" {!parent which="content_type:parent"}
> > Fl=FirstName,LastName,email, [child parentFilter=content_type:parent ]
> >
> >   "response":{"numFound":1,"start":0,"docs":[
> >       {
> >         "FirstName":"etr4tr",
> >         "LastName":"wrer6t",
> >         "_childDocuments_":[
> >         {
> >           "id":"3556|12",
> >           "company_id":["12"],
> >           "email":["ehrijw.egru@bbbbb.com"],
> >           "isPrimary":["true"]},
> >         {
> >           "id":"3556|45",
> >           "company_id":["45"],
> >           "email":["ehrijw.eer54gru@ccc.com"]}]}]
> >   }}
> >
> >
> > Thanks and Regards,
> > Preeti Bhat
> >
> >
> >
> > NOTICE TO RECIPIENTS: This communication may contain confidential
> > and/or privileged information. If you are not the intended recipient
> > (or have received this communication in error) please notify the
> > sender and it-support@shoregrp.com immediately, and destroy this
> > communication. Any unauthorized copying, disclosure or distribution of
> > the material in this communication is strictly forbidden. Any views or
> > opinions presented in this email are solely those of the author and do
> > not necessarily represent those of the company. Finally, the recipient
> > should check this email and any attachments for the presence of
> > viruses. The company accepts no liability for any damage caused by any
> virus transmitted by this email.
> >
> >
> >
>
>
> --
> Sincerely yours
> Mikhail Khludnev
>
> NOTICE TO RECIPIENTS: This communication may contain confidential and/or
> privileged information. If you are not the intended recipient (or have
> received this communication in error) please notify the sender and
> it-support@shoregrp.com immediately, and destroy this communication. Any
> unauthorized copying, disclosure or distribution of the material in this
> communication is strictly forbidden. Any views or opinions presented in
> this email are solely those of the author and do not necessarily represent
> those of the company. Finally, the recipient should check this email and
> any attachments for the presence of viruses. The company accepts no
> liability for any damage caused by any virus transmitted by this email.
>
>
>


-- 
Sincerely yours
Mikhail Khludnev

--001a114a97044a972805475f5e69--