MongoDB Aggregate in Node.js with Mongoose did not get correct results

Question

I'm trying to use aggregate to get some specific results by a ObjectId field and a Date field. When i use only ObjectId to match the results, it worked correctly, but after added Date conditions, it just returns nothing. Here is my aggregate codes:

FlowerAssignment.aggregate({
            $match: {
                class: new MongoTypes.ObjectId(current_class),
                time: {
                    $lte: moment().startOf('month').toDate(),
                    $gte: moment().endOf('month').toDate()
                }
            }
        })
        .project({
            student: 1,
            name: '$studentInfo.name',
            avatar: '$studentInfo.avatar',
            flowerInfo: 1
        }).group({
            _id: '$student',
            name: {
                $first: '$name'
            },
            avatar: {
                $first: '$avatar'
            },
            flowers: {
                $sum: 1
            }
        }).exec(function (err, results) {});

What's wrong with the match conditions...I've really got no ideas....

Have you tried debugging the pipeline by removing the class: new MongoTypes.ObjectId(current_class) condition in the query and just try the query with the time range only? Can you also show a sample document with some data and the expected output? — chridam
– chridam, Commented Jun 5, 2015 at 8:22
Thanks. I just followed the answer by JohnnyHK, checked my time range, and solved it. I made an unbelievable mistake with my jammed mind. — Nicholas
– Nicholas, Commented Jun 5, 2015 at 12:51

JohnnyHK · Accepted Answer · 2015-06-05 12:06:10Z

1

Your $match object contains mutually exclusive terms as, unless it's an array, the time field of a document can't simultaneously be both before the start of the month and after the end of the month.

I'm assuming you've got those backwards and it should be:

$match: {
    class: new MongoTypes.ObjectId(current_class),
    time: {
        $gte: moment().startOf('month').toDate(),
        $lte: moment().endOf('month').toDate()
    }
}

answered Jun 5, 2015 at 12:06

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

Collectives™ on Stack Overflow

MongoDB Aggregate in Node.js with Mongoose did not get correct results

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related