I have a database collection (named fols) like so:
{'followers':
{
'123':1
'123':2
'123':3
}
}
If I run the query (Using pymongo):
cursor = fols.find()
cursor.count()
>>3
Works fine. Now:
cursor = fols.find({'followers':{'123':1}})
cursor.count()
>>1
Again works fine. BUT if I try:
cursor = fols.find({'followers':{'123':{'$exists': True}}})
cursor.count()
>> 0
It returns 0 even though there are 3 records.
When you're not matching a complete object you need to use dot notation to use an operator against an embedded object. So in this case:
cursor = fols.find({'followers.123':{'$exists': True}})
Try the dot syntax:
cursor = fols.find({'followers.123': {'$exists': True}})
But also see my comment above. You can't have the same key more than once in a (sub-)document.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With