Find after populate mongoose

by

@Jason Cust explained it pretty well already – in this situation often the best solution is to alter the schema to prevent querying Users by properties of documents stored in separate collection.

Here’s the best solution I can think of that will not force you to do that, though (because you said in the comment that you can’t).

Users.find().populate({
  path: 'email',
  match: {
    type: 'Gmail'
  }
}).exec(function(err, users) {
  users = users.filter(function(user) {
    return user.email; // return only users with email matching 'type: "Gmail"' query
  });
});

What we’re doing here is populating only emails matching additional query (match option in .populate() call) – otherwise email field in Users documents will be set to null.

All that’s left is .filter on returned users array, like in your original question – only with much simpler, very generic check. As you can see – either the email is there or it isn’t.

More Related Contents:

  1. Updating a Nested Array with MongoDB
  2. Mongoose and multiple database in single node.js project
  3. MongoDB, remove object from array
  4. How do I update/upsert a document in Mongoose?
  5. Mongoose find/update subdocument
  6. Mongoose, Select a specific field with find
  7. How to sort in mongoose?
  8. Mongoose difference between .save() and using update()
  9. Bulk upsert in MongoDB using mongoose
  10. UnhandledPromiseRejectionWarning: MongooseServerSelectionError
  11. Mongoose subdocuments vs nested schema
  12. Why is an _id with ObjectID added to when using MongoDB’s $push to add new object to an array?
  13. How to set _id to db document in Mongoose?
  14. What is a TransientTransactionError in Mongoose (or MongoDB)?
  15. Mongoose.js: Find user by username LIKE value
  16. Server Discovery And Monitoring engine is deprecated
  17. Mongoose Not Creating Indexes
  18. is there a mongoose connect error callback
  19. MongooseServerSelectionError: connect ECONNREFUSED ::1:27017
  20. Node.js mongodb driver async/await queries
  21. What is the difference between id and _id in mongoose?
  22. JavaScript NoSQL Injection prevention in MongoDB
  23. Group by Date with Local Time Zone in MongoDB
  24. MongooseError: Model.findOne() no longer accepts a callback at Function
  25. Mongoose find() not returning result
  26. How to search in array of object in mongodb
  27. batchSize field name ignored in Field Projection
  28. Trying to hash a password using bcrypt inside an async function
  29. Multiple schema references in single schema array – mongoose
  30. Random document from a collection in Mongoose

Leave a Comment