having two "or" clauses in mongoose when I need to separate the query with an and clause

Question

I want to query mongo for "unexpired or evergreen(posts with null expiration) posts created or bookmarked by me"

The problem with my query is that mongoose is combining the or statements together so that I'm incorrectly getting (unexpired or evergreen or mine or bookmarked) rather than ( (unexpired or evergreen) and (mine or bookmarked) )

How do I change the mongoose query to be the latter correct case I outlined above. Should I use an "and" clause... or perhaps I should just do a not(expiration > now) ?

var query =
      Invite.find({ isActive:true })
        .or([
          { 'expiration': {$gt: new Date()} },
          { 'expiration' : null }
        ])
        .or([
        { createdBy:userId },
        { 'bookmarked.id' : userId }
      ])

score 3 · Accepted Answer · edited Jan 07 '15 at 14:53

3

You can put both of the $or clauses into a single $and by using the Query#and helper as:

var query =
  Invite.find({ isActive:true })
    .and([
      {$or: [
        { 'expiration': {$gt: new Date()} },
        { 'expiration': null }
      ]},
      {$or: [
        { 'createdBy': userId },
        { 'bookmarked.id' : userId }
      ]}
    ])

edited Jan 07 '15 at 14:53

Christian P

12,032
6
60
71

answered Jan 05 '15 at 22:58

JohnnyHK

305,182
66
621
471

score 0 · Answer 2 · answered Jan 05 '15 at 23:02

This is where I think "helper" methods are not really helping much because they are confusing the issue. JavaScript is a dynamically typed language so you don't need these helper methods to define the data structure which makes up the query. All the native operators to MongoDB are just accepted in the single query path:

Invite.find(
    {
        "isActive": true,
        "$and": [
            { "$or": [
                { "expiration": null },
                { "expiration": { "$gt": new Date() } }
            ]},
            { "$or": [
                { "createdBy": userId }
                { "bookmarked.id": userId }
            ]}
        ]
    },
    function(err,result) {

    }
);

having two "or" clauses in mongoose when I need to separate the query with an and clause

2 Answers2