Populate a mongoose model with a field that isn’t an id

by

This is supported since Mongoose 4.5, and is called virtuals population.

You have to define your foreign keys relationships after your schemas definitions and before creating models, like this:

// Schema definitions

BookSchema = new mongoose.Schema({
        ...,
        title: String,
        authorId: Number,
        ...
    },
    // schema options: Don't forget this option
    // if you declare foreign keys for this schema afterwards.
    {
        toObject: {virtuals:true},
        // use if your results might be retrieved as JSON
        // see http://stackoverflow.com/q/13133911/488666
        //toJSON: {virtuals:true} 
    });

PersonSchema = new mongoose.Schema({id: Number, ...});


// Foreign keys definitions

BookSchema.virtual('author', {
  ref: 'Person',
  localField: 'authorId',
  foreignField: 'id',
  justOne: true // for many-to-1 relationships
});


// Models creation

var Book = mongoose.model('Book', BookSchema);
var Person = mongoose.model('Person', PersonSchema);


// Querying

Book.find({...})
    // if you use select() be sure to include the foreign key field !
    .select({.... authorId ....}) 
    // use the 'virtual population' name
    .populate('author')
    .exec(function(err, books) {...})

More Related Contents:

  1. Push items into mongo array via mongoose
  2. E11000 duplicate key error index in mongodb mongoose
  3. Mongoose: findOneAndUpdate doesn’t return updated document
  4. Mongoose populate vs object nesting
  5. Stop Mongoose from creating _id property for sub-document array items
  6. Populate nested array in mongoose
  7. Why does mongoose always add an s to the end of my collection name
  8. Cannot overwrite model once compiled Mongoose
  9. Mongoose Schema hasn’t been registered for model
  10. add created_at and updated_at fields to mongoose schemas
  11. Mongoose findByIdAndUpdate not returning correct model
  12. Mongoose duplicate key error with upsert
  13. Mongoose (mongodb) batch insert?
  14. How can I use a cursor.forEach() in MongoDB using Node.js?
  15. Mongoose update without callback
  16. Model.find().toArray() claiming to not have .toArray() method
  17. Mongoose optional search query parameters?
  18. Difference between MongoDB and Mongoose
  19. How can I save multiple documents concurrently in Mongoose/Node.js?
  20. Model.find() returns empty in mongoose [duplicate]
  21. log all queries that mongoose fire in the application
  22. Combine two OR-queries with AND in Mongoose
  23. Which SchemaType in Mongoose is Best for Timestamp?
  24. Mongoose – finding subdocuments by criteria
  25. Mongoose: ObjectId Comparisons fail inconsistently
  26. Mongoose multiple connections
  27. set field as empty for mongo object using mongoose
  28. Mongoose overwrite the document rather that `$set` fields
  29. Mongodb $lookup dynamic collection
  30. Create unique autoincrement field with mongoose [duplicate]

Leave a Comment