find array of objects with only matched object in subarray mongoose?

Question

I'm trying to get an array of objects with the matching id's and with only sub-array product_price object with matching attributes size and model?

      product_name: {
        type: String,
        required: true,
      },
      service_hourly_price: {
        type: Number,
        required: true
      },
      product_price: [{
        model:{
          type: String,
          enum:['Euro','Japanese']
        },
        size:{
          type: String,
          enum: ['S','M','L','XL']      
        },
        price:{
          type: Number,
          required: true,
        }
      }],

Trying to query like this:

ProductSchema.aggregate( [
    {$match: { _id: { 
      $in: _id.map(function(_id){ return new mongoose.Types.ObjectId(_id) })
    }}},
    { $match : { product_price : {model : 'Euro' , size: 'S'}}}
    ])

how can I achieve result like this:

products:{
  _id: new ObjectId("61b3ab3ceba5bc724d754929"),
  product_name: 'Basic Service',
  service_hourly_price: 25,
  product_price: [
    {
      _id: new ObjectId("61b3ab3ceba5bc724d75492a"),
      size: 'S',
      model: 'Euro',
      price: 100
    }
  ]
},
{
  _id: new ObjectId("61b3aa88eba5bc724d7548fb"),
  product_name: 'Horn',
  service_hourly_price: 5,
  product_price: [
    {
      _id: new ObjectId("61b3aa88eba5bc724d7548fc"),
      size: 'S',
      model: 'Euro',
      price: 110
    }
  ]
}

product_price must contain only one matching object in it.

and is there a reason for your product_price to be an array? u only have one object in it? — Branchverse
– Branchverse, Commented Dec 12, 2021 at 22:53

Branchverse · Accepted Answer · 2021-12-12 23:50:03Z

1

I am uncertain why your product_prize is an array with only one object, you could remove the array there, and thus remove the $unwind in the aggregation, but nontheless this works for you right now:

ProductSchema.aggregate( [
    {$match: { 
      _id: { 
      $in: _id.map(function(_id){ return new mongoose.Types.ObjectId(_id) })
    }}}, {
    '$unwind': {
      'path': '$product_price'
    }
  }, {
    '$match': {
      'product_price.model': 'Euro', 
      'product_price.size': 'S'
    }
  }
])

Here try it out

Here the proof with the mongo Compass:

edited Dec 12, 2021 at 23:50

answered Dec 12, 2021 at 23:21

Branchverse

1,4271 gold badge11 silver badges24 bronze badges

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

2 Comments

Zorro Over a year ago

Yeah. In resulted array we have only one object in it. It’s ok to remove the array

Zorro Over a year ago

Thanks. it works for me

Collectives™ on Stack Overflow

find array of objects with only matched object in subarray mongoose?

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