Can't find any entries in non-empty MongoDB collection

Question

I have this schema:

var mongoose = require('mongoose');
var Schema = mongoose.Schema;   

var UsersCoursesSchema = new Schema({
      _User: {
        type: Schema.Types.ObjectId,
        ref: 'Users'
      },
      _Course: {
        type: Schema.Types.ObjectId,
        ref: 'Courses'
      }
    });

And this document in MongoDB:

But when I try to run this query, I get an empty array as a result:

var mongoose = require('mongoose');
var UsersCourses = mongoose.model('UsersCourses');

exports.getUserCourses = function(req, res) {
    UsersCourses.find({}, function(err, userCourses) {
        if (err)
            res.send(err);

        res.json(userCourses);

    });
};

Why?

I saw it that way somewhere else. And also I implemented an another GET, just on a different table, but with the same syntax as here... and it works. — Tudvari, Nov 17 '18 at 16:34

score 0 · Answer 1 · answered Nov 17 '18 at 16:50

0

try adding your _userId key inside double quotes and removing new as follows:

exports.getUserCourses = function(req, res) {
UserCourses.find({"_User": ObjectId("5bef2b759d8e490944af9e96")}, function(err, userCourses) {
    });
};

also try with this shortcut:

exports.getUserCourses = function(req, res) {
UserCourses.find(ObjectId("5bef2b759d8e490944af9e96"), function(err, userCourses) {
    });
};

this should works.

answered Nov 17 '18 at 16:50

vitomadio

1,140
8
14

I updated the original post because my issue isn't derived from the query filter parameters, but from somewhere else. – Tudvari Nov 17 '18 at 17:05

Can't find any entries in non-empty MongoDB collection

1 Answers1