MongoDB: How to check is user in array

Question

I've got a problem. I'm creating a question to MongoDB:

const team: TeamDocument = await Team.findOne({ members: payload.id, name })

The problem is, members is an array of objects:

members: [{
    name: { type: Schema.Types.ObjectId, ref: 'User' },
    role: String
}]

So when I create ask, it showes an error:

UnhandledPromiseRejectionWarning: ObjectParameterError: Parameter "obj" to Document() must be an object, got 5e88984b1478de32f43289e8

How can I repair this, so it will check if the members array has an object which contains an id provided in payload?

Ramesh Reddy · Accepted Answer · 2020-04-04 20:35:24Z

1

If you have a single query you don't even need to use $elemMatch, you can just use:

const team: TeamDocument = await Team.findOne({ "members.name": payload.id })

answered Apr 4, 2020 at 20:35

Ramesh Reddy

10.7k3 gold badges22 silver badges38 bronze badges

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

Comments

Thalaivar Subu · Accepted Answer · 2020-04-04 17:10:58Z

1

const team: TeamDocument = await Team.findOne({ members: { id: payload.id, name:name } })

answered Apr 4, 2020 at 17:10

Thalaivar Subu

211 bronze badge