I am facing a query that looks like the following:
{"$match": {$or: [{"to": system.mongoose.Types.ObjectId(userId)}, {"from": system.mongoose.Types.ObjectId(userId)}]}},
{"$sort": {"createDate": -1}},
{
"$group": {
"_id": "$conversationId",
"from": {"$first": "$from"},
"to": {"$first": "$to"},
"content": {"$first": "$content"},
"createDate": {"$first": "$createDate"},
"unreaded": {"$sum": 1}
}
},
My goal is to calculate the total number of unreaded messages without altering the main $match.
Is there a way to achieve this with something similar to:
"unreaded": {"$sum": 1, {$match: {unreaded: true}}}If you have any solution for this, please let me know.