Use Mongoose aggregate to fetch object inside of an array

Question

Here is my MongoDB schema:

 {
            "_id": "603f23ff6c1d862e5ced9e35",
            "reviews": [
                {
                    "like": 0,
                    "dislike": 0,
                    "_id": "603f23ff6c1d862e5ced9e34",
                    "userID": "5fd864abb53d452e0cbb5ef0",
                    "comment": "Not so good",
                },
                {
                    "like": 0,
                    "dislike": 0,
                    "_id": "603f242a6c1d862e5ced9e36",
                    "userID": "5fd864abb53d452e0cbb5ef0",
                    "comment": "Not so good",
                }
]
productID:"hdy6nch99dndn"
}

I want to use aggregate to get the review object of a particular id. I tried but not with any success.

Here is my code:

  ProductReview.aggregate([
    { $match: { productID: productID } }
 ])

Indraraj26 · Accepted Answer · 2021-03-17 07:36:45Z

1

$match $unwind

db.collection.aggregate([
  {
    $match: {
      productID: 1
    }
  },
  {
    $unwind: "$reviews"
  },
  {
    $match: {
      "reviews._id": 2
    }
  }
])

Output:

[
  {
    "_id": ObjectId("5a934e000102030405000000"),
    "productID": 1,
    "reviews": {
      "_id": 2,
      "comment": "second comment",
      "dislikes": [
        {
          "userID": 3
        },
        {
          "userID": 4
        }
      ],
      "likes": [
        {
          "userID": 1
        },
        {
          "userID": 2
        }
      ]
    }
  }
]

Mongo Playground: https://mongoplayground.net/p/qfWS1rCuMfc

answered Mar 17, 2021 at 7:36

Indraraj26

1,9941 gold badge17 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Use Mongoose aggregate to fetch object inside of an array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related