Database

[{parentId:1,"name":[{"language":"en-US","text":"Book"},{"language":"fr-CA","text":"livre"}],isActive:true/** and so many other fields*/},{parentId:1,"name":[{"language":"en-US","text":"Pen"}],isActive:true/** and so many other fields*/}]

Query

db.collection.aggregate([{"$match":{"parentId":1}},{"$unwind":"$name"},{"$match":{"name.language":"fr-CA"}},{"$addFields":{"name":"$name.text"}}])

Result