Thanks Mikhail, I will look into this option.
Thanks and Regards, Preeti Bhat -----Original Message----- From: Mikhail Khludnev [mailto:m...@apache.org] Sent: Friday, March 03, 2017 1:03 PM To: solr-user Subject: Re: Joining across collections with Nested documents Related docs can be retrieved with https://cwiki.apache.org/confluence/display/solr/Transforming+Result+Documents#TransformingResultDocuments-[subquery] but searching related docs is less ready. Here is a patch for query time join across collections https://issues.apache.org/jira/browse/SOLR-8297. On Fri, Mar 3, 2017 at 8:55 AM, Preeti Bhat <preeti.b...@shoregrp.com> wrote: > Hi All, > > I have two collections in solrcloud namely contact and company, they > are in same solr instance. Company is relatively simpler document with > id, Name, address etc... Coming over to Contact, this has the nested > document like below. I would like to get the Company details using the > "CompanyId" > field in child document by joining this to the "Company" > collections's id document. Is this possible? Could someone please guide me on > this? > > { > id: "1" > , FirstName: "ABC" > , LastName: "BCD" > . > . > . > _childDocuments_:{ > { > id:"123-1", > CompanyId: "123", > Email: "abc....@smd.edu" > } > { > id:"124-1", > CompanyId: "124", > Email: "abc....@smd.edu" > > } > } > > > > 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.
