How to push inside nested array of object that have a precise value of a key in MongoDB?

Question

I have one question about a problem that I'm not able to fix. I try to update push a string passed via Query in my mongoose collection. My collection are like this:

    {
        "_id": {
            "$oid": "6199288597e42bf84d017f9e"
        },
        "name": "Lisa",
        "surname": "Bianchi",
        "ID_school": "afbH598U3",
        "classes": [
            {
                "class": "5A",
                "activities": {
                    "in_progress": [],
                    "finisched": []
                },
                "_id": {
                    "$oid": "6199288597e42bf84d017f9f"
                }
            },
            {
                "class": "1A",
                "activities": {
                    "in_progress": [],
                    "finisched": []
                },
                "_id": {
                    "$oid": "6199288597e42bf84d017fa0"
                }
            }
        ],
        "email": "[email protected]",
        "__v": 0
    }

and I try to push a string in in_progress array that match, for example, with class:"5A" using this way:

    import db from "../models/index.js";
    
    const Teacher = db.teacher
    
    const updateActivity = (req, res) => {
        const query = { _id: req.query.id};
        const update =  {$push:{'classes.$[group].activities.in_progress': req.query.data } };
        const options = {arrayFilters: { 'group.class': req.query.class }};
    
        Teacher.findOneAndUpdate(query, update, options).exec((err, data) => {
            if (err) {
                res.status(400).send({ message: err });
                return;
            } else {
                res.status(200).send(data);
            }
        })
    }
    
    const API = {
        updateActivity
    }
    
    export default API

The query works fine, but nothing was pushed. I tested whit Insomnia passing in the Query field

    id = 6199288597e42bf84d017f9e;
    class:'5A';
    data:"pushed"

Any suggestion? Thanks!

Saurabh Mistry · Accepted Answer · 2021-12-05 18:50:54Z

2

try this way by passing classes.class in query and also change push to $push:{'classes.$.activities.in_progress': req.query.data }

 const updateActivity = (req, res) => {
    const query = { _id: req.query.id ,'classes.class': req.query.class};
    const update =  {$push:{'classes.$.activities.in_progress': req.query.data } };

    Teacher.updateOne(query,update).exec((err, data) => {
        if (err) {
            res.status(400).send({ message: err });
            return;
        } else {
            res.status(200).send(data);
        }
    })
}

answered Dec 5, 2021 at 18:50

Saurabh Mistry

13.8k5 gold badges60 silver badges78 bronze badges

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

2 Comments

RootAtKali Over a year ago

This solution doesn't push in array in_progress yet, the query works fine (200 OK).

RootAtKali Over a year ago

Resolved, your query was good, I have a problem in my Mongoose Model. Thanks!

MarcRo · Accepted Answer · 2021-12-05 19:27:30Z

1

There are two ways of doing this:

Option 1: `arrayFilters` - more flexible Docu

The option you are using. You have a syntax error - arrayFilters should be an array of documents.

const updateActivity = (req, res) => {
  const query = { _id: req.query.id };
  const update = {
    $push:{ 'classes.$[group].activities.in_progress': req.query.data }
  };

  // This MUST be an array of filter documents!
  const options = { arrayFilters: [{ 'group.class': req.query.class }] };
    
  Teacher
    .findOneAndUpdate(query, update, options)
    .exec((err, data) => {
      if (err) {
        res.status(400).send({ message: err });
        return;
      } else {
        res.status(200).send(data);
      }
    });
}

Option 2: Via Query (as answered by @Saurabh Mistry)

Repeating his answer for completeness

By specifying a query that targets a particular element in an array within result documents.

const updateActivity = (req, res) => {
  const query = {
    _id: req.query.id,
    'classes.class': req.query.data,
  };
  const update = {
    $push:{ 'classes.$.activities.in_progress': req.query.data }
  };

  Teacher
    .findOneAndUpdate(query, update, options)
    .exec((err, data) => {
      if (err) {
        res.status(400).send({ message: err });
        return;
      } else {
        res.status(200).send(data);
      }
    });
}

answered Dec 5, 2021 at 19:27

MarcRo

2,4731 gold badge11 silver badges24 bronze badges

2 Comments

RootAtKali Over a year ago

thank! the two solutions work fine (200 OK ) but do not push in in_progress array yet. I don't know why.

RootAtKali Over a year ago

Resolved, your query was good, I have a problem with my Mongoose Model. Thanks!

Collectives™ on Stack Overflow

How to push inside nested array of object that have a precise value of a key in MongoDB?

2 Answers 2

2 Comments

Option 1: `arrayFilters` - more flexible Docu

Option 2: Via Query (as answered by @Saurabh Mistry)

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Option 1: arrayFilters - more flexible Docu

Option 2: Via Query (as answered by @Saurabh Mistry)

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related

Option 1: `arrayFilters` - more flexible Docu