mongodb,从$lookup中获取仅值列表

Travis Bear • 4 年前 • 851 次点击

对于MongoDB,使用时 $lookup 若要查询多个集合,是否可以获取 ?

我不想要的是完整对象及其所有键/值的列表。

数据 :

failover_tool:PRIMARY> db.foo.find().pretty()
{
    "_id" : ObjectId("5ce72e415267960532b8df09"),
    "name" : "foo1",
    "desc" : "first foo"
}
{
    "_id" : ObjectId("5ce72e4a5267960532b8df0a"),
    "name" : "foo2",
    "desc" : "second foo"
}
failover_tool:PRIMARY> db.bar.find().pretty()
{
    "_id" : ObjectId("5ce72e0c5267960532b8df06"),
    "name" : "bar1",
    "foo" : "foo1"
}
{
    "_id" : ObjectId("5ce72e165267960532b8df07"),
    "name" : "bar2",
    "foo" : "foo1"
}
{
    "_id" : ObjectId("5ce72e1d5267960532b8df08"),
    "name" : "bar3",
    "foo" : "foo2"
}

{
    "_id" : ObjectId("5ce72e415267960532b8df09"),
    "name" : "foo1",
    "desc" : "first foo",
    "bars" : ["bar1", "bar2"]
},
{
    "_id" : ObjectId("5ce72e4a5267960532b8df0a"),
    "name" : "foo2",
    "desc" : "second foo",
    "bars" : ["bar3"]
}

最近的

bars 字段:

db.foo.aggregate({
    $lookup: {
        from:"bar",
        localField:"name",
        foreignField: "foo",
        as:"bars"
    }
}).pretty()

Python社区是高质量的Python/Django开发社区
本文地址：http://www.python88.com/topic/53464

851 次点击

文章 [ 2 ] | 最新文章 4 年前

• 1 楼

the_mahasagar 4 年前

希望以下查询有帮助:

db.foo.aggregate([{
  $lookup: {
    from:"bar",
    localField:"name",
    foreignField: "foo",
    as:"bars"
  }
 },
 {$unwind : '$bars'},
 {
   $group : {
    _id : {
        _id : '$_id',
        name : '$name',
        desc : '$desc'
    },
    bars : { $push : '$bars.name'}
   }
 },
 {
   $project : {
     _id : '$_id._id',
     name : '$_id.name',
     desc : '$_id.desc',
     bars : '$bars'
  }
 }
]).pretty()

{
 "_id" : ObjectId("5ce72e4a5267960532b8df0a"),
 "name" : "foo2",
 "desc" : "second foo",
 "bars" : [
    "bar3"
 ]
}
{
 "_id" : ObjectId("5ce72e415267960532b8df09"),
 "name" : "foo1",
 "desc" : "first foo",
 "bars" : [
    "bar1",
    "bar2"
 ]
}

• 2 楼

Ashh 4 年前

只是使用 .dot 用符号表示 name 领域

db.foo.aggregate([
  { "$lookup": {
    "from": "bar",
    "localField": "name",
    "foreignField": "foo",
    "as": "bars"
  }},
  { "$addFields": { "bars": "$bars.name" }}
])

MongoPlayground

登录后回复