Find the document in mongodb that has an item at a specific index of array using python

Question

I have database like;

ObjectID(234567654rtfgjytrfgfgf){
       _id : "3456ytgfewrtyhgfd"
       Categories:{
             [0] : "Apple"
             [1] : "Mango"
       }
}
ObjectID(23dfghjthrgytrfgfgf){
       _id : "67tghjgfdrthg"
       Categories:{
             [0] : "Orange"
             [1] : "Mango"
       }
}
ObjectID(23dfghjthrgytrfgfgf){
       _id : "67tghjgfdrthg"
       Categories:{
             [0] : "Apple"
             [1] : "Mango"
       }
}

I want to find the document that has the Apple at a 0th index of category array in Mongo database document using python. I am trying in this way;

cursor = collection.find({"Categories" : "Apple"})
        for document in cursor:
            print(document)

It is printing the same result but how can I specify the index of Categories array? I am not specifying the categories index in collection.find({"Categories" : "Apple"})

thanasisp · Accepted Answer · 2017-02-23 20:16:53Z

1

to match only index 0:

cursor = collection.find({"Categories.0" : "Apple"})
for document in cursor:
    print(document)

answered Feb 23, 2017 at 20:16

thanasisp

6,0053 gold badges18 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

Find the document in mongodb that has an item at a specific index of array using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related