记录mongo查询语句

db.vouchers_person.find({'companyId':'610cf2d81afbb52c00c9a5fb',"status" : { "in" : [2,3,5]},"recoveryStatus": {"in" : [2,3,4]}}).limit(50);

计算mongo的某列累加值
db.getCollection('vouchers_person').aggregate( [{ "match" : { "createTime" : { "lt" : { "date" : "2022-06-30T15:59:59.000Z"} , "gte" : { "date" : "2021-08-01T16:00:00.000Z"}} , "companyId" : "610cf2d81afbb52c00c9a5fb" , "status" : { "in" : [ 1 , 2 , 3 , 4 , 5]} , "voucherSource" : { "ne" : 7}}} , { "group" : { "_id" : "companyId" , "totalGrantAmount" : { "sum" : "voucherDenominationInt"} , "totalRecoveryAmount" : { "sum" : "$recoveryAmountInt"}}}]);

db.getCollection('vouchers_person').aggregate( [ { "match" : { "recoveryTime" : { "lt" : { "date" : "2022-06-30T15:59:59.000Z"} , "gte" : { "date" : "2021-08-01T16:00:00.000Z"}} , "companyId" : "610cf2d81afbb52c00c9a5fb" , "status" : { "in" : [ 1,2 , 3 ,4, 5]} , "voucherSource" : { "ne" : 7}}} , { "group" : { "_id" : "companyId" , "totalGrantAmount" : { "sum" : "voucherDenominationInt"} , "totalRecoveryAmount" : { "sum" : "$recoveryAmountInt"}}}]);

©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容