Query mongodb for conditional conditions

Question

How do i query mongo for the list of all non-private blogs along with the private blogs of currently logged-in user.

Blog(collection):
_user_id: ref(User), title: String, body: String, private: Boolean, default:false

I can get all the non-private blogs with this query:

Blog.find({_user_id: req.user}).where('private', false).exec();

But I also want to get all the blogs which are marked private only by this current logged-in user.

Is this thing even possible using single query. Do I have to rely on advance mongodb features like map-reduce / aggregate .

Yes, but I don't think that would help here cos I want both conditions. — ArrC
– ArrC, Commented Sep 7, 2014 at 19:37

JohnnyHK · Accepted Answer · 2014-09-07 20:07:18Z

1

You can use $or to include both cases in a single query:

Blog.find({$or: [
    // Non-private blogs
    {private: false},
    // Blogs of the current user
    {_user_id: req.user}
]}).exec(function(err, docs) { ... });

This will provide a union of the results of the two $or clauses.

answered Sep 7, 2014 at 20:07

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

Collectives™ on Stack Overflow

Query mongodb for conditional conditions

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