find elements in array available with mongodb [duplicate]

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 stackoverflow.com/questions/8303900/… — Alexander Kireyev
– Alexander Kireyev, Commented Dec 2, 2019 at 4:47

Pushprajsinh Chudasama · Accepted Answer · 2019-12-02 05:01:27Z

0

You can try something like the below code.

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

answered Dec 2, 2019 at 5:01

Pushprajsinh Chudasama

7,9894 gold badges23 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

find elements in array available with mongodb [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related