Mongoose or operator with Date

Question

I am trying to write a query like:

var query = {
    userId: req.params.userId,
    isActive: true,
    'interval.start': {
        $lte: now
    },
    'interval.end': {
        $or: [
            { $gte: now },
            { $exists: false },
            { $eq: null } 
        ]
    }
};

What I am trying to achieve is I want to find columns that should fit to these conditions:

• interval.end Date should be greater than now.
• OR end date shouldn't exist
• OR it should exist to null.

I am getting: Can't use $or with Date. error.

Thank you.

Answer 1

As far as I know you can't nest $or inside some specific field. The $or operator takes an array of expressions.

Try the following query:

var query = {
    userId: req.params.userId,
    isActive: true,
    'interval.start': {
        $lte: now
    },
    $or: [
        {'interval.end': {$gte: now} },
        {'interval.end': {$exists: false} },
        {'interval.end': null } 
    ]
};