MongoDB查询工作但不支持Mongoose(MongoDB query work but not with Mongoose)

 我正在尝试用Mongoose查询集合，有一个简单的db.course.find()查询的集合示例输出 
 
{
  "_id" : ObjectId("581c9408fc01b15cb21043e4"),
  "calendar_id" : DBRef("calendar", ObjectId("581c5972fd1c59295c34f1b8"), "ecampus"),
  "date" : 1478473200000,
  "title" : "Conception et planification BI",
  "teacher" : "fiolet gilles",
  "start_at" : "08:30",
  "end_at" : "12:30"
}
 
 我有一个运行良好的MongoDB查询 
 
db.course.find({'calendar_id.$id': ObjectId("581c5972fd1c59295c34f1b8")}).sort({date: 1})
 
 我试图用Mongoose做同样的查询，在我的NodeJS应用程序中我做了这个查询，但是这个返回一个空数组，因为ObjectId不正常。 
 
let mongoose = require('mongoose');
let ObjectId = mongoose.Types.ObjectId;
let id = new ObjectId(session.calendar_id);

Course.find({'calendar_id.$id': id}).sort({date: 1}).exec(function (err, courses) {
    console.log(err, courses);
    createJsonBody(courses);
});
 
 Course来自我的模型文件，就像这样 
 
const Course = mongoose.model('course', {
    calendar_id: Schema.ObjectId,
    date: Number,
    title: String,
    teacher: String,
    start_at: String,
    end_at: String
});
 
 如何使这个Mongoose查询起作用？ 该模型可能没有正确形成？ 

I'm trying to query a collection with Mongoose, there is the collection sample output with a simple db.course.find() query
 
{
  "_id" : ObjectId("581c9408fc01b15cb21043e4"),
  "calendar_id" : DBRef("calendar", ObjectId("581c5972fd1c59295c34f1b8"), "ecampus"),
  "date" : 1478473200000,
  "title" : "Conception et planification BI",
  "teacher" : "fiolet gilles",
  "start_at" : "08:30",
  "end_at" : "12:30"
}
 
I have a MongoDB query that work well
 
db.course.find({'calendar_id.$id': ObjectId("581c5972fd1c59295c34f1b8")}).sort({date: 1})
 
I am trying to do the same query with Mongoose, in my NodeJS app I made this query but this one return an empty array because the ObjectId is not working well.
 
let mongoose = require('mongoose');
let ObjectId = mongoose.Types.ObjectId;
let id = new ObjectId(session.calendar_id);

Course.find({'calendar_id.$id': id}).sort({date: 1}).exec(function (err, courses) {
    console.log(err, courses);
    createJsonBody(courses);
});
 
Course is from my model file and is like this
 
const Course = mongoose.model('course', {
    calendar_id: Schema.ObjectId,
    date: Number,
    title: String,
    teacher: String,
    start_at: String,
    end_at: String
});
 
How can I make this Mongoose query to work ? The model is maybe not properly formed ?

原文：https://stackoverflow.com/questions/40842155