lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mikhail Khludnev <m...@apache.org>
Subject Re: Combining complex joins with other criteria
Date Thu, 23 Nov 2017 19:13:52 GMT
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.frese@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message