Matching nested array of nested subdocuments in MongoDB

Question

I am trying to create a query, that matches two criteria. Match a specific userId and match a range of Id's.

An example document could look like this:

I have tried with using find by adding the userId and then using the MongoDB $in operator to match a list of feature (as an id)

  const featureIds = features.map(feature => feature._id)
    console.log(featureIds)
    const isFeatureExists = await this.userShopModel.find({
      userId,
      'items.feature': { $in: featureIds },
    })
    console.log(isFeatureExists)

I have also tried with different versions of aggregate but without any luck.

Any mongo experts, who can help me?

there is no userId field in your screenshot..

turivishal
– turivishal

2021-01-27 12:31:48 +00:00
Commented Jan 27, 2021 at 12:31 — turivishal
– turivishal, Commented Jan 27, 2021 at 12:31

Mohammad Yaser Ahmadi · Accepted Answer · 2021-01-27 12:34:49Z

1

use _id for filter

const featureIds = features.map(feature => feature._id)
    console.log(featureIds)
    const isFeatureExists = await this.userShopModel.find({
      _id : userId,
      'items.feature': { $in: featureIds },
    })
    console.log(isFeatureExists)

answered Jan 27, 2021 at 12:34

Mohammad Yaser Ahmadi

5,0914 gold badges21 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Matching nested array of nested subdocuments in MongoDB

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