我有這個(gè)文檔，想過濾它以獲取并記錄在 Content 數(shù)組中：[{ "ID": "61f1244daeaea5f165851fc9", "name": "Mulandi", "author": "Owayo", "description": "dnjsfnvlksfnvls", "created_at": "2022-01-26T10:37:01.558Z", "Section": [ { "ID": "61f557213fd9b086c3a422c5", "Title": "Weee", "Content": [ { "ID": "61f5586e3fd9b086c3a422dc", "Subsection_Title": "Idk", "Content": "Something" } ] } ],}]我應(yīng)該怎么做才能過濾這個(gè)文件我試過這個(gè)但它沒有用：pipeline := []bson.M{ {"$match": bson.M{"Name": name}}, {"$unwind": "$Section"}, {"$unwind": "$Section.Content"}, {"$project": bson.M{ "Section.Title": sectiontitle, "Section.Content.subsectionid": iuud, }}, } iter, err := collection.Aggregate(ctx, pipeline) if err != nil { return nil, err } var elem models.Course for iter.Next(ctx) { var elem models.Section err = iter.Decode(&elem) if err != nil { log.Fatal(err) } }
2 回答
DIEA
TA貢獻(xiàn)1820條經(jīng)驗(yàn) 獲得超3個(gè)贊
db.collection.aggregate([
{
"$match": {
"name": "Mulandi"
}
},
{
"$unwind": "$Section"
},
{
"$unwind": "$Section.Content"
},
{
"$match": {
"Section.Content.ID": "61f5586e3fd9b086c3a422dc"
}
},
{
"$project": {
"Subsection_Title": "$Section.Content.Subsection_Title",
"Content": "$Section.Content.Content",
"_id": "$Section.Content.ID"
}
}
])
mongoplayground
白板的微信
TA貢獻(xiàn)1883條經(jīng)驗(yàn) 獲得超3個(gè)贊
iuud, _ := primitive.ObjectIDFromHex(subsectionid)
pipeline := []bson.M{
{"$match": bson.M{"Name": name}},
{"$unwind": "$Section"},
{"$unwind": "$Section.Content"},
{"$match": bson.M{"Section.Content.ID": iuud}},
{"$project": bson.M{
"Subsection_Title": "$Section.Content.Subsection_Title",
"Content": "$Section.Content.Content",
"_id": "$Section.Content.ID",
}},
}
iter, err := collection.Aggregate(ctx, pipeline)
if err != nil {
return nil, err
}
var results []bson.M
if err = iter.All(context.TODO(), &results); err != nil {
log.Fatal(err)
}
- 2 回答
- 0 關(guān)注
- 121 瀏覽
添加回答
舉報(bào)
0/150
提交
取消