Please help me with this query

Working with Data
, ,
1

Hi , I am new to MongoDB, I am using Mongoose to create this schema model:
I am looking for to write a query that gives me the stores of a customer with customer ID “12345” that has stores points greater than 5.

const customerSchema = new mongoose.Schema({
    name: {
        type: String,
        required: [true, 'Error: Name is required!']
    },
    stores: [
      {
        store: {
          type: mongoose.Schema.Types.ObjectId,
          ref: 'Store'
        },
        points: {
          type: Number
        }
      }
    ]
})
2 
Customer.findOne({ _id: customerId })
  .populate({
    path: "stores.store",
    match: { points: { $gt: 5 } }
  })

You can refer from here Mongoose v7.3.1: Query Population

3

Hi Anuj,
Thanks for your suggestion, I tried it but it seems it gives me all the stores, not only the one that has more than 5 points. Here is the code I have:

Customer.findOne({ _id: '64911dbfc087bb01145cd6b3' })
  .populate({
    path: "stores.store",
    match: { points: { $gt: 5 } }
  })
  .then(result => console.log(result))
  .catch(e => console.log(e.message))

and this is what I got as result:

{
  _id: new ObjectId("64911dbfc087bb01145cd6b3"),
  name: 'Reza 8',
  stores: [
    {
      store: null,
      points: 3,
      _id: new ObjectId("649126d487886c930fd30f6e")
    },
    {
      store: null,
      points: 10,
      _id: new ObjectId("649127244d57657bd134d941")
    }
  ],
  __v: 0
}

it shows the store that has 3 points that is not correct. Do you have any suggestion please? I appreciate it