Database

[{"item":"apple","properties":[{"color":"red","size":"L","status":"eatable"}]},{"item":"no-apple","properties":[{"color":"no-red","size":"L","status":"eatable"}]}]

Query

db.collection.aggregate([{$match:{"properties.color":{$in:["red","green","orange","blue"]}}},{$project:{_id:0,item:1,color:{"$arrayElemAt":["$properties.color",0]}}}])

Result