我正在try 构建一个查询,该查询允许我从具有父子关系的文档中提取数组列表. 这样我就可以在Find查询中使用这个array. 查询不一定只是MongoDB,它可以是基于打字脚本的.
Question is -个 当我搜索{"itemGroupName":"pari"}时 我想将它的"ChildrenGroupList"和它的所有子级的"ChildrenGroupList"值提取到一个数组中.
.
[{
"_id": {
"$oid": "64c62f8b312e0601c656cae3"
},
"itemGroupName": "PARI",
"alias": "001",
"parentGroupName": "",
"hsn": "",
"taxCategory": "",
"status": {
"active": true
},
"childrenGroupList": [
"DREAMS PARI"
],
"__v": 0
},
{
"_id": {
"$oid": "64c62f98312e0601c656caea"
},
"itemGroupName": "DREAMS PARI",
"alias": "002",
"parentGroupName": "PARI",
"hsn": "",
"taxCategory": "",
"status": {
"active": true
},
"childrenGroupList": [
"DREAMS PARI 001",
"DREAMS PARI 002"
],
"__v": 0
},
{
"_id": {
"$oid": "64c62fb1312e0601c656caf2"
},
"itemGroupName": "DREAMS PARI 001",
"alias": "003",
"parentGroupName": "DREAMS PARI",
"hsn": "",
"taxCategory": "",
"status": {
"active": true
},
"childrenGroupList": [],
"__v": 0
},
{
"_id": {
"$oid": "64c63ffb6ecb0dcc1ee71555"
},
"itemGroupName": "DREAMS PARI 002",
"alias": "004",
"parentGroupName": "DREAMS PARI",
"hsn": "",
"taxCategory": "",
"status": {
"active": true
},
"childrenGroupList": ["DREAMS PARI 002B"],
"__v": 0
},
{
"_id": {
"$oid": "64c63ffb6ecb0dcc1ee715654"
},
"itemGroupName": "DREAMS PARI 002B",
"alias": "005",
"parentGroupName": "DREAMS PARI 002",
"hsn": "",
"taxCategory": "",
"status": {
"active": true
},
"childrenGroupList": [],
"__v": 0
}
]