Pymongo, query on list field, and/or

Question

I have a collection with some documents like:

{     _id: 5,     vals: [100, 1100, 1500] }, {     _id: 10,     vals: [1100, 1700] } 

How can I query for documents that have, in vals field:

• 1100
• 1700 OR 100
• 100 AND 1100

I can use some comprehension magic like:

g = lambda codes: (     d for d in collection.find() if any(code in d["vals"] for code in codes) ) g([100, 1700]).next() 

Or, for the AND:

g = lambda codes: (     d for d in collection.find() if all(code in d["vals"] for code in codes) ) g([100, 1100]).next() 

This seems a little clunky though if there is some find magic that can be done with the driver.

Answer 1

yourmongocoll.find({"vals":1100}) yourmongocoll.find({"$or":[ {"vals":1700}, {"vals":100}]}) yourmongocoll.find({"$and":[ {"vals":100}, {"vals":1100}]}) 

i would recommend reading Mongodb Advanced queries

you will also find $in ...useful