Using associated_against and multisearchable together

[cbillen]

I want to use Multisearch along side associated against so for instance in my imaginary example:

class Order < ActiveRecord::Base
     multisearchable :against => [:reference_number, { :shipping_address => [:person_name_override, :company_name_override] }]
end

Then be able to run

PgSearch.multisearch('search_term') 

and have it go against the associated against model, is that possible to achieve?

[nertzy]

No, because the multisearch feature uses a polymorphic association, which cannot be traversed in SQL.

The best way to achieve what you want is to make a method on the Order class that returns the text that you want to be searchable.

For your example, it would be something like:

class Order < ActiveRecord::Base
  has_one :shipping_address

  multisearchable :against => [:reference_number, :overridden_names]

  def overridden_names
    "#{shipping_address.person_name_override} #{shipping_address.company_name_override}"
  end
end

To make it stay consistent, you'll need to add :touch => true to the ShippingAddress class's association so that when it is updated, the pg_search Active Record callbacks get fired on its Order as well. This will also change the updated_at on the Order, in case that's a concern for you.

class ShippingAddress < ActiveRecord::Base
  belongs_to :order, :touch => true
end

[bcackerman]

In this case I'm getting a

PG::UndefinedColumn: ERROR: column orders.overridden_names does not exist

[bcackerman]

A fix #70