Hi, Solr team I am using Solr 8.11 to change join query to crossCollection join. When I compared the query and result, I noticed something different.
If the join query is: q.op=AND&q=network_id:144750 AND {!join fromIndex=company from=id to=advertiser_id v='name:(sky vip) AND index_type:ADV'} When query the fromIndex(company), the q.op=AND will work on name:(sky vip), so the value of name must contains sky and vip. If the crossCollection join query is: q.op=AND&q=network_id:144750 AND {!join method='crossCollection' fromIndex=company from=id to=advertiser_id v='name:(sky vip) AND index_type:ADV'} When query the fromIndex(company), the q.op=AND not work on name:(sky vip). In other words, the value of name contains sky or vip, it uses q.op=OR. So I want to ask, how I should configure the solr configure file or how do I write the query, the q.op=AND will apply to the fromIndex query? Hope to get your response, thanks!