Excluding a subdocument

Working with Data
1

MongoDB version 3.1.13

excluding a subdocument not working .

db.collections.find({“name”:“riya”},{“address”:0})

db.collections.find({“name”:“riya”},{“address.$”:0})

I tried both but it is not excluding the subdocument

2

Hi @Gayathri_S,

The regular projection will not exclude specific arrays elements.

You Will need an aggregation with $filter projection:
https://docs.mongodb.com/manual/reference/operator/aggregation/filter/

Additionally, I am not sure why you are using a development version 3.1.13 and not a general available 3.6 - 4.4 versions.

Best
Pavel