MongoDB match array based on document value rather than explicit condition

Question

Let's say I have the following document structure:

{
  "A": {
    "_id": "ID0"
  },
  "B": [
    {
      "_id": "ID0",
      "field": "X"
    },
    {
      "_id": "ID1",
      "field": "Y"
    }
  ]
}

I want to project B matched with the _id in A. The end result would be:

{
  "B": [
    {
      "_id": "ID0",
      "field": "X"
    }
  ]
}

I tried the following but apparently I'm doing something wrong. Is it possible to match based on a document filed rather than an explicit condition?

db.collection.aggregate([
  {$match: {"B._id": "$A._id"}},
  {$project: {"B": 1}}
])

I just made up that example so I might have missed a character somewhere. Feel free to point it out! — CHRD, Apr 15 '20 at 09:32
B is an array... 'a' and 'b' are fields of same object? two different objects? Not a typo, but a structure issue — matthPen, Apr 15 '20 at 09:52
"B": [ {"a": { "_id": "ID0", "field": "X" }}, { "b": { "_id": "ID1", "field": "Y" }} ] — matthPen, Apr 15 '20 at 09:56
or "B": [ { "_id": "ID0", "field": "X" }, { "_id": "ID1", "field": "Y" } ] — matthPen, Apr 15 '20 at 09:57
"B": [ "a": { "_id": "ID0", "field": "X" } ] is not valid! choose a valid structure between the 2 previous — matthPen, Apr 15 '20 at 10:02
Does this answer your question? [MongoDB match array based on document value](https://stackoverflow.com/questions/61223895/mongodb-match-array-based-on-document-value) — Valijon, Apr 15 '20 at 10:05

score 1 · Accepted Answer · answered Apr 15 '20 at 10:08

You can use $filter aggregation operator to achieve this :

db.collection.aggregate([
  {
    $addFields: {
      "B": {
        $filter: {
          input: "$B",
          as: "arr",
          cond: {
            $eq: [
              "$A._id",
              "$$arr._id"
            ]
          }
        }
      }
    }
  }
])

Test it here

MongoDB match array based on document value rather than explicit condition

1 Answers1