mongodb: how to write below query string

Question

I want to select all the records that meet below criteria:

if "used1" not in record or record["used1"] != True

How to write this? Thanks.

mu is too short · Accepted Answer · 2012-07-08 05:23:49Z

3

You'd use $exists for the first:

db.collection.find({ used1: { $exists: false } })

and $ne for the second:

db.collection.find({ used1: { $ne: true } })

To combine them, use $or:

db.collection.find({
    $or: [
        { used1: { $exists: false } },
        { used1: { $ne:     true  } }
    ]
 })

answered Jul 8, 2012 at 5:23

mu is too short

436k71 gold badges863 silver badges822 bronze badges

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

1 Answer 1