MongoDB聚集多个查找条件

Question

我有3个收藏。

db.a.insert([
  { "_id" : ObjectId("5b56989172ebcb11105e8f41"), "db_type":b, "number" : 1},
  { "_id" : ObjectId("5b56989172ebcb11105e8f42"), "db_type":c, "number" : 2},
])

db.b.insert([
  { "_id" : ObjectId("5b56989172ebcb11105e8f43"), "number" : 1, "value" : "111"},
])

db.c.insert([
  { "_id" : ObjectId("5b56989172ebcb11105e8f44"), "number" : 2, "value" : "222"},
])

我想根据db_type进行查找查询，以从每个集合中获取值。

在这种情况下，我该怎么办？

结果：

{ "_id" : ObjectId("5b56989172ebcb11105e8f41"), "db_type" : b, "number" : 1, "value" : "111"}
{ "_id" : ObjectId("5b56989172ebcb11105e8f42"), "db_type" : c, "number" : 2, "value" : "222"}

堵塞零件...

db.getCollection('a').aggregate([
    {
        "$lookup":{
            "from":         "b" or "c", // I want to give condition here.
            "localField":   "number",
            "foreignField": "number",
            "as":           "result"
        }
    },
])

Answer 1

对于您的情况，由于您只有2个情况b和c可以从中查找。您可以简单地进行2个单独的查找，然后使用$ setunion将结果分组在一起。

db.a.aggregate([
  {
    "$lookup": {
      "from": "b",
      "let": {
        db_type: "$db_type",
        number: "$number"
      },
      "pipeline": [
        {
          $match: {
            $expr: {
              $and: [
                {
                  $eq: [
                    "$db_type",
                    "b"
                  ]
                },
                {
                  $eq: [
                    "$number",
                    "$number"
                  ]
                }
              ]
            }
          }
        }
      ],
      "as": "bLookup"
    }
  },
  {
    "$lookup": {
      "from": "c",
      "let": {
        db_type: "$db_type",
        number: "$number"
      },
      "pipeline": [
        {
          $match: {
            $expr: {
              $and: [
                {
                  $eq: [
                    "$db_type",
                    "c"
                  ]
                },
                {
                  $eq: [
                    "$number",
                    "$number"
                  ]
                }
              ]
            }
          }
        }
      ],
      "as": "cLookup"
    }
  },
  {
    "$addFields": {
      "allLookup": {
        "$setUnion": [
          "$bLookup",
          "$cLookup"
        ]
      }
    }
  }
])

这是 mongo playground 供您参考。