Array update with positional $ operator in MongoDB - Step-by-Step Execution

Concept Flow - Array update with positional $ operator

Find document matching query

↓

Locate array element matching condition

↓

Use positional $ operator to target element

↓

Update the targeted array element

↓

Save document

This flow shows how MongoDB finds a document, locates the matching array element using the positional $ operator, updates it, and saves the document.

Execution Sample

MongoDB

db.students.updateOne(
  { "grades.grade": 85 },
  { $set: { "grades.$.grade": 90 } }
)

This updates the first array element in 'grades' with grade 85 to have grade 90.

Execution Table

Step	Query Condition	Array Element Checked	Match Found?	Update Action	Document State After Step
1	{"grades.grade": 85}	grades[0] = {grade: 80}	No	No update	{"grades": [{"grade": 80}, {"grade": 85}, {"grade": 88}]}
2	{"grades.grade": 85}	grades[1] = {grade: 85}	Yes	Update grades[1].grade to 90	{"grades": [{"grade": 80}, {"grade": 90}, {"grade": 88}]}
3	N/A	N/A	N/A	Update complete	{"grades": [{"grade": 80}, {"grade": 90}, {"grade": 88}]}

💡 Update stops after first matching array element is updated using positional $ operator.

Variable Tracker

Variable	Start	After Step 1	After Step 2	Final
Document grades array	[{grade:80}, {grade:85}, {grade:88}]	Same	[{grade:80}, {grade:90}, {grade:88}]	[{grade:80}, {grade:90}, {grade:88}]
Matched array index	None	None	1	1

Key Moments - 3 Insights

Why does only the first matching array element get updated?

Because the positional $ operator targets only the first array element that matches the query condition, as shown in execution_table row 2.

What happens if no array element matches the condition?

No update occurs; the document remains unchanged, as shown in execution_table row 1 where no match is found.

Can the positional $ operator update multiple elements at once?

No, it updates only the first matching element. To update multiple elements, other operators like $[] are needed.

Visual Quiz - 3 Questions

Look at the execution_table, what is the value of grades[1].grade after Step 2?

A 85

B 80

C 90

D 88

💡 Hint

Check the 'Document State After Step' column in row 2.

At which step does the positional $ operator apply the update?

A Step 2

B Step 1

C Step 3

D No update applied

💡 Hint

Look at the 'Update Action' column to see when the update happens.

If the query was {"grades.grade": 100}, what would happen?

A grades[1].grade updates to 90

B No array element matches, no update

C All grades updated to 90

D Error occurs

💡 Hint

Refer to key_moments about no matching element scenario.

Concept Snapshot

MongoDB positional $ operator updates the first array element matching the query.
Syntax: { $set: { "arrayField.$.field": value } }
Only the first matching element is updated.
If no match, no update occurs.
Use for precise array element updates inside documents.

Full Transcript

This visual execution shows how MongoDB updates an array element using the positional $ operator. First, it finds the document with an array element matching the query condition. Then it locates the first matching element in the array. Using the positional $ operator, it updates that element's field. The update stops after the first match. If no element matches, no update happens. This operator is useful for updating one specific array element inside a document.