Mongoose nested query on Model by field of its referenced model

by

You can’t do this in a single query because MongoDB doesn’t support joins. Instead, you have to break it into a couple steps:

// Get the _ids of people with the last name of Robertson.
Person.find({lastname: 'Robertson'}, {_id: 1}, function(err, docs) {

    // Map the docs into an array of just the _ids
    var ids = docs.map(function(doc) { return doc._id; });

    // Get the companies whose founders are in that set.
    Company.find({founder: {$in: ids}}, function(err, docs) {
        // docs contains your answer
    });
});

More Related Contents:

  1. Querying after populate in Mongoose
  2. Populate nested array in mongoose
  3. Cannot overwrite model once compiled Mongoose
  4. Comparing mongoose _id and strings
  5. Mongoose Unique values in nested array of objects
  6. Mongoose Schema hasn’t been registered for model
  7. Mongoose findByIdAndUpdate not returning correct model
  8. Mongoose duplicate key error with upsert
  9. How to protect the password field in Mongoose/MongoDB so it won’t return in a query when I populate collections?
  10. How can I use a cursor.forEach() in MongoDB using Node.js?
  11. Fill missing dates in records
  12. Mongoose, find, return specific properties
  13. How to drop a database with Mongoose?
  14. How to use mongoose findOne
  15. Mongoose indexing in production code
  16. Model.find().toArray() claiming to not have .toArray() method
  17. Mongoose optional search query parameters?
  18. Mongodb sort with case insensitive manner
  19. Difference between MongoDB and Mongoose
  20. How can I save multiple documents concurrently in Mongoose/Node.js?
  21. Fail to connect Mongoose to Atlas
  22. Which SchemaType in Mongoose is Best for Timestamp?
  23. nodejs mongodb object id to string
  24. Mongoose: ObjectId Comparisons fail inconsistently
  25. Mongoose multiple connections
  26. set field as empty for mongo object using mongoose
  27. Mongoose overwrite the document rather that `$set` fields
  28. Mongodb $lookup dynamic collection
  29. Mongoose complex (async) virtuals
  30. Create unique autoincrement field with mongoose [duplicate]

Leave a Comment