Mongoose Find subdocument in array

Question

I have the following data in Robo3t Mongo collection With this model:

const eleccionSchema = new mongoose.Schema({
    e: [{
        id: {
            type: String,
            required: true
        },
        l:[...]
    }],
    eleccion: {
        type: Number,
        required: true,
        ref: 'Corte'
    }
})
//? Create the model
const Eleccion = mongoose.model('Eleccion', eleccionSchema)

Right now I'm trying to fetch some data based on e.id like this

const eleccion = await Eleccion.findOne({'e.id':'A'})

But it's actually returning the whole array instead of just one output

Valijon · Accepted Answer · 2020-01-09 19:44:07Z

1

Fixed it with a projection: https://docs.mongodb.com/manual/reference/operator/projection/elemMatch/

const eleccion = await Eleccion.findOne({}, {
 'e':
   { $elemMatch: { id: 'A' } }
})

edited Jan 9, 2020 at 19:44

Valijon

13.2k4 gold badges40 silver badges74 bronze badges

answered Jan 9, 2020 at 19:42

Jeremy

1,7551 gold badge30 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

Mongoose Find subdocument in array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related