SaisJS - The condition in $match is not working

Question

This is how my code looks like:

User.native(function (err, collection) {
        if (err) throw err;
        collection.aggregate([
            {
                $match: {
                    id: req.params.id,
                    createdAt: {">=": start, "<=": end}
                }
            },
            {
                $group: {
                    _id: "$class",
                    count: {$sum: 1},
                    jointime: {$max: "$endtime"}
                }
            }
        ]

The createdAt is what I added for filtering the collection by time, but after I did that, there's no result returned.

I thought it was caused by the date type, because the createdAt is date in MongoDB. But when I tried with this, I can get the correct data.

User.find({}, {id: req.params.childid, createdAt: {">=": start, "<=": end}}, function (err, result) {
        console.log("CreatedAt: " + result[0].createdAt);
        console.log("Result length: " + result.length);
    });

So, I think it's nothing to do with the date. Is there anything different in aggregate?

score 0 · Accepted Answer · answered Nov 06 '17 at 19:30

0

You should use $gte and $lte instead of ">=" and "<=" in $match operator.

 $match: {
         id: req.params.id,
         createdAt: {$gte: start, $lte: end}
 }

answered Nov 06 '17 at 19:30

Serkan Arslan

13,158
4
29
44

Okay. I will try this out. But why does it work in 'find()'? – Sky Nov 06 '17 at 23:05
I can't get the data in `find()` with `&get` and `&lte` – Sky Nov 07 '17 at 02:04
Thank you, sarslan. You are right about this. I made a stupid mistake that I used `&` instead of `$`. ToT – Sky Nov 07 '17 at 08:33

SaisJS - The condition in $match is not working

1 Answers1