Mongo DB query on multiple conditions

Question

I am trying to do a simple query based on two conditions in MongoDB using pymongo.

I am using the sample restaurants data set from the tutorial documentation. I have:

from pymongo import MongoClient
import pymongo
import pandas as pd

client = MongoClient()

db = client.test

cursor = db.restaurants.find({"$and":[{'borough':"Manhattan"},{"grades":{'grade':"A"}}]}

for record in cursor:
    print record

I am just trying to print all the restaurants in Manhattan with a grade of 'B.' But this pulls back no results. I have also tried

cursor = db.restaurants.find({"borough":"Manhattan", "grades.grade":"B"})

but this will only filter by the first condition and won't filter by the "grade." It's exactly how it is laid out in the documentation but I can't get it to work.

Can you edit your question to include an example doc you're expecting to find? — JohnnyHK
– JohnnyHK, Commented Sep 28, 2015 at 21:31

alecxe · Accepted Answer · 2015-09-28 22:22:40Z

7

The problem is in the second condition. grades is a subarray of grades, use $elemMatch:

db.restaurants.find({"$and": [{"borough": "Manhattan"}, {"grades": {"$elemMatch": {"grade": "A"}}}]})

Works for me.

answered Sep 28, 2015 at 22:22

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

1 Comment

user2907249 Over a year ago

No dice. still pulls back all the grades.

mrb · Accepted Answer · 2021-01-23 14:48:42Z

2

I had a similar issue and it worked for me with the following syntax:

result = db.mycollection.find({"$and": [{"key1": value1}, {"key2": value2}]})

I have multiple records with the same value under key1, but I want the only one with specific value on key2. It seems to work for me.

answered Jan 23, 2021 at 14:48

mrb

418 bronze badges

Collectives™ on Stack Overflow

Mongo DB query on multiple conditions

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related