Hello, David. It should be like q=name:"Mike" AND {!join from=pid to=id v=$qq}&qq=city:"London" AND id:"a1"
On Thu, Nov 23, 2017 at 10:06 PM, David Frese <david.fr...@active-group.de> wrote: > Hi there everbody, > > I want to combine joins with multiple criteria and other criteria, with > variying boolean operators, but I keep getting > "org.apache.solr.search.SyntaxError: Cannot parse" errors. I tried with > an installation of version 6.3, and also with the embedded server in > version 7.1 > > Given these two documents: > > {"id": "p1", "name": "Mike"} > {"id": "a1", "pid": "p1", "city": "London"} > > thw following queries work just fine: > > {!join from=pid to=id}(city:"London" AND id:"a1") > name:"Mike" AND id:"p1" > name:"Mike" AND {!join from=pid to=id}city:"London" > > but when I start trying multiple criteria to the join, I keep getting > parse errors with a message like "Cannot parse '(city:"London"': > Encountered "<EOF>" at line 1, column 39." > Seems something is eating up (or not eating) the braces? > > I tried all the following variants already, and all fail: > > name:"Mike" AND {!join from=pid to=id}(city:"London" AND id:"a1") > > name:"Mike" AND ({!join from=pid to=id}(city:"London" AND id:"a1")) > > (name:"Mike") AND ({!join from=pid to=id}(city:"London" AND id:"a1")) > > (name:"Mike" AND {!join from=pid to=id}(city:"London" AND id:"a1")) > > Some other variants do parse, but are somehow misunderstood and do not > yield any results, like: > > name:"Mike" AND ({!join from=pid to=id}city:"London" AND id:"a1") > > > > Thanks for any help! > > -- > David Frese > -- Sincerely yours Mikhail Khludnev