How to fetch nested array list from mongo?

Question

    {
    "_id" : "575",
    "_class" : "com.spyne.sharing.SpyneShareUserProject",
    "spyneSharePhotoList" : [ 
        {
            "_id" : "fxLO68XyMR",
            "spyneShareUsers" : [ 
                {
                    "_id" : "chittaranjan@eventila.com",
                    "selectedByClient" : false
                }, 
                {
                    "_id" : "chittaranjan@gmail.com",
                    "selectedByClient" : false
                }
            ]
        }, 
        {
            "_id" : "nVpD0KoQAI",
            "spyneShareUsers" : [ 
                {
                    "_id" : "chittaranjan@eventila.com",
                    "selectedByClient" : true
                }
            ]
        }, 
        {
            "_id" : "Pm0B3Q9Igv",
            "spyneShareUsers" : [ 
                {
                    "_id" : "chittaranjan@gmail.com",
                    "selectedByClient" : true
                }
            ]
        }
    ]
}

From this document I want to fetch spyneShareUsers list.

Can some one please help me with it,

top id = 575
inner id = fxLO68XyMR

I want the list of objects that content email id and a boolean value.

Please help me to get the data.

score 1 · Accepted Answer · answered Feb 11 '20 at 10:09

1

Using Mongo aggregation pipeline you can collect the document data as you want. Try this:

db.collection.aggregate([
  {
    $unwind: {
      path: "$spyneSharePhotoList"
    }
  },
  {
    $match: {
      _id: "575",
      "spyneSharePhotoList._id": "fxLO68XyMR"
    }
  },
  {
    $project: {
      _id: 1,
      spyneShareUsers: "$spyneSharePhotoList.spyneShareUsers"
    }
  }
])

answered Feb 11 '20 at 10:09

Mayuri S Kulkarni

771
5
17

i am getting ** Fetched 0 record(s) in 0ms ** – Mr Freak Feb 11 '20 at 10:22
Have you replaced your collection name here: db.`collection`.aggregate() – Mayuri S Kulkarni Feb 11 '20 at 10:31
ok thanks, i did the mistake that you have mentioned. can you please look into this problem https://stackoverflow.com/questions/60182047/upsert-in-nested-array-of-mongo-db – Mr Freak Feb 12 '20 at 06:03

How to fetch nested array list from mongo?

1 Answers1