mongodb 简单查询

db.jobs.find({"Cst":"DONE","Org_acc":{$nin:["losebank","ZHANGZKJ"]},"Ct":{$gt:ISODate("2015-07-13T00:00:00.000Z")}},{"Ar":1,"_id":0,"Cst":1,"Aws":1,"Tk":1,"RawdataRequird" :1,"RptRequird" :1,"RptType" :1,"RptVer" :1,"WaitRpt":1}).forEach(function(x){   

    var ArNum = 0;

    var AwsNum = 0;

    

    var ars = x.Ar;

    for(var i in ars){

           ArNum++;

    }

    

    var aws = x.Aws;

    for(var i in aws){

           AwsNum++;

    }

    

    var waitRpt = x.WaitRpt;

    for(var i in waitRpt){

       if(ArNum>0 && ArNum==AwsNum){

            print(x.Tk + ' awsNum='+AwsNum+',arNum='+ArNum+waitRpt[i]);  

       }

          

    }  

})

 

Aggregation查询

db.getCollection('aggregation').find({"Ct":{"$gte":ISODate("2016-08-15:16:00.000Z"),"$lte":ISODate("2016-09-01:00:00.000Z")},"jobs.detail.Orgacc":"yixinrongzi","jobs.detail.Lsr":{"$ne":null}}).forEach(function(x){print(x.Tk);})