rails searchlogic plugin search in multiple columns

Question

I have a form to a search engine. I want to search for the searchterm in all fields of a specific model.

I'm using the searchlogic plugin. It gives me a lot of new finders but i cannot do a OR between two fields.

for example:

How can i do a "SELECT * from my_table WHERE field1 LIKE '%xpto%' OR field2 LIKE '%xpto%' ?

Specially in the form parameter that will be passed to my controller, if you know searchlogic you know what i'm speaking about, i'm trying to pass something like: field1_or_field2_like("xpto") but it dont works. Any idea?

Answer 1

Uhm... I don't think Searchlogic offers such functionality by default. But why not write the named_scope yourself?

class MyModel
  named_scope :field1_or_field2_like lambda { |*args| {:conditions => ["field1 LIKE '%?%' OR field2 LIKE '%?%'", args.first, args.first]} }
end

Answer 2

Based on this post from the plugin's author there is not intended to be support for this, although as Jongsma indicated you can implement it with your own named_scope.