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.

1
17
8/22/2012 1:32:29 AM

Accepted Answer

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

46
3/15/2014 5:48:00 AM

Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow
Icon