带有聚合查询的 mongoDb $in

Question

如何在 mongoDB 中编写一个 $in 查询和聚合？我想为下面的 SQL 编写等效的 mongoDB 查询

SELECT name,count(something) from collection1
where name in (<<list of Array>>) and cond1 = 'false'
group by name

Answer 1

等效的 mongo 查询如下:

db.collection1.aggregate([
    { "$match": { 
        "name": { "$in": arrayList },
        "cond1": "false"
    } }, 
    { "$group": {
        "_id": "$name",
        "count": { "$sum": "$something" }
    } }
])