How Do I compare non-array field with array in mongodb?

Question

I have following documents

 users = [
      { name: 'kiran', age: 22, location: 'pune' },
      { name: 'rahul', age: 23, location: 'mumbai' },
      { name: 'amit', age: 25, location: 'nashik' },
      { name: 'abhijeet', age: 26, location: 'pune' }
    ]

I have to find users based on multiple locations, So I have input array locations = ["pune", "nashik"]. It should result in three documents except one whose name is rahul because input array doesn't match his location.

output = [
      { name: 'kiran', age: 22, location: 'pune' },
      { name: 'amit', age: 25, location: 'nashik' },
      { name: 'abhijeet', age: 26, location: 'pune' }
    ]

So how can I achieve this with MongoDB.

thanks for any help.

Valijon · Accepted Answer · 2019-12-07 13:30:35Z

1

You can use $in operator.
If users are stored as sub-document, use this approach.

db.users.find({
  location: {
    $in: [
      "pune",
      "nashik"
    ]
  }
})

db.users.aggregate([
  {
    $match: {
      location: {
        $in: [
          "pune",
          "nashik"
        ]
      }
    }
  }
])

MongoPlayground

EDIT: Nodejs code

let query     = [];
let locations = ['pune', 'nashik'];
query.push({
    '$match': { 'location': { '$in': locations } }                
});
const output = await Users.aggregate(query);

edited Dec 7, 2019 at 13:30

answered Dec 7, 2019 at 13:12

Valijon

13.2k4 gold badges40 silver badges74 bronze badges

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

1 Comment

mustafa shaikh Over a year ago

it works fine. but when I do the same thing with aggregate query it gives MongoError: $in needs an array Error

Collectives™ on Stack Overflow

How Do I compare non-array field with array in mongodb?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related