44.11. aggregate

44.11. aggregate
上一页	第 44 章 MongoDB Shell	下一页

44.11.1. project

$split

				
{
	"_id" : ObjectId("591a710320156761bdf68a06"),
	"_class" : "mis.domain.PyramidSelling",
	
	...
	...
	
	"status" : true,
	"createdDate" : ISODate("2017-05-16T03:24:51.511Z")
}

				
db.getCollection('pyramidSelling').aggregate([
  { $project : { _class : { $split: ["$_class", "."] } } }
]);

substr

				
db.getCollection('pyramidSelling').aggregate(
[
	{
	$project: {
		userName: 1,
			phone: {
				prefix: { $substr: [ "$phone", 0, 3 ] },
				mobile: { $substr: [ "$phone", 3, 11 ] }
			},
		}
	}
]
)

44.11.2. groupby + sum

select username, sum(balance) as total from users group by member.

			
db.member.aggregate([{ 
    $group: { 
        _id: "$username", 
        total: { $sum: "$balance" }
    } 
}])

上一页	上一级	下一页
44.10. 查询	起始页	44.12. Indexes 索引