How to get data from nested JSON MongoDB object with nodeJS?

Question

MongoDB

I have JSON object in MongoDB

I have tried

findOne({'menu.products': 
     {$elemMatch:{
          '_id': 60475de5ce4dd6151019d574
           }
     }})

But it outputs the whole array. It turned out to be as close as possible with this code

distinct('menu.products', { 'menu.products._id': 60475de5ce4dd6151019d574 })

It already outputs all products, but not the requested one. How can I get the requested product by ID?

Answer 1

There is no need to store data like this, this is an unnormalized base, it’s better to redo it before it’s too late.
In particular, products must be links to another data collection. Your problem arises precisely for this reason.

// api: collection.find{filter, options}
myCollection.find({
  'menu.products': {
    $in: {
      {
        '_id': 60475de5ce4dd6151019d574
      }
    }
  }
}, {
  projection: {
    'menu.products': 1
  }
})