[{"level_1":"A","cols":["A","B"],"arno":"DC","table":[{country:"NO",population:400,color:"red"},{country:"AE",population:100,color:"red"},{country:"OT",population:200,color:"blue"},{country:"AU",population:200,color:"red",alo:"n"},]},{"level_1":"A","cols":["A","B"],"arno":"CD","table":[{country:"NO",population:200,color:"blue","Supplier Manager":"['Arnold Khan']"},{country:"AE",population:200,color:"red","Supplier Manager":"[]"},{country:"AE",population:200,color:"green","Supplier Manager":"['Arnold Khan']"},{country:"OT",population:200,color:"blue","Supplier Manager":"['Adam Nor', 'Jim Brown']"},]},{"level_1":"B","cols":["A","B"],"arno":"CD","table":[{country:"AL",population:400,color:"red",alo:"y"},{country:"AR",population:100,color:"green",alo:"y"},{country:"YU",population:200,color:"red",alo:"y"},{country:"AX",population:200,color:"red",alo:"n"},]}]

db.collection.aggregate([{$match:{"$and":[{"level_1":"A"},{"arno":"CD"}]}},{"$addFields":{"table":{"$filter":{"input":"$table","as":"t","cond":{"$and":[{"$or":[{"$eq":["$$t.color","blue"]},{"$eq":["$$t.color","red"]}]},{"$eq":["$$t.population",200]},{"$or":[{"$regexMatch":{"input":"$$t.Supplier Manager","regex":"Jim Brown","options":"i"}},{"$regexMatch":{"input":"$$t.Supplier Manager","regex":"Arnold Khan","options":"i"}},]}]}}}}},{$set:{color:{$setUnion:"$table.color"},country:{$setUnion:"$table.country"},population:{$setUnion:"$table.population"}}}])