Hi, thanks for the response. Seems almost figured things out.

Since both Profiles and RssEntries are in the same index (same core), it is
possible to either use `v=` param or specify `type:RssEntry` right after the
closing `}`. Both will work:
{!join from=profile_ids_im to=id_i}type:RssEntry
or
{!join from=profile_ids_im to=id_i v=$rssQuery}&rssQuery=(type:RssEntry)

But there are a few side effects:
1. This query will filter out all profiles that do not have RssEntries,
which is not desired in my case. I simply need to look if profile's or one
of related rss entries' content includes certain words. Like a LEFT JOIN,
but getting INNER JOIN instead.
2. Not clear to me how to use fulltext search on joined rss entries. This
query does not work for me:
 * There's one profile with rss entry: http://oi39.tinypic.com/2i91mir.jpg
 * But search by rss entry text field does not work:
http://oi42.tinypic.com/sfywex.jpg
 * But an rss entry with "Test entry" content exists:
http://oi41.tinypic.com/2j5gm6s.jpg

Is there any way to perform a left join operation, so profiles without rss
entries will not be lost? Or to use the OR operator to match both profiles
that have "test entry" content AND profiles which own rss entry that has
"test entry" content?

Thanks in advance,
Alex



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

Reply via email to