Logical OR MongoDB NodeJS Query

Question

How does one implement a logical OR on the same JSON field when querying Mongo from NodeJS?

In particular, I have the following line:

collection.find({"user":req.user.email, "parent._id":0}, function(err, activities){
    if (err) throw err;
    res.json(activities);
});

How could I properly include entries such that "parent":{} is also allowed?

The following gives me an empty array:

collection.find({"user":req.user.email, "parent":{}, "parent._id":0}, function(err, activities){
        if (err) throw err;
        res.json(activities);
    });

MadPhysicist · Accepted Answer · 2016-07-08 19:40:43Z

0

Working code:

collection.find({"user":req.user.email, $or:[{"parent._id":0},{"parent":{}}]}, function(err, activities){
        if (err) throw err;
        res.json(activities);
});

answered Jul 8, 2016 at 19:40

MadPhysicist

5,89113 gold badges51 silver badges121 bronze badges

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

Collectives™ on Stack Overflow

Logical OR MongoDB NodeJS Query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related