Multiple LIKE matches with Arel & MetaWhere

Question

I'm transitioning an application written in Rails-2.3 with SearchLogic to Rails-3.0 with Arel and MetaWhere, and I'm running into an operation that I don't know how the write.

The old code was:

if params[:city] && params[:city].respond_to?(:each)
  users = users.person_address_city_like_any(params[:city])
end

what this did was run a LIKE match against each item in the params[:city] array.

This is easy enough in MetaWhere when there's only one search term:

users = users.where(:person => { :address => { :city.matches => '%city1%' } })

but how would I write this with an arbitrary number of cities?

score 5 · Accepted Answer · answered Nov 30 '10 at 12:54

5

Try:

users = users.where(:person => { :address => { :city.matches_any => ['%city1%','%city2%'] } })

answered Nov 30 '10 at 12:54

Ernie

896
5
7

Thanks. I'm very impressed with MetaWhere so far. – Adam Lassek Nov 30 '10 at 23:08
how can I do that very same thing when the conditions come from a string: "person.address.city"? – Apr 23 '11 at 02:41

Multiple LIKE matches with Arel & MetaWhere

1 Answers1