mongodb文本搜索、groupby和count

Question

MongoDB数据如下：

data1:
"_id" : ObjectId("5252a2d13cd306f74c01a3ce"),
"favorited" : false,
"user_id" : 311692506,
"source" : "web"
"text" : "help me!",
"created_at" : ISODate("2013-10-07T12:02:25.430Z"),
data2:
"_id" : ObjectId("527a5a943cd306e83e04071b"),
"favorited" : false,
"user_id" : 1635733694,
"source" : "Android",
"text" : "help 123",
"created_at" : ISODate("2013-11-06T15:04:52.066Z"),
data3:
"_id" : ObjectId("526d03183cd306f74c0f842c"),
"favorited" : false,
"user_id" : 302310143,
"text" : "help you are...",
"created_at" : ISODate("2013-10-27T12:12:08.819Z"),
data4:
"_id" : ObjectId("526030923cd306f74c08e89b"),
"favorited" : false,
"user_id" : 1155372614,
"source" : "Android",
"text" : "heeeey help",
"created_at" : ISODate("2013-10-17T18:46:42.977Z"),
data5:
"_id" : ObjectId("525401253cd306f74c02c235"),
"favorited" : false,
"user_id" : 302310143,
"source" : "IOS",
"text" : "help android help",
"created_at" : ISODate("2013-10-08T12:57:09.496Z"),

我还通过使用MongoDB TextSearch获得了它。我想计算类似的源区域结果如下：

IOS: 1
Android: 2
web: 1

---

我的mongodb查找代码：db.mycollection.runCommand（"text"，｛search:"yardim"，limit:5｝）

如何将"聚合"代码集成到"查找"代码

Answer 1

您可以通过使用聚合框架来实现。代码应该类似于：

db.myObject.aggregate(
    {$match:{"source" : {$exists:true}}},
    {$group:{_id:"$source", "count": {$sum:1}}}
);