Query Mongoose Schema by ObjectId

Question

Going to need your help again, hopefully for this project, the answer to what I'm having here will be the last. I've seen it's a fairly commonly asked question, but I've tried the tips on another Stack Overflow post, and one by the Google Group, but the solutions haven't worked for me.

My code being a little bit like:

mongoose = require('mongoose');
Schema = mongoose.Schema;
mongoose.connect(MONGO_SERVER);
ObjectId = Schema.ObjectId;

var RacesSchema = new Schema({
    venue_id        : { type: mongoose.Schema.ObjectId, ref: 'Venues' },
    racetype            : String
});
var races = mongoose.model('Races', RacesSchema );

function test() {
    var MyObjectId = require('mongoose').Types.ObjectId;
    queryVenue = new MyObjectId("50e3dcdbf30375180c078f64");

    races.find({venue_id: queryVenue, racetype:'Test'})
    .exec(function(err,data) {
}

test();

But I get no results, which I know there is.

Many thanks in advance!

UPDATE

Have minimized the above code sample, this test works if I query the string value on its own, just querying for an ObjectId is where it fails, and I know it exists.

JSON UPDATE

Here is what I am looking for:

{
    "_id" : ObjectId("50e3dcddf30375180c078f85"),
    "venue_id" : "50e3dcdbf30375180c078f64",
    "racetype" : "A"
}

And all of a sudden, I believe my answer has become clear to me. Is it simply because the venue_id is actually a string? And if so, can I keep my mongoose schema the way it is, and do casting on the query at the point of doing the find of being a string? Or should I change the way these values are being stored (from a separate .net application I developed) to be inserted as ObjectId's?

Currently right now for another query, the current mongoose schema and the way the database is [actually set up], using populate() works quite well to fill the results of the referenced table (venue_id) with the way this model is currently set up, only difference being on the above query, I don't specify the venue_id...

Thanks.

Can you provide a minimal example that reproduces the problem? Without the docs and the `obj.venue_id` value you're using it's going to be tough to help. — JohnnyHK, Feb 21 '13 at 14:42
Can you also show the JSON for the doc you're trying to find? — JohnnyHK, Feb 22 '13 at 13:48

score 3 · Accepted Answer · answered Feb 23 '13 at 13:52

3

Right, the problem is happening because the data type of venue_id in the schema (ObjectId) doesn't match the one in the doc (String). So the find is looking for ObjectId values but doesn't find a match because it's a string in the doc.

The right fix for this is to write a little program to update the venue_id values in your docs to be ObjectIds instead of strings and then your query will work. That will also shrink the size of those fields from 24 bytes to 12.

answered Feb 23 '13 at 13:52

JohnnyHK

305,182
66
621
471

To add to this, I believe that when the mongoose schema specifies a value type as `Schema.Types.ObjectId` then it will cast a string as that type when the query is actually executed. – Doug Molineux Apr 28 '14 at 17:12

Query Mongoose Schema by ObjectId

1 Answers1

Linked