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

Question

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!

See documentation topic: Query an Array of Embedded Documents - Specify Multiple Conditions for Array of Documents — prasad_
– prasad_, Commented Sep 17, 2020 at 1:09

varman · Accepted Answer · 2020-09-17 03:58:06Z

1

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

answered Sep 17, 2020 at 3:58

varman

8,9226 gold badges25 silver badges56 bronze badges

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

2 Comments

varman Over a year ago

@podeig you are welcome.. Why don't you consider to accept the answer which helps to people who seek this kind of problems

podeig Over a year ago

I am so sorry, Varman. I upvoted it but forgot to accept. Sorry :)

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related