mongodb search inside array code example

Example 1: search inside array with object mongodb

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

Example 2: lookup in mongodb array

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

Example 3: mongodb find array with element

// Finds all documents that have a property named "tags"
// which has at least one array element matching "red"
db.inventory.find( { tags: "red" } )

Example 4: how to get array object value in mongodb

db.test.aggregate([
    {$match: {'shapes.color': 'red'}},
    {$project: {
        shapes: {$filter: {
            input: '$shapes',
            as: 'shape',
            cond: {$eq: ['$$shape.color', 'red']}
        }},
        _id: 0
    }}
])

Example 5: find string element in an array mongodb

db.articles.find({
    "stock.country" : "01",
    "stock.warehouse.code" : "02"
}).pretty();