Database
db={activities:[{"activities":[{"activityId":"00027732FBC74DE495DA67969A42E350"},{"activityId":"5C65392E89E5468983CFEA96AC339B6E"},{"activityId":"B4F8EE62240E4633ADD237521868B588","manuelActivityInfo":{"manuelActivityTypeName":"Bilgi","manuelActivityMainSubjectId":4,"manuelActivityMainSubjectName":"Diğer","manuelActivityDetailSubjectId":15,"manuelActivityDetailSubjectName":"Genel bilgi aktarımı"}},{"activityId":"EA749325AB2742CCB2B3B04D2BFB6C24"},{"activityId":"FB744C79FFDF480C94069DF0F602C0AC","manuelActivityInfo":{"manuelActivityTypeName":"Bilgi","manuelActivityMainSubjectId":14,"manuelActivityMainSubjectName":"Tazminat","manuelActivityDetailSubjectId":60,"manuelActivityDetailSubjectName":"Genel bilgi aktarımı"}},{"activityId":"27B18A5C9ABA42A6B8AA0887C6916A25"}]},{"activities":[{"activityId":"C7D057D21F1F4356BD4D450ADA803FDA"},{"activityId":"8CBAF1D282F643F78A11B6AC30D83F91","manuelActivityInfo":{"manuelActivityTypeName":"Gelir","manuelActivityMainSubjectId":16,"manuelActivityMainSubjectName":"KPA","manuelActivityDetailSubjectId":68,"manuelActivityDetailSubjectName":"Katkı Payı Artış"}},{"activityId":"F661F629EB92403A86C8760F2140F5D6"},{"activityId":"AA42800E55C84E7AB33526CD8E0336F1"}]},{"activities":[{"activityId":"C7D057D21F1F4356BD4D450ADA803FDA"},{"activityId":"AA42800E55C84E7AB33526CD8E0336F1"}]}]}
Query
db.activities.aggregate([{"$match":{"activities.manuelActivityInfo":{$exists:true,},}},{$project:{_id:null,activities:{$filter:{input:"$activities",cond:{$ne:["$$this.manuelActivityInfo",undefined]}}}}},])