Try using solr streaming api. https://lucene.apache.org/solr/guide/6_6/streaming-expressions.html Sample query: innerJoin( select(search(<collection 1 name>, q=<collection 1 query>, fl=<collection 1 select fields>, sort=<sort criteria>, qt="/export"), <select field name with alias >), select(search(search(<collection 2 name>, q=<collection 2 query>, fl=<collection 2 select fields>, sort=<sort criteria>, qt="/export"), <select field name with alias >), on=<join field>)
Note : Both collections must have at least one common field to perform the joining. On Fri, Jan 12, 2018 at 4:57 AM, Fiz Newyorker <fiznewy...@gmail.com> wrote: > Hi Team, > > Could you please let me know how to handle the below scenario. > > I have Two Collections *Accounts & Content.* > > I am trying to search term *"biodata". * > > from Accounts Collections I am getting the output *sample : your biodata* > > from Content Collections I am getting the output *title : my biodata* > > *how to combine these Two results against 2 different collection and > get the results . can you let me know sample solr query to run ? * > > Your help is much appreciated. > > > Thanks > Fiz. > -- Thanks and Regards, Suman Saurabh