..&fq=aaa:1 bbb:2&.. On Wed, May 11, 2016 at 11:34 PM, baggadonuts <johnpr...@hotmail.com> wrote:
> Refer to the following documentation: https://wiki.apache.org/solr/Join > > According to the documentation the SOLR equivalent of this SQL query: > > SELECT xxx, yyy > FROM collection1 > WHERE outer_id IN (SELECT inner_id FROM collection1 where zzz = "vvv") > > is this: > > /solr/collection1/select ? fl=xxx,yyy & q={!join from=inner_id > to=outer_id}zzz:vvv > > Basically the SQL equivalent of what I'd like to do is: > > SELECT xxx, yyy > FROM collection1 > WHERE (aaa = "1" OR bbb = "2") > AND outer_id IN (SELECT inner_id FROM collection1 where zzz = > "vvv") > > Is it possible to do this query in SOLR? > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/How-to-self-join-a-collection-with-SOLR-and-have-another-condition-tp4276235.html > Sent from the Solr - User mailing list archive at Nabble.com. > -- Sincerely yours Mikhail Khludnev Principal Engineer, Grid Dynamics <http://www.griddynamics.com> <mkhlud...@griddynamics.com>
