Mongodb查询语句

db.getCollection('RpcMonitor_Request').find(
{
"RequestStartTime" :
{
$gt :ISODate("2018-05-14 02:00"),
$lt:ISODate("2018-05-14 04:00")
},
"_id":ObjectId("5af8fc5809d8d057f6a734e4")
})

db.getCollection('RpcMonitor_Request').aggregate(
[
{
$group:
{
RequestCount:{$sum:1},
_id:
{
"RequestDay": { $dateToString: { format: "%Y-%m-%d", date: "$RequestStartTime" } },
"RequestTypeName":"$RequestTypeName",
"RequestMethodName":"$RequestMethodName"
}
}
},
{ $project : {"_id": 0, "RequestDay" : "$_id.RequestDay", "RequestTypeName" : "$_id.RequestTypeName", "count" : "$RequestCount","RequestMethodName":"$_id.RequestMethodName"}}
])

db.getCollection('RpcMonitor_Request').aggregate(
[
{$match:{
"RequestStartTime" :
{
$gt :ISODate("2018-05-14 02:00"),
$lt:ISODate("2018-05-14 04:00")
}
}},
{
$group:
{
RequestCount:{$sum:1},
_id:
{
"RequestDay": { $dateToString: { format: "%Y-%m-%d", date: "$RequestStartTime" } },
"RequestTypeName":"$RequestTypeName",
"RequestMethodName":"$RequestMethodName"
}
}
},
{ $project : {"_id": 0, "RequestDay" : "$_id.RequestDay", "RequestTypeName" : "$_id.RequestTypeName", "count" : "$RequestCount","RequestMethodName":"$_id.RequestMethodName"}}
])

var group = new BsonDocument
{
{ "_id", new BsonDocument
{
{ "Month", new BsonDocument("$month", "$RequestStartTime") },
{ "Day", new BsonDocument("$dayOfMonth", "$RequestStartTime") },
{ "Year", new BsonDocument("$year", "$RequestStartTime") },
{ "RequestMethodName", "$RequestMethodName" },
{ "RequestTypeName", "$RequestTypeName" },
{ "IsSuccess", "$IsSuccess" },
}
},
{ "Count", new BsonDocument("$sum", 1) } };
var project = new BsonDocument
{
{
"_id",0
},
{
"RequestMethodName","$_id.RequestMethodName"
},
{
"RequestTypeName","$_id.RequestTypeName"
},
{
"IsSuccess","$_id.IsSuccess"
},
{
"TotalCount","$Count"
}
};

var group = new BsonDocument
{
{ "_id", new BsonDocument
{
{ "RequestTime",new BsonDocument{
{
"$dateToString",new BsonDocument{
{ "format","%Y-%m-%d %H:%M"},
{"date", "$RequestStartTime" }
}
}
} },
{ "Day", new BsonDocument("$dayOfMonth", "$RequestStartTime") },
{ "Year", new BsonDocument("$year", "$RequestStartTime") },
{ "RequestMethodName", "$RequestMethodName" },
{ "RequestTypeName", "$RequestTypeName" },
{ "IsSuccess", "$IsSuccess" },
}
},
{ "Count", new BsonDocument("$sum", 1) } };

作者：yjq
欢迎任何形式的转载，但请务必注明出处。
.netcore相关功能需要定制的可以找我。有丰富的并发处理，性能优化经验。单点登录，限流，熔断，读写分离等功能均可定制。也可以帮忙系统优化处理，系统诊断，请联系博主(备注添加原因)。微信：yjq425527169 QQ：425527169
本篇文章如有些许帮助请点击推荐让更多需要帮助的人可以看到，请支持原创，请大方打赏（右边点击打赏）