Combining complex joins with other criteria

[David Frese]

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