Mongoose aggregate doesn't return unmatched subdocuments

Question

I have subdocuments inside documents. And I'm trying to get entire documents if any subdocument provides multiple conditions. It's working right except not showing unmatched subdocuments.

# EXAMPLE DOCUMENT
name: "Sam",
specs: [
  {city: "istanbul", color: "blue"},
  {city: "istanbul", color: "black"},
  {city: "izmir", color: "yellow"}
]

# QUERY
Dudes.aggregate([
    {$unwind: '$specs'},
    {$match: {'specs.city': "istanbul", 'specs.color': "yellow"} }
  ]);

It's returning the matching documents but in documents there is only matched subdocument.

# OUTPUT:
name: "Sam",
specs: [
  {city: "izmir", color: "yellow"}
]

user_2224265 · Answer

Updated Demo - https://mongoplayground.net/p/J1GF0ErYNEk

Use $elemMatch to match object inside the array element.

db.collection.find({
  specs: {
    $elemMatch: {
      "city": "istanbul",
      "color": "blue"
    }
  }
});

Demo - https://mongoplayground.net/p/Wr1L6i2dipP

You can directly use $match and remove {$unwind: '$specs'}

db.collection.aggregate([
  {
    $match: {
      "specs.city": "istanbul",
      "specs.color": "blue"
    }
  }
]);

Mongoose aggregate doesn't return unmatched subdocuments

1 Answers