[{"_id":{"$oid":"63110728d74738cdc48a7de0"},"listName":"list_name","alloweUidList":[{"uid":"prQUKkIxljVqbHlCKah7T1Rh7l22","role":"creator","boolId":1,"crDate":"2022-09-01 21:25","modDate":null}],"offerModelList":[{"offerListenerEntity":{"_id":"6311072ed74738cdc48a7de1","uid":"prQUKkIxljVqbHlCKah7T1Rh7l22","itemName":"sometehing","crDate":"2022-09-01 21:25","boolId":1,"modDate":null,"imageColorIndex":3,"shoppingListId":"63110728d74738cdc48a7de0","checkFlag":0,"itemCount":1},"offers":[{"id":"62fa7983b7f32cc089864a3b","itemId":127382,"itemName":"item_1","itemCleanName":"item_clean_name","imageUrl":"item.png","price":10,"measure":"measure","salesStart":"N.a","source":"source","runDate":"2022.08.15-14:11:15","shopName":"shop_name","isSales":1,"insertType":"automate","timeKey":"2022_08_15_18_51","imageColorIndex":0,"isSelectedFlag":1,"selectedBy":"not_selected","itemCount":1},{"id":"62fa7983b7f32cc089864a3b","itemId":127382,"itemName":"item_2","itemCleanName":"item_clean_name","imageUrl":"image.png","price":20,"measure":"measure","salesStart":"N.a","source":"source","runDate":"2022.08.15-14:11:15","shopName":"shop_name","isSales":1,"insertType":"automate","timeKey":"2022_08_15_18_51","imageColorIndex":0,"isSelectedFlag":0,"selectedBy":"not_selected","itemCount":1}]},{"offerListenerEntity":{"_id":"6311a5c0d74738cdc48a7de2","uid":"prQUKkIxljVqbHlCKah7T1Rh7l22","itemName":"anything","crDate":"2022-09-02 08:42","boolId":1,"modDate":null,"imageColorIndex":1,"shoppingListId":"63110728d74738cdc48a7de0","checkFlag":0,"itemCount":2},"offers":[]}],"crDate":"2022-09-01 21:25","modDate":"2022-09-01 21:25","boolId":1,"imageColorIndex":1}]

db.collection.aggregate([{"$match":{"alloweUidList":{"$elemMatch":{"uid":"prQUKkIxljVqbHlCKah7T1Rh7l22","boolId":1}},"boolId":1,}},{"$addFields":{"offerModelList":{"$filter":{"input":"$offerModelList","as":"i","cond":{"$eq":["$$i.offerListenerEntity.boolId",1]}}}},},{"$set":{"offerModelList":{$map:{input:"$offerModelList",as:"offerModel",in:{$mergeObjects:["$$offerModel",{offers:{$filter:{input:"$$offerModel.offers",as:"x",cond:{$eq:["$$x.isSelectedFlag",1]}}}}]}}}}}])