Hi, I have two Aliases in SolrCloud,
1. *Article *with columns id, articleid, variantid, language, content_type, description. 2. *ArticleAttributes *with columns for PARENT id, articleid, variantid, language, description (multivalued field with all values of attributes) and CHILDS (detailed information about each attribute) with columns id, attributeid, content_type, value (value for each attribute). My problem is to search in alias ArticleAttributes all Parent records where some attributeid="someid" and value="text1" and language="DE" joined in the same time with alias Article where description="text2" on Article.articleid=ArticleAttributes.articleid AND Article.variantid=ArticleAttributes.variantid AND Article.language=ArticleAttributes.language For this i have a query like this: http://localhost:8983/solr/articleattributes/select?fq={!parent which="content_type:1 AND language:DE"}((value:*16mm*) AND attributeid:517310)&fl=*,article:[subquery]&article.q={!terms f=articleid v=$row.articleid}&q=*Schlauchverschraubung* In my case with [subquery] I need to join 3 fileds, but [subquery] logic support only one field to joining. Now question, exist some syntacs or another possibility to make this join on multiple fields (idee to concatenate all this fields in one field is not accepted from the point that this is only one case, but in some case join must be on others fields and for each case to create on field is a utopia). -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
