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.
