mongooseJS find docs with IDs in an array

Question

I need to pull back documents that have ID stored in an array of ObjectIds so I have an "id" (123) and I want all the DOcs where the "tenants" have an array element of (123)

Data looks like this

{
  "_id": ObjectId("abc"),
  "name": "Miroslav",
  "tenants": [
    ObjectId("123"),
    ObjectId("456")
  ]
}

{
  "_id": ObjectId("abd"),
  "name": "Lothar",
  "tenants": [
    ObjectId("123"),
    ObjectId("694")
  ]
}

of course the mongoDB systax

things.find( { 'tenants': ObjectId(123) } )

works just fine.

Mongoose complains

ReferenceError: ObjectId is not defined

So I tried this

things.find( { 'tenants': mongoose.Schema.ObjectId(123) } )

And in a bazaar twist, mongoose returned ALL records EXCEPT the 2 expected.

I've seen this question posted 3 years ago, and that post didn't have an answer, hopefully someone here will have a solution.

Im using "mongoose": "4.9.8" (due to a specific 'promise' issue I cannot go up a version, at the moment)

thx

The tenants are the users - parent/child relationship...the tenant IDs refer to the _id of a different document. — j-p
– j-p, Commented Jan 29, 2018 at 10:54
try this: things.find( { tenants: mongoose.Types.ObjectId("123") } ) — Rakan
– Rakan, Commented Jan 29, 2018 at 11:32

Rakan · Accepted Answer · 2018-01-29 20:08:37Z

5

to convert to ObjectId you need to use:

things.find({tennants: mongoose.Types.ObjectId("123")});

the difference between mongoose.Schema.ObjectId and mongoose.Types.ObjectId is that the latter is the ObjectId constructor function. it can even be used like:

var id = new mongoose.Types.ObjectId("123");

to create an objectId and store it in the id variable.

while mongoose.Schema.ObjectId (or mongoose.Schema.Types.ObjectId) refers to a data type. that's what you'd use in your schema. the same way you might set

name: String

in a schema, you use mongoose.Schema.Types.ObjectId to specify that the data type is a mongoose ObjectId.

note: I remember reading this in the docs a few months ago, but i was unable to find the docs now, i think my explanation is fairly adequate though

answered Jan 29, 2018 at 20:08

Rakan

4002 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

j-p Over a year ago

adequate enough for me to know what Im reading as I go digging. Thank you.

j-p · Accepted Answer · 2018-01-29 19:21:07Z

0

rakan316 wrote -

try this: things.find( { tenants: mongoose.Types.ObjectId("123") } )

And that worked...

rakan316, if you post this as an answer, I'll make it as correct, and up vote it. Thx, I'd like to know WHY, if you know.

answered Jan 29, 2018 at 19:21

j-p

3,8489 gold badges58 silver badges97 bronze badges

1 Comment

Rakan Over a year ago

give me a second to find the docs again, then I'll post a full answer

masterchinchilla · Accepted Answer · 2024-06-13 20:14:50Z

I was having trouble with this, that is, finding documents using mongoose where I needed to filter by a property array containing a specific ObjectId.

For example, to find "meal" documents per mealType where:

const someMealDocument = {
    _id: abc123
    mealType: [ someObjectId1, someObjectId2 ]
}

I am using mongoose 9.5.1. The above answers seem to not work with my later version of mongoose.

What eventually worked for me was this syntax:

let thisMealTypeId="someString";
MealModel.find({
     mealType: thisMealTypeId
})

Just that, no "mongoose.Types.ObjectId," no "$in," no other complexity.

I couldn't find this answer anywhere so I figured it out by long trial and error. Hopefully posting this here will save someone else from having to do that.

Collectives™ on Stack Overflow

mongooseJS find docs with IDs in an array

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related