mongodb search in 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: mongodb array field contains
db.inventory.find( { tags: { $all: ["red", "blank"] } } )
Example 5: lookup in mongodb array
{ "_id" : ObjectId("5e5e787817aa3ef9ab8ab209"), "details" : [ ObjectId("5e5e782317aa3ef9ab8ab207"), ObjectId("5e5e782317aa3ef9ab8ab208") ], "output" : [ { "_id" : ObjectId("5e5e782317aa3ef9ab8ab207"), "Name" : "Chris" }, { "_id" : ObjectId("5e5e782317aa3ef9ab8ab208"), "Name" : "David" } ] }
Example 6: mongo array
db.inventory.find( { tags: ["red", "blank"] } )