我对Mongodb并不熟悉,也不太了解聚合,如何将对象下面的内容更改为所需的单个对象数组。
[
{
id: "1",
title: "First Title",
des: "This is desc",
contents: [
{
id: "1",
title: "content-1 title",
des: "This is desc"
},
{
id: "2",
title: "Content-2 title",
des: "This is desc"
}
]
},
{
id: "2",
title: "Second Title is Here",
des: "This is desc",
contents: [
{
id: "1",
title: "content-1 title",
des: "This is desc"
},
{
id: "2",
title: "Content-2 title",
des: "This is desc"
}
]
}
]我想要的单一数组:
[
{
id: "1",
title: "First Title",
des: "This is desc"
},
{
id: "1",
title: "content-1 title",
des: "This is desc"
},
{
id: "2",
title: "Content-2 title",
des: "This is desc"
},
{
id: "2",
title: "Second Title is Here",
des: "This is desc"
},
{
id: "1",
title: "content-1 title",
des: "This is desc"
},
{
id: "2",
title: "Content-2 title",
des: "This is desc"
}
]发布于 2022-04-07 05:02:08
db.collection.aggregate([
{
$set: {
contents: {
$concatArrays: [
[
{
id: "$id",
title: "$title",
des: "$des"
}
],
"$contents"
]
}
}
},
{
$unwind: "$contents"
},
{
$replaceWith: "$contents"
}
])https://stackoverflow.com/questions/71776439
复制相似问题