keyword search

rubyonrails-talk
1

I'm having trouble trying to implement a basic keyword search in my app. I'm trying to search through multiple tables. I m using a vendor plugin for the conditions(which should not effect the search). The association in the models is as following

The furni model contains this association to the raider model:

  belongs_to :raider, :foreign_key => "original_raider_id"

The controller call

unless params[:search].blank? @furni_pages, @furnii = paginate :furnii, :conditions => Furni.conditions_by_like(params[:search]), :per_page => 10, :order => order_from_params

So what I'm trying to do is to have the search go through the raiders table as well. I do not know if it's possible. I tried joins with no luck. Hope some one can give me a pointer. Thanks

2

the include statement should work:

@furni_pages, @furnii = paginate :furnii, :include => "raiders", :conditions => Furni.conditions_by_like(params[:search]), :per_page => 10, :order => order_from_params

then you could enhance your conditions with something like: "raiders.column_name='whatever'"

important point is, that if you use include, you'll have to specify the table name for all fields that exist in both tables (eg created_at)

3

Thorsten Mueller wrote:

the include statement should work:

@furni_pages, @furnii = paginate :furnii, :include => "raiders", :conditions => Furni.conditions_by_like(params[:search]), :per_page => 10, :order => order_from_params

then you could enhance your conditions with something like: "raiders.column_name='whatever'"

important point is, that if you use include, you'll have to specify the table name for all fields that exist in both tables (eg created_at)

how do I incorporate the "raiders.column_name='whatever'" in the existing conditions?

4

how do I incorporate the "raiders.column_name='whatever'" in the existing conditions?

This may depend on what exactly this Furni.conditions_by_like(params[:search]) returns.

in general:

:conditions => { "raiders.column_name" => "something", Furni.conditions_by_like(params[:search]) })

may work, if your method returns a simple conditions string. If it returns the conditions in Array or Hash form, you may have to merge it with the additional conditions for raiders.

5

Thorsten Mueller wrote:

how do I incorporate the "raiders.column_name='whatever'" in the existing conditions?

This may depend on what exactly this Furni.conditions_by_like(params[:search]) returns.

in general:

:conditions => { "raiders.column_name" => "something", Furni.conditions_by_like(params[:search]) })

may work, if your method returns a simple conditions string. If it returns the conditions in Array or Hash form, you may have to merge it with the additional conditions for raiders.

Thanx for your help, but it does not work. The conditions_by_like function is a vendor plug in and it performs a generic search(below). I do not know what I'm doing wrong.

def conditions_by_like(value, *columns)       columns = self.user_columns if columns.size==0       columns = columns[0] if columns[0].kind_of?(Array)       conditions = columns.map {|c|         c = c.name if c.kind_of? ActiveRecord::ConnectionAdapters::Column         "`#{c}` LIKE " + ActiveRecord::Base.connection.quote("%#{value}%")       }.join(" OR ")     end

CONTROLLER CALL

def search    unless params[:search].blank?     @furni_pages, @furnii = paginate :furnii,       :include => "raider",       #:conditions => {"raiders.column_name" => "email", Furni.conditions_by_like(params[:search])},       :conditions => {"raiders.column_name='email'", Furni.conditions_by_like(params[:search])},       :per_page => 10,       :order => order_from_params     else       index     end     render :partial=>'furnilist', :layout=>false   end