'MongoDB, populate nested object in array

I have a question ... I have a schema like this :

const chatSchema = new Schema({
[...]
  title: {
        type: String,
        required: true
    },
   message: [
    {
      content: {
        type: String,
        required: true
      },
      creator: {
        type: mongoose.Types.ObjectId,
        required: true,
        ref: 'User'
      }
    }
  ],
[...]
});

in my Node backend, how can I have access to my creators instances inside my message array ? I don’t know how to write the query with populate ...

Thank you all ! :-)

node.jsmongodb


Solution 1:[1]

use the following command:

...after importing chatSchema as maybe chats

module.exports.populateCreator = (req, res) => {
  chats.findOne({chatID})
    .populate({
      path: 'message',
      populate: {
        path: "creator"
      }
    })
    .then(chats => res.json(chats))
}

Solution 2:[2]

You can use like this

Chats.find(query)
  .populate({ 
     path: 'message',
     populate: {
       path: 'creator'
     } 
  })
  .exec(function(err, docs) {});

Solution 3:[3]

the query you are looking for is:

https://mongoplayground.net/p/2dpeZWsXR-V

db.booking.aggregate([
  {
    "$match": {
      id: "61fdfeef678791001880da25"
    }
  },
  {
    $unwind: "$cart"
  },
  {
    "$lookup": {
      "from": "products",
      "localField": "cart.product",
      "foreignField": "id",
      "as": "prod"
    }
  },
  {
    "$unwind": "$prod"
  },
  {
    "$project": {
      id: 1,
      status: 1,
      cart: [
        {
          id: "$cart.id",
          date: "$cart.date",
          timeSlots: "$cart.timeSlots",
          product: {
            id: "$prod.id",
            name: "$prod.name",
            
          }
        }
      ],
      
    }
  }
])

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Moyosore Ogunleye
Solution 2 Ankita Kuchhadiya
Solution 3 Rafiq

Related Questions