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, but it gives me the results in an order that I
dont want(nor do I understand its order):
q={!join from=self_id_i to=user_id_i}data_text:"test" AND
is_active_boolean:true&fq=posts_text:"hello"
I want the order to be the same as I would get from my original
"q=data_text:"test"&fq=is_active_boolean:true", but with the ability to join
with the Posts docs.
On Tue, Oct 25, 2011 at 11:30 AM, Yonik Seeley
<yo...@lucidimagination.com>wrote:
> 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 <jason...@gmail.com> 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 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 to the query parameter so that I
> can
> > get the filter applied. The problem is that since the is_active_boolean
> is
> > moved to the query, the score is affected which returns back an order
> that I
> > don't want.
> > If I leave the is_active_boolean:true in the fq paramater, I get no
> > results back.
> >
> > My question is how can I apply a filter query to users so that the score
> is
> > not effected?
> >
>
--
- sent from my mobile
