How will I select a particular object from the array of objects in the mongoose schema?

Question

    var mongoose = require("mongoose");
    
    // schema setup
    var productSchema = new mongoose.Schema({
        type:{
            type:String,
            required:[true,'a product must have a type']
        },
        sId:String,
        image:String,
        products:[{
            name:String,
            image:String,
            price:Number
        }]
    });
    
    module.exports = mongoose.model("Product",productSchema);

I have made my mongoose schema like this. Now I just want to access a particular object from the array of objects named 'products' using a mongoose query. Can anyone please tell me how can i do this?? I'll be soo grateful.

J.F. · Accepted Answer · 2020-11-03 11:45:13Z

1

You need something like this:

db.collection.find({
  "products.name": "name"
},
{
  "products.$": 1
})

With this query you will find the product object whose name field is 'name'. Afther that, with the positional operator $ only the matching is returning.

Mongo playground example here

Edit: Note that this query will return multiple subdocuments if exists multiple documents with the array object matching. To filter for a unique element you have to indicate another unique field like this:

db.collection.find({
  "sId": "1",
  "products.name": "name"
},
{
  "products.$": 1
})

Edit to explain how to use find using mongoose.

You can use find or findOne, but the query itself will be the same.

This is pretty simple. You need to use your model described in the question, so the code is somthing like this:

var objectFound = await YourModel.findOne({
  "products.name": "name"
},
{
  "products.$": 1
})

Where YourModel is the schema defined.

edited Nov 3, 2020 at 11:45

answered Nov 3, 2020 at 7:44

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

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

2 Comments

Shagun Sharma Over a year ago

Thankyou so much for the answer.But what you told me will only work in the console.What would be the mongoose query for it..to directly add in the code???

J.F. Over a year ago

@ShagunSharma I've updated the answer. But, basically the query itself is the same into mongoose. You have to call findOne() function from your model.

Collectives™ on Stack Overflow

How will I select a particular object from the array of objects in the mongoose schema?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related