Mongo db aggregation multiple conditions
If I got your requirements right you should put the filter in the match part of the pipeline:
db.workouts.aggregate( [
{ $match: { user_id: ObjectId("...."), "avg_intensity": { $gt: 20, $lte: 25 } } },
{ $group: { _id: ..., count: ... } }
] );
To combine logical conditions under a $cond
operator then wrap the conditions with an $and
operator:
db.workouts.aggregate([
{ "$match": { "user_id": ObjectId("....") }},
{ "$project": {
"20": { "$cond": [
{ "$and": [
{ "$gt": [ "$avg_intensity", 20 ] },
{ "$lt": [ "$avg_intensity", 25 ] }
]},
"$total_volume",
0
]}
}}
])