Answers for "mongodb lookup on array of objects"

search inside array with object mongodb

db.users.find({awards: {$elemMatch: {award:'National Medal', year:1975}}})

lookup in mongodb array

> db.demo396.aggregate([
...    { "$lookup": {
...       "from": "demo395",
...       "let": { "details": "$details" },
...       "pipeline": [
...          { "$match": { "$expr": { "$in": [ "$_id", "$$details" ] } } }
...       ],
...       "as": "output"
...    }}
... ])

find object in array mongodb

db.users.findOne({"_id": id},{awards: {$elemMatch: {award:'Turing Award', year:1977}}})