Empresas
Empregos
  • Sobre nós
  • Soluções
    • Publicação de vagas
      Publique sua vaga e receba candidatos qualificados em 48h.
    • Avaliações de candidatos
      Mais de 500 testes técnicos e psicológicos, mais anti-fraude.
    • Headhunting
      Busca executiva personalizada do início ao fim.
    • Folha de Pagamento + EOR
      Dispersão de folha e EOR em mais de 15 países da LATAM.
  • Preços
  • Empregos

0

471
Visualizações
Mongoose - Can't push array in subdocument

I'm trying to update an array by pushing it through findOneAndUpdate but I can't get it to update:

This is the code with which I try to push but does not make any movement:

let pettyCashItem = await PettyCashItems.findOneAndUpdate({
    _id: id, 
    "items._id": idItem },
{
    $set: { 
        "items.$.concept": req.body.concept,
        "items.$.incomeAmount": req.body.incomeAmount,
        "items.$.description": req.body.description,
        "items.$.expenseAmount": req.body.expenseAmount
        $push: {
            'items.$.lastModificationBy': {
                "uid": req.uid,
                "username": req.user.username,
                "comments": req.body.comments
            }
        }
    }
}, { new: 'true'});

This is my model:

const PettyCashItemsSchema = Schema (
  {
    items:[{
        concept: {
            type: String,
            maxlength:50,
            required: [true, 'El Concepto es obligatorio']
        },
        incomeAmount:{
            type: Number,
            maxlength:50,
            default:0,
            required: [true, 'El Ingreso es obligatorio']
        },
        expenseAmount:{
            type: Number,
            maxlength:50,
            default:0,
            required: [true, 'El Egreso es obligatorio']
        },
        description: {
            type: String,
            maxlength:50,
            required: [true, 'La Observación es obligatoria']
        },
        status: {
            type: Boolean,
            default: true,
            required: [true, 'El Estatus es obligatorio']
        },
        createdAt: {
            type: Date,
            default: Date.now
        },
        lastModificationBy: [{
            uid:{
                type: String,
                required:true
            },
            username:{
                type: String,
                required:true
            },
            date:{
                type: Date,
                default: Date.now
            },
            comments: {
                type: String,
                maxlength:300,
                required: [true, 'El Comentario es obligatorio']
            }
        }]
    }]

The update using $set for the other objects is correct but when trying to do a $push in the array this never works.

Thanks.

about 4 years ago · Juan Pablo Isaza
1 Respostas
Responde à pergunta

0

Try placing $push at same level with $set instead of inner level of $set.

let pettyCashItem = await PettyCashItems.findOneAndUpdate({
    _id: id, 
    "items._id": idItem },
{
    $set: { 
        "items.$.concept": req.body.concept,
        "items.$.incomeAmount": req.body.incomeAmount,
        "items.$.description": req.body.description,
        "items.$.expenseAmount": req.body.expenseAmount
    },
    $push: {
        'items.$.lastModificationBy': {
            "uid": req.uid,
            "username": req.user.username,
            "comments": req.body.comments
        }
    }
}, { new: 'true'});

Sample Mongo Playground (Query)

about 4 years ago · Juan Pablo Isaza Relatório
Responde à pergunta
Encontrar trabalhos remotos

Descubra a nova forma de encontrar um emprego!

melhores empregos
Principais categorias de trabalho
Empresas
Postar vaga Preços Comercial
Jurídico
Termos e Condições Política de privacidade
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Recomende algumas ofertas para mim
Preciso de ajuda