Martijn,
I'm just seeing this reply today, please excuse the late reply.
I tried your suggestion, it I do get results back, but I get back a list of
Users when I instead am trying to get back a list of Posts.
Is it not possible to arbitrarily sort by either side of the join in solr?
> Have
Have your tried using the join in the fq instead of the q?
Like this (assuming user_id_i is a field in the post document type and
self_id_i a field in the user document type):
q=posts_text:"hello"&fq={!join from=self_id_i
to=user_id_i}is_active_boolean:true
In this example the fq produces a docset
Does anyone have any idea on this issue?
On Tue, Oct 25, 2011 at 11:40 AM, Jason Toy wrote:
> Hi Yonik,
>
> Without a Join I would normally query user docs with:
> q=data_text:"test"&fq=is_active_boolean:true
>
> With joining users with posts, I get no no results:
> q={!join from=self_id_i
> to=
Hi Yonik,
Without a Join I would normally query user docs with:
q=data_text:"test"&fq=is_active_boolean:true
With joining users with posts, I get no no results:
q={!join from=self_id_i
to=user_id_i}data_text:"test"&fq=is_active_boolean:true&fq=posts_text:"hello"
I am able to use this query, bu
Can you give an example of the request (URL) you are sending to Solr?
-Yonik
http://www.lucidimagination.com
On Mon, Oct 24, 2011 at 3:31 PM, Jason Toy wrote:
> I have 2 types of docs, users and posts.
> I want to view all the docs that belong to certain users by joining posts
> and users toge
I have 2 types of docs, users and posts.
I want to view all the docs that belong to certain users by joining posts
and users together. I have to filter the users with a filter query of
"is_active_boolean:true" so that the score is not effected,but since I do a
join, I have to move the filter query
