How to query items in mongodb with a particular dictionary including at least one non zero value?

Question

Suppose I have the following item structure:

"_id": "12325523623453254",
  "blas": {
    "blaA": 0,
    "blaB": 0,
    "blaC": 0,
    "blaD": 1,
  }
}

I like to find the items with "blas" including at least one non zero value.

are blaA, blaB, blaC, blaD fixed attributes of blas?? or it can have any number of attributes? — Rahul, Mar 29 '16 at 13:17
Then it is a case of $or operator as shown in JohnnyHK's answer — Rahul, Mar 31 '16 at 08:05

score 0 · Answer 1 · answered Mar 29 '16 at 16:22

0

You can do this with an $or query that uses dot notation in the keys to access the fields within blas:

db.test.find({$or: [
    {'blas.blaA': {$ne: 0}},
    {'blas.blaB': {$ne: 0}},
    {'blas.blaC': {$ne: 0}},
    {'blas.blaD': {$ne: 0}}
]})

answered Mar 29 '16 at 16:22

JohnnyHK

1 Answers1