Set condition in MongoDB nested document?

MongoDBDatabaseBig Data Analytics

Let’s say we need to find a document with a value greater than specific value. For this, use dot notation in nested document and set the condition with $gt.

Let us see an example and create a collection with documents −

> db.demo688.insert(
... {
... information:{id:1,details:[
...    {otherDetails:{
...       values:75
...       }
...    }
... ]
... }
... }
... )
WriteResult({ "nInserted" : 1 })
> db.demo688.insert({
... information:
... {
... id:2,
... details:
... [
...    {otherDetails:{
...       values:78
...    }
... }
... ]
... }
... }
... )
WriteResult({ "nInserted" : 1 })

Display all documents from a collection with the help of find() method −

> db.demo688.find();

This will produce the following output −

{ "_id" : ObjectId("5ea57986a7e81adc6a0b3965"), "information" : { "id" : 1, "details" : [ { "otherDetails" : { "values" : 75 } } ] } }
{ "_id" : ObjectId("5ea5799ca7e81adc6a0b3966"), "information" : { "id" : 2, "details" : [ { "otherDetails" : { "values" : 78 } } ] } }

Following is the query to access MongoDB nested document −

> db.demo688.find({"information.details.otherDetails.values":{$gt:75}});

This will produce the following output −

{ "_id" : ObjectId("5ea5799ca7e81adc6a0b3966"), "information" : { "id" : 2, "details" : [ { "otherDetails" : { "values" : 78 } } ] } }
raja
Published on 14-May-2020 09:03:38
Advertisements