Database

[{"_id":"61f7d5cfd0c32b744d3f81c2","_form":"61e66b8fd0c32b744d3e24a0","_workflow":"61e54fe2d0c32b744d3e0b7c","_appUser":"61e6b098d0c32b744d3e3808","sectionResponse":[{"_id":"61f7d5cfd0c32b744d3f81c3","name":"Project Details & Goals","order":2,"fieldResponse":[{"_id":"61f7d5cfd0c32b744d3f81c4","fieldType":"Text","name":"Project Name","value":"TRT","order":0},{"_id":"61f7d5cfd0c32b744d3f81c5","fieldType":"Number","name":"Amount Requested","value":"20","order":1},{"_id":"61f7d5cfd0c32b744d3f81c6","fieldType":"Number","name":"Project Cost","value":"50","order":1},{"_id":"61f7d5cfd0c32b744d3f81c7","fieldType":"Comment","name":"Project Goals","value":"TRT","order":3},{"_id":"61f7d5cfd0c32b744d3f81c8","fieldType":"Number","name":"Amount Requested","value":"25","order":1},]},{"_id":"61f7d5cfd0c32b744d3f81c8","name":"Section Heading","order":2,"fieldResponse":[{"_id":"61f7d5cfd0c32b744d3f81c9","fieldType":"Multiselectdropdown","name":"Multiselectdropdown","value":"Y","order":0},{"_id":"61f7d5cfd0c32b744d3f81ca","fieldType":"Image_Upload","name":"Image Upload","value":"Y","order":1}]}],"order":2,"status":"Reviewed","updatedAt":"2022-01-31T12:27:59.541Z","createdAt":"2022-01-31T12:27:59.541Z","__v":0}]

Query

db.collection.aggregate([{$match:{"sectionResponse.fieldResponse.name":"Amount Requested"}},{"$project":{"sectionResponse":{"$filter":{"input":{"$map":{"input":"$sectionResponse","as":"somesub","in":{"_id":"$$somesub._id","fieldResponse":{"$filter":{"input":"$$somesub.fieldResponse","as":"sub","cond":{"$eq":["$$sub.name","Amount Requested"]}}}}}},"as":"some","cond":{"$gt":[{"$size":"$$some.fieldResponse"},0]}}}}},{$unwind:"$sectionResponse"},{$unwind:"$sectionResponse.fieldResponse"},{$project:{value:"$sectionResponse.fieldResponse.value",_id:0}}])

Result