find elements in array available with mongodb

Question

exp my collection users

[
    {
        _id: ObjectId('123456')
        username: 'test'
    },
    {
        _id: ObjectId('654321')
        username: 'test2'
    },
    {
        _id: ObjectId('789101')
        username: 'test3'
    }
]

my array available :

var usersId = [ObjectId('123456'), ObjectId('654321')]

i want find with field username and just in array usersId available

my test not working :

db.users.find({ 
  username: keyword,
  _id: { $in: usersId  }
})

Please check this answers https://stackoverflow.com/questions/8303900/mongodb-mongoose-findmany-find-all-documents-with-ids-listed-in-array — zishe, Dec 02 '19 at 04:47

score 0 · Accepted Answer · answered Dec 02 '19 at 05:01

0

You can try something like the below code.

db.users.find({ 
  username: keyword,
  _id: { $in: [usersId] }
})

answered Dec 02 '19 at 05:01

Pushprajsinh Chudasama

7,772
4
20
43

find elements in array available with mongodb

1 Answers1