Mongodb查找计数> 5

debugcn 发表于 Dev

开发者2012

我有一个名为caminhos以下文档的集合：

"_id" : ObjectId("54e2aa2f71defd010b1caf5c"),
    "data" : "2015-02-17 12:40:47",
    "rua" : "Rua Caperuçu, 119–211",
    "horario" : "12:40:47",
    "localizacao" : {
        "type" : "Point",
        "coordinates" : [ 
            -46.6452, 
            -23.60894
        ]
    },
    "id_usuario" : "54bef57a14b88ad70a8ab74e" }

/* 32 */ {
    "_id" : ObjectId("54e387d371defd010b1caf5d"),
    "data" : "2015-02-17 04:26:27",
    "rua" : "Rua Camaipi, 1–83",
    "horario" : "04:26:27",
    "localizacao" : {
        "type" : "Point",
        "coordinates" : [ 
            -46.63184, 
            -23.47975
        ]
    },"id_usuario" : "54bef57a14b88ad70a8ab74e" }

/* 33 */ {
    "_id" : ObjectId("54e387d471defd010b1caf5e"),
    "data" : "2015-02-17 04:26:27",
    "rua" : "Rua Camaipi, 1–83",
    "horario" : "04:26:27",
    "localizacao" : {
        "type" : "Point",
        "coordinates" : [ 
            -46.63179, 
            -23.47985
        ]
    },"id_usuario" : "54bef57a14b88ad70a8ab74e" }

/* 34 */ {
    "_id" : ObjectId("54e387d471defd010b1caf5f"),
    "data" : "2015-02-17 04:26:27",
    "rua" : "Rua Camaipi, 1–83",
    "horario" : "04:26:27",
    "localizacao" : {
        "type" : "Point",
        "coordinates" : [ 
            -46.63177, 
            -23.47987
        ]
    },"id_usuario" : "54bef57a14b88ad70a8ab74e" }

我需要将所有值id_usuario = 54bef57a14b88ad70a8ab74e and相同但rua值and不同的文档data分组，并仅查找/选择具有以下内容的分组count>5

无插座

这似乎是一个非常基本的问题，您可以使用and运算符通过聚合管道解决该问题，以获取所需的内容。$group$match

db.caminhos.aggregate([
  { $match: { id_usuario: "54bef57a14b88ad70a8ab74e" } },
  { $group: { _id: { rua: "$rua", data: "$data" } } },
  { $group: { _id: "$_id.rua", data: { $push: "$_id.data" }, count: { $sum: 1 } } },
  { $match: { count: { $gt: 5 } } }
])

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。