ok. what about emp.q={!child of=content_type:parent}{!terms f=id v=$row.id}On Tue, Jan 31, 2017 at 11:22 AM, Preeti Bhat <preeti.b...@shoregrp.com> wrote: > Hi Mikhail, > > Thanks for reply, but It doesn't seem to work. > > http://localhost:8984/solr/Contact/select?fl=id, > FirstName,emp:[subquery]&emp.rows=10&emp.fl=email&emp.q={! > child%20of=content_type:parent}{!term%20f=contact_id% > 20v=$row.id}&indent=on&q={!parent%20which=%22content_ > type:parent%22}%20email:%22tempe...@tempest.com%22&wt= > json&expandMacros=true > > I am getting the below response. > > { > "responseHeader":{ > "zkConnected":true, > "status":0, > "QTime":0, > "params":{ > "emp.fl":"email", > "q":"{!parent which=\"content_type:parent\"} email:\" > tempe...@tempest.com\"", > "emp.rows":"10", > "indent":"on", > "expandMacros":"true", > "fl":"id,FirstName,emp:[subquery]", > "emp.q":"{!child of=content_type:parent}{!term f=contact_id v=$ > row.id}", > "wt":"json"}}, > "response":{"numFound":1,"start":0,"docs":[ > { > "id":"7888", > "FirstName":"temptest"}] > }} > > Thanks and Regards, > Preeti Bhat > > -----Original Message----- > From: Mikhail Khludnev [mailto:m...@apache.org] > Sent: Tuesday, January 31, 2017 1:34 PM > To: solr-user > Subject: Re: Return specific field from child documents. > > 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.b...@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:%22tempe...@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:% > > 22tempe...@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":["tempe...@tempest.com"] > > }, > > {"email":["temper.tt...@tempt.com"] > > } > > ] > > } > > > > Thanks and Regards, > > Preeti Bhat > > > > -----Original Message----- > > From: Mikhail Khludnev [mailto:m...@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.b...@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.e...@bbbbb.com"], > > > "isPrimary":["true"]}, > > > { > > > "id":"3556|45", > > > "company_id":["45"], > > > "email":["ehrijw.eer54...@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-supp...@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-supp...@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-supp...@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
