Mongoid: array contains any values of another array

Question

I have a Map object with a 'cities' array field

class Map
  include Mongoid::Document
  field :cities, type: Array
end

I want to search for all the Map where at least one city is present from an other array. Something like this:

# map1.cities = ['London', 'Manchester']
# map2.cities = ['Paris', 'Lyon']
# map3.cities = ['Berlin', 'Munich']
# searchedCities = ['London', 'Paris']

I want all the maps that contains at least one of the searchedCities, in this case; map1 and map2.

This is not working, because it compares the whole array

Map.where(cities: searchedCities)

any ideas ?

That's works great. Thanks a lot. I've probably missed that query in the documentation. — Dainii
– Dainii, Commented Aug 3, 2018 at 6:41

Jagdeep Singh · Accepted Answer · 2018-08-03 06:53:37Z

2

You can use .any_in (can't find a direct documentation) which generates a $in mongodb query for you and it matches the document if the field contains any of the values from given array.

In your case:

Map.any_in(cities: searched_cities)
 => #<Mongoid::Criteria
  selector: {"cities"=>{"$in"=>["London", "Paris"]}}
  ...
  class:    Map>

answered Aug 3, 2018 at 6:53

Jagdeep Singh

4,9202 gold badges19 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mongoid: array contains any values of another array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related