MongoDB query to retrieve all matching ids from array

Question

I would like to retrieve documents from the DB that match a manager Id and employee ids which comes in an array.

SELECT * FROM XXX WHERE MANAGER_ID=<manager_id> AND EMPLOYEE_ID IN [....]

Here my code:

var query = [
    {             
        "$and": [ 
            {"employee": { $in : employees}}, 
            {"manager": ObjectId(managerId)}
        ]
    }
];

But in actuality, the query returns all documents in the model. Please advise.

I think problem is with array []... It should be var query = { "$and": [ {"employee": { $in : employees}}, {"manager": ObjectId(managerId)} ] } — Ashh
– Ashh, Commented Aug 10, 2018 at 6:58

Ashh · Accepted Answer · 2018-08-19 10:07:03Z

2

In find query first parameter should be an object not an array

var query = {
  "$and": [
    { "employee": { $in : employees }},
    { "manager": ObjectId(managerId) }
  ]
}

db.collection.find(query)

edited Aug 19, 2018 at 10:07

answered Aug 10, 2018 at 7:11

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Comments

Janen R · Accepted Answer · 2018-08-10 07:09:04Z

0

use elemMatch to get matching the array's one or more keys

   ArrayFieldName: {
                "$elemMatch": {
                    "employee": {
                        $in: employees
                    },
                    "manager": ObjectId(managerId)
                }
     }

answered Aug 10, 2018 at 7:09

Janen R

7491 gold badge11 silver badges21 bronze badges

Collectives™ on Stack Overflow

MongoDB query to retrieve all matching ids from array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related