Trying to retrieve a list of todos based on the 'userId' associated with each one is proving difficult. The code below does not return any rows:
DB.TodoTable.find({ "userId" : ObjectId("54c12f5f3620c07019e6b144") }, function(err, todos) {
if (err) return console.error(err);
console.dir(todos);
})
When examining the mongoose debug output, it shows:
Mongoose: todos.find({ userId: undefined }) { fields: undefined }
[]
Interestingly, when attempting the same query in the mongo shell, it works without issue. Here is an example result from the shell:
> db.todos.find()
{ "_id" : ObjectId("54c12f643620c07019e6b145"), "created_at" : ISODate("2015-01-22T17:12:04.932Z"), "userId" : ObjectId(
"54c12f5f3620c07019e6b144"), "text" : "data", "__v" : 0 }
The database schema looks like this:
var TodoTable = mongoose.model('todos', {
text : {type : String, default: ''},
created_at : Date,
userId : {type:ObjectId, ref:'users'}
});
var UserTable = mongoose.model('users', {
username: String,
password: String,
email: String,
gender: String,
address: String
});