Get matching objects in an object Array from mongodb collections?

Question

The below is the collection named testing which i am working on and I need to get all the persons who is having the DOB of "24-04-1973"

 {
        "year": "1973",
        "allPersons": [
            {
                "name": "First guy",
                "DOB": "24-04-1973"
            },
            {
                "name" : "Second guy",
                "DOB":  "02-12-1973"
            }     
            {
                "name": "Third guy",
                "DOB": "13-01-1973"
            },
            {
                "name": "Fourth guy",
                "DOB": "24-04-1973"
            },
            {
                "name": "Fifth guy",
                "DOB": "24-04-1973"
            },
        ]
    }

But I am only able to get the first object from the allPersons Array through the below query

 db.testing.find(
       {
              "allPersons.DOB":"24-04-1973"
       },
       {
              _id:0,"allPersons":
              {
                     $elemMatch:
                     {
                            "DOB":'24-04-1973'
                     }
              }
       }
).pretty();

Result of above Query

{
        "allPersons" : [
                {
                        "name" : "First guy",
                        "DOB" : "24-04-1973"
                }
        ]
}

But the result i am expecting to get is to have all the persons who have the DOB of "24-04-1973" like below

  {
            "allPersons" : [
                    {
                            "name" : "First guy",
                            "DOB" : "24-04-1973"
                    },
                    {        
                            "name" : "Fourth guy",
                            "DOB" : "24-04-1973"
                    },
                    {
                            "name" : "Fifth guy",
                            "DOB" : "24-04-1973"
                    }
            ]
    }

Does anybody know the correct query to generate the above kind of result

mongo Db version 2.6.11

I am new to this, Excuse if it's silly

Please mention your MongoDB version? Is it 3.2?

Saleem
– Saleem

2016-03-18 15:26:33 +00:00
Commented Mar 18, 2016 at 15:26 — Saleem
– Saleem, Commented Mar 18, 2016 at 15:26
mongo db version 2.6.11

Siva Kannan
– Siva Kannan

2016-03-18 15:35:55 +00:00
Commented Mar 18, 2016 at 15:35 — Siva Kannan
– Siva Kannan, Commented Mar 18, 2016 at 15:35
See my post below.

Saleem
– Saleem

2016-03-18 15:50:22 +00:00
Commented Mar 18, 2016 at 15:50 — Saleem
– Saleem, Commented Mar 18, 2016 at 15:50

Saleem · Accepted Answer · 2016-03-18 15:49:54Z

2

Try following script:

db.doc.aggregate([
    {$unwind:"$allPersons"},
    {$match:{"allPersons.DOB":"24-04-1973"}},
    {$group:{_id:{id:"$_id", year:"$year"}, allPersons:{$push:"$allPersons"}}},
    {$project:{_id:0, allPersons:1}}  
])

It will emit:

{ 
    "allPersons" : [
        {
            "name" : "First guy", 
            "DOB" : "24-04-1973"
        }, 
        {
            "name" : "Fourth guy", 
            "DOB" : "24-04-1973"
        }, 
        {
            "name" : "Fifth guy", 
            "DOB" : "24-04-1973"
        }
    ]
}

answered Mar 18, 2016 at 15:49

Saleem

9,0582 gold badges22 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Get matching objects in an object Array from mongodb collections?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related