Database
[{"_id":ObjectId("620ca4e292a990273446cf7b"),"data":[{"flagging":"BUSINESS","information":[{"room":1,"status":"AVAILABLE"},{"room":2,"status":"BUSY"}]},{"flagging":"PRIVATE","information":[{"room":1,"status":"AVAILABLE"},{"room":2,"status":"CLEANING"}]},{"flagging":"PUBLIC","information":[{"room":1,"status":"SERVICE"},{"room":2,"status":"AVAILABLE"}]}],"createdAt":"2022-02-16T07:16:50.674Z"}]
Query
db.collection.aggregate([{$match:{"data.flagging":{$in:["BUSINESS","PUBLIC"]}}},{$project:{_id:0,data:{"$filter":{"input":"$data","cond":{$in:["$$this.flagging",["BUSINESS","PUBLIC"]]}}}}}])