CODEWITHSUNDEEP
mongodbmongodb-query
podeig
podeig

Reputation: 2741

How to query element from array with two conditions (MongoDB)

I need to query all document where groupData.users.userId = 'aFHJBrKu54y5mWjY3' AND groupData.users.userId = 'pending'.

{
    "_id" : "Au2NH2iMwGfGtzqzH",
    "name" : "Toyota",
    "profileType" : "group",
    "groupData" : {
        "private" : false,
        "users" : [ 
            {
                "userId" : "9qcHtd4sRFZQpPaHD",
                "role" : "admin",
                "addedAt" : ISODate("2020-09-16T17:23:28.266Z")
            }, 
            {
                "userId" : "CnugxoBWs4ox6vG2k",
                "role" : "member",
                "addedAt" : ISODate("2020-09-16T17:23:37.292Z")
            }, 
            {
                "userId" : "aFHJBrKu54y5mWjY3",
                "role" : "pending",
                "addedAt" : ISODate("2020-09-16T17:23:41.878Z")
            }, 
            {
                "userId" : "GoXMTJKCWSpRdyn7c",
                "role" : "member",
                "addedAt" : ISODate("2020-09-16T17:23:51.281Z")
            }
        ]
    }
}

I trying the following:

            const profiles = Profiles.find({
                'groupData.users.userId': this.userId,
                'groupData.users.role': 'pending'
            }).fetch();

But it returns wrong profiles. Thank you!

Upvotes: 1

Views: 40

Answers (1)

varman
varman

Reputation: 8894

You can get with elemMatch. But you need to be aware of Positional operator in projection

db.collection.find({
  "groupData.users": {
    "$elemMatch": {
      userId: "aFHJBrKu54y5mWjY3",
      role: "pending"
    }
  }
},
{
  "groupData.users.$": 1
})

Working Mongo playground

Upvotes: 1

Related Questions