Bird
Raised Fist0
MongoDBquery~5 mins

Array update with $[identifier] filtered in MongoDB

Choose your learning style10 modes available
Introduction

We use $[identifier] to update only certain items inside an array in a document. It helps change specific parts without touching everything.

You want to change the price of only some products in a shopping cart.
You need to mark only certain tasks as done in a list of tasks.
You want to update the status of specific orders in an order history.
You want to fix the score of only some players in a game leaderboard.
Syntax
MongoDB
db.collection.updateOne(
  { <filter> },
  { $set: { "arrayField.$[identifier].fieldToUpdate": newValue } },
  { arrayFilters: [ { "identifier.conditionField": conditionValue } ] }
)

The $[identifier] is a placeholder for array elements that match the filter in arrayFilters.

You must provide arrayFilters to tell MongoDB which array items to update.

Examples
Updates Alice's Math grade score to 95 only.
MongoDB
db.students.updateOne(
  { name: "Alice" },
  { $set: { "grades.$[elem].score": 95 } },
  { arrayFilters: [ { "elem.subject": "Math" } ] }
)
Marks only packed items as shipped in order 123.
MongoDB
db.orders.updateOne(
  { orderId: 123 },
  { $set: { "items.$[item].shipped": true } },
  { arrayFilters: [ { "item.status": "packed" } ] }
)
Sets all Horror genre books as unavailable in City Library.
MongoDB
db.library.updateOne(
  { name: "City Library" },
  { $set: { "books.$[book].available": false } },
  { arrayFilters: [ { "book.genre": "Horror" } ] }
)
Sample Program

This example creates a user John with hobbies. It updates only hobbies of type 'sports' to have level 'expert'.

MongoDB
db.users.insertOne({
  name: "John",
  hobbies: [
    { type: "sports", name: "soccer", level: "beginner" },
    { type: "music", name: "guitar", level: "intermediate" },
    { type: "sports", name: "tennis", level: "advanced" }
  ]
});

// Before update
printjson(db.users.findOne({ name: "John" }));

// Update only sports hobbies to level "expert"
db.users.updateOne(
  { name: "John" },
  { $set: { "hobbies.$[hobby].level": "expert" } },
  { arrayFilters: [ { "hobby.type": "sports" } ] }
);

// After update
printjson(db.users.findOne({ name: "John" }));
OutputSuccess
Important Notes

Time complexity depends on the number of array elements and the filter conditions.

Space complexity is minimal as only matching elements are updated.

Common mistake: forgetting to include arrayFilters causes no update or error.

Use $[identifier] when you want to update specific array elements. Use $ positional operator only if you update the first matching element.

Summary

$[identifier] lets you update specific items inside arrays.

You must use arrayFilters to tell MongoDB which items to update.

This helps avoid changing the whole array or wrong elements.

Practice

(1/5)
1. What does the $[identifier] syntax do in a MongoDB update operation?
easy
A. It updates only the array elements that match the filter specified in arrayFilters.
B. It deletes the entire array from the document.
C. It adds a new element to the array without any condition.
D. It replaces the whole document with a new one.

Solution

  1. Step 1: Understand $[identifier] usage

    The $[identifier] syntax is used to target specific elements inside an array during an update.
  2. Step 2: Role of arrayFilters

    The arrayFilters option specifies which array elements the $[identifier] refers to, so only those elements get updated.
  3. Final Answer:

    It updates only the array elements that match the filter specified in arrayFilters. -> Option A
  4. Quick Check:

    $[identifier] updates filtered array items [OK]
Hint: Remember: $[id] updates filtered array elements only [OK]
Common Mistakes:
  • Thinking $[identifier] updates the whole array
  • Confusing $[identifier] with $push or $set without filters
  • Ignoring the need for arrayFilters option
2. Which of the following is the correct syntax to update array elements using $[elem] with arrayFilters in MongoDB?
easy
A. db.collection.updateOne({},{ $set: { 'array.$[elem]': value } }, { arrayFilters: [ { 'elem.field': condition } ] })
B. db.collection.updateOne({},{ $push: { 'array.$[elem]': value } }, { arrayFilters: [ { 'elem.field': condition } ] })
C. db.collection.updateOne({},{ $set: { 'array.$elem': value } }, { arrayFilters: [ { 'elem.field': condition } ] })
D. db.collection.updateOne({},{ $set: { 'array.$[elem]': value } })

Solution

  1. Step 1: Identify correct update operator and syntax

    The $set operator is used to update existing fields. The positional filtered identifier must be inside square brackets like $[elem].
  2. Step 2: Confirm usage of arrayFilters

    The arrayFilters option must be provided with a filter object matching the identifier used inside $[elem].
  3. Final Answer:

    db.collection.updateOne({},{ $set: { 'array.$[elem]': value } }, { arrayFilters: [ { 'elem.field': condition } ] }) -> Option A
  4. Quick Check:

    Use $set with $[elem] and arrayFilters [OK]
Hint: Use $set with $[identifier] and arrayFilters together [OK]
Common Mistakes:
  • Using $push instead of $set for updates
  • Missing square brackets around identifier
  • Not providing arrayFilters option
3. Given the collection document:
{ _id: 1, scores: [ { type: 'quiz', score: 5 }, { type: 'exam', score: 8 }, { type: 'quiz', score: 7 } ] }

What will be the result of this update?
db.collection.updateOne({ _id: 1 }, { $set: { 'scores.$[elem].score': 10 } }, { arrayFilters: [ { 'elem.type': 'quiz' } ] })

What will the scores array look like after the update?
medium
A. [ { type: 'quiz', score: 5 }, { type: 'exam', score: 8 }, { type: 'quiz', score: 7 } ]
B. [ { type: 'quiz', score: 10 }, { type: 'exam', score: 10 }, { type: 'quiz', score: 10 } ]
C. [ { type: 'quiz', score: 10 }, { type: 'exam', score: 8 }, { type: 'quiz', score: 7 } ]
D. [ { type: 'quiz', score: 10 }, { type: 'exam', score: 8 }, { type: 'quiz', score: 10 } ]

Solution

  1. Step 1: Identify which array elements match the filter

    The filter { 'elem.type': 'quiz' } matches the first and third elements in the scores array.
  2. Step 2: Apply the update to matched elements only

    The score field of these matched elements is set to 10, while the second element remains unchanged.
  3. Final Answer:

    [ { type: 'quiz', score: 10 }, { type: 'exam', score: 8 }, { type: 'quiz', score: 10 } ] -> Option D
  4. Quick Check:

    Only 'quiz' type scores updated to 10 [OK]
Hint: Only elements matching arrayFilters get updated [OK]
Common Mistakes:
  • Updating all elements ignoring arrayFilters
  • Updating wrong elements by misreading filter
  • Expecting update without arrayFilters to work
4. You run this update:
db.collection.updateOne({ _id: 1 }, { $set: { 'items.$[i].status': 'sold' } }, { arrayFilters: [ { 'item.status': 'available' } ] })

But no documents are updated. What is the most likely cause?
medium
A. The $set operator cannot be used with $[i].
B. The query filter {_id: 1} is incorrect.
C. The identifier in arrayFilters does not match the one in the update query.
D. MongoDB does not support arrayFilters in updateOne.

Solution

  1. Step 1: Check identifier consistency

    The update uses $[i] but the arrayFilters uses item. These must match exactly.
  2. Step 2: Understand effect of mismatch

    Because the identifiers differ, MongoDB cannot apply the filter, so no elements are updated.
  3. Final Answer:

    The identifier in arrayFilters does not match the one in the update query. -> Option C
  4. Quick Check:

    Identifier names must match in update and arrayFilters [OK]
Hint: Match identifier names exactly in update and arrayFilters [OK]
Common Mistakes:
  • Using different names for identifier and filter variable
  • Assuming $set can't work with $[identifier]
  • Blaming query filter without checking arrayFilters
5. You have documents with an array field tasks where each task has status and priority. You want to update only tasks with status: 'pending' and priority greater than 5, setting their status to 'in-progress'. Which update command correctly does this?
hard
A. db.collection.updateMany({}, { $set: { 'tasks.$.status': 'in-progress' } }, { arrayFilters: [ { 't.status': 'pending', 't.priority': { $gt: 5 } } ] })
B. db.collection.updateMany({}, { $set: { 'tasks.$[t].status': 'in-progress' } }, { arrayFilters: [ { 't.status': 'pending', 't.priority': { $gt: 5 } } ] })
C. db.collection.updateMany({}, { $set: { 'tasks.$[t].status': 'in-progress' } }, { arrayFilters: [ { 't.status': 'pending' && 't.priority': { $gt: 5 } } ] })
D. db.collection.updateMany({}, { $set: { 'tasks.$[t].status': 'in-progress' } }, { arrayFilters: [ { 't.status': 'pending' }, { 'u.priority': { $gt: 5 } } ] })

Solution

  1. Step 1: Use a single filter object combining conditions

    The arrayFilters option must have one object combining both conditions with commas, meaning AND logic.
  2. Step 2: Use correct identifier and update syntax

    The update uses $[t] matching the filter identifier t, and $set to update the status field.
  3. Final Answer:

    db.collection.updateMany({}, { $set: { 'tasks.$[t].status': 'in-progress' } }, { arrayFilters: [ { 't.status': 'pending', 't.priority': { $gt: 5 } } ] }) -> Option B
  4. Quick Check:

    Combine conditions in one filter object with matching identifier [OK]
Hint: Combine multiple conditions in one arrayFilter object [OK]
Common Mistakes:
  • Splitting conditions into multiple filter objects (no AND)
  • Using logical operators incorrectly inside arrayFilters
  • Using positional $ instead of filtered $[identifier]
Recommended

Ready to prove it?

Pass the test and this pattern moves unknown strong while earning +1 Grip toward your certificate.

10 questions~5 mineasy hard