mongodb聚合逐层拆分数组元素

最新推荐文章于 2023-03-21 20:50:46 发布

virtualreal

最新推荐文章于 2023-03-21 20:50:46 发布

阅读量3.2k

点赞数 3

文章标签： mongodb

本文链接：https://blog.csdn.net/tianwenwentian123/article/details/103713173

版权

mongodb聚合逐层拆分数组元素

mongodb中的聚合操作aggregate可以实现很多对数据库文档的复杂操作，而拆分数据库中的数组类型字段元素就是功能之一，$unwind操作可以实现对文档中数组字段的拆分。
对某字段进行拆分语法

	db.test.aggregate([{$unwind:'$字段名称'}])
	例如数据
	{"id" : "XXXXXX",
	"array" : [
	{item:"a",size:[{title:"a",no:1},{title:"a",no:2}]},  
	 {item:"b",size:[{title:"b",no:1},{title:"b",no:2}]},
	{item:"c",size:[{title:"c",no:1},{title:"c",no:2}]}
	]
	}

第一次拆分

	db.test.aggregate([{$unwind:'$array'}])
	得到数据：
	{
	"id" : "XXXXXX",
	arrray:{item:"a",size:[{title:"a",no:1},{title:"a",no:2}]}
	},
		{
	"id" : "XXXXXX",
	arrray: {item:"b",size:[{title:"b",no:1},{title:"b",no:2}]},
	},
			{
	"id" : "XXXXXX",
	arrray: {item:"c",size:[{title:"c",no:1},{title:"c",no:2}]},
	}

*第二层拆分

db.test.aggregate([{$unwind:'$array'}，{$unwind:"$array.size"}])
得到数据：
	{
	"id" : "XXXXXX",
	arrray:{item:"a",size:{title:"a",no:1}}
	},
	{
	"id" : "XXXXXX",
	arrray:{item:"a",size:{title:"a",no:2}}
	},
	{
	"id" : "XXXXXX",
	arrray:{item:"b",size:{title:"b",no:1}}
	},
	{
	"id" : "XXXXXX",
	arrray:{item:"a",size:{title:"b",no:2}}
	},
	{
	"id" : "XXXXXX",
	arrray:{item:"c",size:{title:"c",no:1}}
	},
	{
	"id" : "XXXXXX",
	arrray:{item:"c",size:{title:"c",no:2}}
	},