Menu
I want to query like below, but this contains only one $cond.
How to query with two $cond?
collection.aggregate( { $match : { '_id' : {$in:ids} } }, { $group: { _id: '$someField', ... count: {$sum: { $cond: [ { $eq: [ "$otherField", false] } , 1, 0 ] }} } }, function(err, result){ ... } ); 
588
Introduction to SQL GROUP BY Multiple Columns 1 Usage of GROUP BY Multiple Columns. When the grouping criteria are defined on more than one column or expressions then all the records that match and have the same values ... 2 Examples. ... 3 Conclusion. ...
In Power Query, you can group values in various rows into a single value by grouping the rows according to the values in one or more columns. You can choose from two types of grouping operations: Aggregate a column by using an aggregate function.
We can group the resultset in SQL on multiple column values. When we define the grouping criteria on more than one column, all the records having the same value for the columns defined in the group by clause are collectively represented using a single record in the query output.
In Power Query, you can group values in various rows into a single value by grouping the rows according to the values in one or more columns. You can choose from two types of grouping operations: Aggregate a column by using an aggregate function. Perform a row operation.
You want to use a compound expression inside {$cond:[]} - something like:
collection.aggregate( { $match : { '_id' : {$in:ids} } }, { $group: { _id: '$someField', ... count: {$sum: { $cond: [ {$and : [ { $eq: [ "$otherField", false] }, { $eq: [ "$anotherField","value"] } ] }, 1, 0 ] }} } }, function(err, result){ ... } ); The $and operator is documented here: http://docs.mongodb.org/manual/reference/operator/aggregation/#boolean-operators
141
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
