How to search in array of object in mongodb

by

The right way is:

db.users.find({awards: {$elemMatch: {award:'National Medal', year:1975}}})

$elemMatch allows you to match more than one component within the same array element.

Without $elemMatch mongo will look for users with National Medal in some year and some award in the year 1975, but not for users with National Medal in 1975.

See MongoDB $elemMatch Documentation for more info. See Read Operations Documentation for more information about querying documents with arrays.

More Related Contents:

  1. MongoDB select where in array of _id?
  2. How to properly reuse connection to Mongodb across NodeJs application and modules
  3. MongoDB, remove object from array
  4. Render basic HTML view?
  5. How do I remove documents using Node.js Mongoose?
  6. UnhandledPromiseRejectionWarning: MongooseServerSelectionError
  7. How to get updated document back from the findOneAndUpdate method?
  8. Can I determine if a string is a MongoDB ObjectID?
  9. Handlebars: Access has been denied to resolve the property “from” because it is not an “own property” of its parent
  10. Writing to files in Node.js
  11. Updating a Nested Array with MongoDB
  12. Issue in returning data retrieved from DB queries called in the loop
  13. How to enable cors nodejs with express?
  14. JavaScript, Node.js: is Array.forEach asynchronous?
  15. Check if every element in one array is in a second array
  16. How to get a URL parameter in Express?
  17. Failed to load c++ bson extension
  18. Function to convert timestamp to human date in javascript [duplicate]
  19. Express js form data
  20. Accessing EJS variable in Javascript logic
  21. What is the right way to make a synchronous MongoDB query in Node.js?
  22. Accessing Express.js local variables in client side JavaScript
  23. Node.js request CERT_HAS_EXPIRED
  24. Cannot find module ‘../build/Release/bson’] code: ‘MODULE_NOT_FOUND’ } js-bson: Failed to load c++ bson extension, using pure JS version
  25. Mongoose stopped accepting callbacks for some of its functions
  26. configure node express to serve static bower_components?
  27. require(‘babel/register’) doesn’t work
  28. Express: Setting content-type based on path/file?
  29. how to use jQuery installed with npm in Express app?
  30. Group by Date with Local Time Zone in MongoDB

Leave a Comment