Ferret talk - Apr 2008 - 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://rubyforge.org/pipermail/ferret-talk/attachments/20080417/ea8fbed5/attachment.html

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
-- 
Posted via http://www.ruby-forum.com/.