mongoose how to count the number of item in array embedded model

Question

Working on Mongoose schema want to count the number of item in cart array how can write the function? Where I want to find particular customer & count the length of the Cart Array

async function countcartproduct(Customer_id){
    console.log(Customer_id);
    const total = await CustomerCart.aggregate([{$match:{Customer_id:Customer_id}},{$project:{Cart:{$size:'$Cart'}}}]);
    console.log(total);
}

var CustomerCart = mongoose.Schema({
    Customer_id:{
       type:mongoose.Schema.Types.ObjectId,
       ref:'Customers'
    },
    Cart:[{
        Product_id:{
             type:String,
             require:true
        },
        Product_Name:{
            type:String,
            require:true,
        },
        Product_Price:{
            type:Number,
            require:true,
        },
        Product_Quantity:{
            type:Number,
            require:true,
            default:1,
        }
    }]
})

is the above aggregation not working?

Smriti Shikha
– Smriti Shikha

2021-12-28 15:04:53 +00:00
Commented Dec 28, 2021 at 15:04 — Smriti Shikha
– Smriti Shikha, Commented Dec 28, 2021 at 15:04
No it return the empty array

Puneet Phull
– Puneet Phull

2021-12-28 15:06:00 +00:00
Commented Dec 28, 2021 at 15:06 — Puneet Phull
– Puneet Phull, Commented Dec 28, 2021 at 15:06

Smriti Shikha · Accepted Answer · 2021-12-28 16:21:16Z

2

the customer id that you are passing is going as a string but it is object id in your schema, so no documents were matching

async function countcartproduct(Customer_id) {
    console.log(Customer_id);
    const total = await CustomerCart.aggregate(
        [{
            $match: {
                Customer_id: mongoose.Types.ObjectId(Customer_id)
            }
        },
        {
            $project: {
                Cart: {
                    $size: '$Cart'
                }
            }
        }]);
    console.log(total);
}

converting it to object id should work

answered Dec 28, 2021 at 16:21

Smriti Shikha

4313 silver badges6 bronze badges

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

Collectives™ on Stack Overflow

mongoose how to count the number of item in array embedded model

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