How exclude nested array element of projection in mongodb

Question

This is my collection structure.

{
 "_id" : ObjectId("5685ea32ba5298688d27cceb"),
 "name" : "t1",
 "array" : [ 
     {
         "name" : "n1",
         "innerArray1" : [ 
             {
                 "id" : 1,
                 "name" : "aaa"
             }, 
             {
                 "id" : 2,
                 "name" : "bbb"
             }
         ],
         "innerArray2" : [ 
             {
                 "id" : 1,
                 "name" : "cccc",
                 "active" : true
             }, 
             {
                 "id" : 2,
                 "name" : "dddd",
                 "active" : false
             }
         ]
     }
 ]}

after find().i want to get only innerArray2. I tried like this

db.getCollection('Test').find({"name":"t1","array.name":"n1"},{"array.$":1})

{
"_id" : ObjectId("5685ea32ba5298688d27cceb"),
"array" : [ 
    {
        "name" : "n1",
        "innerArray1" : [ 
            {
                "id" : 1,
                "name" : "aaa"
            }, 
            {
                "id" : 2,
                "name" : "bbb"
            }
        ],
        "innerArray2" : [ 
            {
                "id" : 1,
                "name" : "cccc",
                "active" : true
            }, 
            {
                "id" : 2,
                "name" : "dddd",
                "active" : false
            }
        ]
    }
]

}

but actually i want to remove innerArray1 element from the result.this is my expectation.

{
"_id" : ObjectId("5685ea32ba5298688d27cceb"),
"array" : [ 
    {
        "name" : "n1",
        "innerArray2" : [ 
            {
                "id" : 1,
                "name" : "cccc",
                "active" : true
            }, 
            {
                "id" : 2,
                "name" : "dddd",
                "active" : false
            }
        ]
    }
]}

how can I do this ?

Possible duplicate of Retrieve only the queried element in an object array in MongoDB collection — Sede
– Sede, Commented Jan 1, 2016 at 11:55
thanks.this reference give the solution.needs to doing filtering part also inside the projection — Tharanga
– Tharanga, Commented Jan 1, 2016 at 14:25

Bijal · Accepted Answer · 2016-01-01 04:22:38Z

1

I think Instead of using db.getCollection('Test').find() you can use db.getCollection('Test').findOne('innerArray2').

answered Jan 1, 2016 at 4:22

Bijal

1321 silver badge8 bronze badges

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

1 Comment

Tharanga Over a year ago

thanks.but it return all the elements in the array.but i only want "array.name":"n1" this element

Collectives™ on Stack Overflow

How exclude nested array element of projection in mongodb

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related