CODEWITHSUNDEEP
mongodbdateisodate
Ayush Gupta
Ayush Gupta

Reputation: 1707

Mongo query using aggregation for dates

In the following query I'm trying to find entries in my articles collection made in the last week, sorted by the number of votes on that article. The $match doesn't seem to work(maybe I dont know how to use it). The following query works perfectly, so its not a date format issue,

db.articles.find(timestamp:{
                '$lte':new Date(),
                '$gte':new Date(ISODate().getTime()-7*1000*86400)}
        })

But this one doesn't fetch any results. Without the $match it also fetches the required results(articles sorted by votecount).

db.articles.aggregate([
    {
        $project:{
            _id:1,
            numVotes:{$subtract:[{$size:"$votes.up"},{$size:"$votes.down"}]}}
    },
    {
        $sort:{numVotes:-1}
    },
    {
        $match:{
            timestamp:{
                '$lte':new Date(),
                '$gte':new Date(ISODate().getTime()-7*1000*86400)}
        }
    }
])

Upvotes: 4

Views: 2251

Answers (1)

David Rissato Cruz
David Rissato Cruz

Reputation: 3637

You are trying to match at the end of your pipeline, which supposes you have projected timestamp field, and you haven't done that.

I believe what you want is to filter data before aggregation, so you should place match at the top of your aggregation array.

Try this:

db.articles.aggregate([{
    $match: {
        timestamp: {
            '$lte': new Date(),
            '$gte': new Date(ISODate().getTime() - 7 * 1000 * 86400)
        }
    }
}, {
    $project: {
        _id: 1,
        numVotes: {
            $subtract: [{
                $size: "$votes.up"
            }, {
                $size: "$votes.down"
            }]
        }
    }
}, {
    $sort: {
        numVotes: -1
    }
}])

Upvotes: 4

Related Questions