nested queries in pymongo using collection.find()

Question

I would like to create a data base using mongodb and I am wondering how to query nested entities. For instance, let's assume we create a db as follows:

from pymongo import MongoClient
db = client['test_database']
collection = db['test_collection']
dat=[  
 { "id":110, "data":{"Country":"ES","Count":64}},
 { "id":112, "data":{"Country":"ES","Count":5}},
 { "id":114, "data":{"Country":"UK","Count":3}}
]
collection.insert(dat)

how can we query the records with "Country" values "ES"? Or alternatively how can we query the records with "Count" less than 6?

Community · Accepted Answer · 2017-05-23 11:53:40Z

19

You can use the dot notation supported by mongo.

db.test_collection.find({"data.Country": "ES"})
db.test_collection.find({"data.Count": {"$lt": 6}})

Check this stackoverflow question for the non-Python version.

edited May 23, 2017 at 11:53

CommunityBot

11 silver badge

answered Aug 29, 2013 at 15:49

PattimusPrime

8659 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

nested queries in pymongo using collection.find()

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related