Database

[{"item":"journal","qty":25,"status":"A","products":[{"key":"item-one","name":"item one","tags":["a","b"]},{"key":"item-two","name":"item-two","tags":["a","c","d"]},{"_id":3,"name":"item-three","tags":["g"]}]},{"item":"notebook","qty":50,"status":"b","products":[{"key":"item-four","name":"item four","tags":["a","o"]},{"key":"item-five","name":"item-five","tags":["s","a","d"]}]}]

Query

db.collection.find({"products.tags":"a"},{item:1,qty:1,status:1,products:{$filter:{input:"$products",cond:{$in:["a","$$this.tags"]}}}})

Result