lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From heaven <aheave...@gmail.com>
Subject Query time join with conditions
Date Fri, 27 Dec 2013 13:17:34 GMT
Hello, I have one physical Solr collection and multiple logical collections
in it. The separation is done by using the "type" field (Ruby on Rails
application). So I have 2 logical collections: Profile and RssEntry and
would not want to add RssEntries content to Profiles index.

When I want to search some profiles my usual query looks like this:
[ path=select parameters={fq: ["type:Profile"], sort: "score desc", start:
0, rows: 20, defType: "edismax", boost: [], q: "*:*"} ]

But this time I need to also search in associated RssEntries content. In SQL
my query would look like this:
SELECT * FROM profiles INNER JOIN (SELECT * FROM rss_entries WHERE
rss_entries.keywords LIKE '#{query}') ON profiles.id =
rss_entries.profile_id

So basically in Solr query I need something like {!join from=profile_id
to=id WHERE type = 'RssEntry'}. I heard there are additional parameters like
fromQuery and fromSearcher, but cant find anything about them here
http://wiki.apache.org/solr/Join

Any help appreciated,
Alex



--
View this message in context: http://lucene.472066.n3.nabble.com/Query-time-join-with-conditions-tp4108365.html
Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message