Updating an array within an object using JSON

Question

Updating an array within an object using JSON

Check out the structure of my JSON response:

"_id" : 537,
    "quizzes" : [
        {
            "wk" : 1,
            "score" : [
                10
            ]
        },
        {
            "wk" : 2,
            "score" : [
                8
            ]
        },
        {
            "wk" : 3,
            "score" : [
                5
            ]
        },
        {
            "wk" : 4,
            "score" : [
                6
            ]
        }
    ]
}

I'm attempting to make changes to the score array within one of the objects. Take a look at what I've done:

db.collection('connect').update({_id: id}, {$push: { quizzes[0]: { score: 89  }  }});

javascript json mongodb

Answer 1

Answer №1

Here is the suggested update to try:

db.collection("connect").update(
    {
        "_id": id            
    }, 
    {
        "$set": { 
            "quizzes.0.score.0": 89    
        }
    }
);

This approach utilizes the dot notation for accessing array elements and fields within an embedded document.

To access a specific element in an array using its zero-based index, simply concatenate the array name with a dot (.) followed by the zero-based index surrounded by quotes:

'<array>.<index>'

Answer 2

Here is the suggested update to try:

db.collection("connect").update(
    {
        "_id": id            
    }, 
    {
        "$set": { 
            "quizzes.0.score.0": 89    
        }
    }
);

This approach utilizes the dot notation for accessing array elements and fields within an embedded document.

To access a specific element in an array using its zero-based index, simply concatenate the array name with a dot (.) followed by the zero-based index surrounded by quotes:

'<array>.<index>'

Answer 3

Answer №2

It appears that you are searching for

db.collection('connect').update({_id: id}, {$set: { "quizzes.0.score":89}  })

An improved approach would be to avoid relying on the index of the quizzes array and utilize the "wk" attribute instead

db.collection('connect').update({_id: id,quizzes:{$elemMatch:{"wk":1}}}, {$set: { quizzes.$.score: 89  }  }})

Answer 4

It appears that you are searching for

db.collection('connect').update({_id: id}, {$set: { "quizzes.0.score":89}  })

An improved approach would be to avoid relying on the index of the quizzes array and utilize the "wk" attribute instead

db.collection('connect').update({_id: id,quizzes:{$elemMatch:{"wk":1}}}, {$set: { quizzes.$.score: 89  }  }})

Updating an array within an object using JSON

Answer №1

Answer №2

Similar questions

experimenting with a TypeScript annotation

Implementing Partial Login and Registration Views using AngularJS in conjunction with MVC5 and ASP.NET Identity

Using Regular Expressions in JavaScript to verify if an element from an array is contained within a string

Restoring the position of the <Rect/> element after dragging in a React + Konva application

Learn the method of conditionally resetting the state count using React hooks

JavaScript Regular Expression for separating a collection of email addresses into individual parts

Establishing global date restrictions for the DatePicker component in Angular 8 using TypeScript across the entire application

Load components in NextJS lazily without utilizing `next/dynamic`

What steps should I follow to enable a tooltip in this specific situation using qtip?

onpageshow event behaves as expected exclusively on webkit browsers (triggers function solely when visible on the screen)

Are HTML's Regular Expressions the Equivalent of JavaScript's Regular Expressions?

The signin callback in NextAuth doesn't seem to be activating as expected

Ways to retrieve the identifiers of every child node UL element within a UL container

Add a new component to a Vue.js instance that is already in use

Breaking circular dependencies in JavaScript is a common challenge that developers face when

There was an error parsing the data from the specified URL (http://localhost:8000/src/client/assets/data.json

What is the size limit for JSON requests in Node.js?

Ways to insert a line break within a jQuery function using text()

Searching and adding new elements to a sorted array of objects using binary insertion algorithm

Locate all the properties that are empty within each object contained in a JavaScript array