Monthly Archives: August 2013

mongodb query with cond, group, sort and limit

Posted on August 15, 2013 by Xiaomeng (Shawn) Wan

db.user_data.aggregate([{$match:{‘start_time’:{$gt:ISODate(“2013-07-15T00:00:00Z”),$lt:ISODate(“2013-08-15T00:00:00Z”)},’site_id’:403}},{$project:{term:’$ga.term’}},{$group:{ _id : ‘$term’ , number : { $sum : 1 }}},{$sort : { number : -1 }},{$limit : 10}]);

Posted in mongodb | Leave a comment