Ruby Forum Ferret > Multi select with conditions

Hi

I'm doing a multi-model search like this, which works absolutely fine:

        @search_results = ActsAsFerret::find( "trumpet", [Resource, 
Lesson,
Course],
                                    #(ferret) options
                                    { :page => 1,
                                      :per_page => 20,
                                      :sort =>
Ferret::Search::SortField.new(:name, :reverse => false)
                                    },
                                    #find options
                                    {}
                                 )

My new problem is that the results need to be restricted: basically any 
user
has only limited access to certain lessons, resources and courses, 
depending
on their shared priveleges.  I have methods to produce arrays of ids of 
each
that the user is allowed to see, eg

@user.allowed_lessons
  => array of ids of all lessons the user has access to

Can anyone show me how to incorporate this into my search?  I have the
feeling that i can do something with the :conditions options, which can 
be
passed through in the find options hash.  But i can't work it out:  i 
tried
this:

:conditions => ["lesson.id in (?) or course.id in (?) or resource.id in
(?)", @user.allowed_lessons, @user.allowed_courses, 
@user.allowed_resources]

But it doesn't work:  it says 'no such field as lesson.id in resources'. 
I
feel like this should be possible - can anyone help?

thanks
max

I have the same problem Max, did you solve it?

Regards!

Hi Max,

Try this:


@search_results = ActsAsFerret::find("trumpet", [Resource, Lesson, 
Course],
                                    #(ferret) options
                                    { :page => 1,
                                      :per_page => 20,
                                      :sort => 
Ferret::Search::SortField.new(:name, :reverse => false)
                                    },
                                    #find options - note this assumes 
it's a flat array of allowed id numbers:
                                    { :lesson   => "lessons.id IN 
(#{@user.allowed_lessons.join(',')})",
                                      :course   => "courses.id IN 
(#{@user.allowed_courses.join(',')})",
                                      :resource => "resources.id IN 
(#{@user.allowed_resources.join(',')})"
                                    }
                                 )

Sorry, I missed the :conditions key in the last hash
{ :conditions => {:lesson   => "lessons.id IN
(#{@user.allowed_lessons.join(',')})",
                  :course   => "courses.id IN
(#{@user.allowed_courses.join(',')})",
                  :resource => "resources.id IN
(#{@user.allowed_resources.join(',')})"
                 }
}

Thanks all

On the way to solving this i found a bug in acts_as_ferret - it seems 
that if i try to sort, paginate and use conditions at the same time then 
the sorting breaks down:  instead of being sorted and then paginated, 
the results are paginated (ordered simply by id) and then sorted within 
each page.

I let Jens Kraemer (and the acts as ferret mailing list) know about it 
but as far as i know it's not been fixed.

I ended up doing a ferret search to get the ids of the results (with 
unallowed records filtered out), and then doing an AR find to get those 
results, sort and paginate them.  So, it's a little inelegant but it 
works, at least.

thanks
max