How to query in a nested array and project only the matching items from array?

Question

The structure looks like this:

{

    clientName: "client1",
    employees: [
        {
            "employeename": 1,
            "configuration": {
                "isAdmin": true,
                "isManager": false
            }
        }
        {
            "employeename": 2,
            "configuration": {
                "isAdmin": false,
                "isManager": false
            }
        }...
        
    ]
},
{
...
}

` I want to see the employees who are admins inside a specific client, given that, I have the client name. How can I write a query in MongoDB for this? I want to be able to see (project) only employees who match? Can I combine it to match multiple conditions? for example: someone who is an admin and a manager.

I have tried doing:

db.collection.find({clientName: "client1", "employees.configuration.isAdmin": true}, {"employees.employeename": 1})

This just return all the employees.

I've also tried using $elemMatch, to no avail.

Any help is appreciated.

NeNaD · Accepted Answer · 2022-12-19 07:37:16Z

1

You can do it with Aggregation framework:

$match - to filter the document based on clientName property
$filter with $eq - to filter only employees that have admins

db.collection.aggregate([
  {
    "$match": {
      "clientName": "client1"
    }
  },
  {
    "$set": {
      "employees": {
        "$filter": {
          "input": "$employees",
          "cond": {
            "$eq": [
              "$$this.configuration.isAdmin",
              true
            ]
          }
        }
      }
    }
  }
])

Working example

answered Dec 19, 2022 at 7:37

NeNaD

20.8k11 gold badges64 silver badges118 bronze badges

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

2 Comments

Husain Shaikh Over a year ago

Thank you. This works like a charm. I was wondering, is it possible to only show the employee names in the result?

NeNaD Over a year ago

Yeah, here is the updated example: mongoplayground.net/p/I6qxaSjA3cg

Collectives™ on Stack Overflow

How to query in a nested array and project only the matching items from array?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related