MongoDB Array Queries | Dot Notation & Positional Operator

# CHAPTER 17

Working with Arrays and Nested Documents #

1. Introduction #

2. Learning Objectives #

• Query Embedded Documents using Dot Notation.

• Search for specific items inside an Array.

• Push and Pull items to/from an Array.

• Update a specific element inside an Array using the Positional Operator ($).

3. Querying Embedded Objects (Dot Notation) #

// CRITICAL: When using dot notation in a query, you MUST wrap the key in quotes!
db.users.find({ "address.city": "London" })

// Digging deeper: Find users with a specific zip code inside their office address
db.users.find({ "contact_info.office.address.zip": "10001" })

4. Querying Arrays #

// This magically searches INSIDE the array and returns the document if 'tech' is present!
db.articles.find({ tags: "tech" })

5. Modifying Arrays ($push and $pull) #

// Add a new tag to the article
db.articles.updateOne(
    { _id: 1 },
    { $push: { tags: "coding" } } // Appends 'coding' to the end of the array!
)

// Remove a specific tag from the article
db.articles.updateOne(
    { _id: 1 },
    { $pull: { tags: "sports" } } // Deletes 'sports' from the array!
)

6. Updating an Array of Objects (The Positional Operator $) #

{
  "_id": 1,
  "comments": [
    { "user": "Alice", "likes": 5 },
    { "user": "Bob", "likes": 2 }
  ]
}

A user clicks "Like" on Bob's comment. We need to increment Bob's likes to 3. But how do we tell MongoDB *which* comment to update? We don't know the index (is it comments[0] or comments[1])?

We use the Positional Operator ($). The $ acts as a placeholder. It tells MongoDB: "Hey, remember the item that matched my filter? Use its index!"

db.posts.updateOne(
    // 1. The Filter: Find Post #1, AND find the exact comment made by Bob.
    { _id: 1, "comments.user": "Bob" },
    
    // 2. The Update: Use the '$' placeholder to increment THAT specific comment!
    { $inc: { "comments.$.likes": 1 } } 
)

*(MongoDB finds Bob at index 1, so "comments.$.likes" dynamically becomes "comments.1.likes" behind the scenes!)*

7. Mini Project: The Shopping Cart #

// 1. Add an Item to the Cart ($push)
db.carts.updateOne(
    { user_id: 123 },
    { $push: { items: { name: "Mouse", qty: 1, price: 20 } } }
)

// 2. The user changes the quantity of the "Mouse" to 5 (Positional Operator $)
db.carts.updateOne(
    { user_id: 123, "items.name": "Mouse" },
    { $set: { "items.$.qty": 5 } }
)

// 3. The user removes the Mouse from the cart entirely ($pull)
db.carts.updateOne(
    { user_id: 123 },
    { $pull: { items: { name: "Mouse" } } }
)

8. Common Mistakes #

• Forgetting Quotes in Dot Notation: Typing db.users.find({ address.city: "London" }) will throw a fatal Javascript syntax error. Object keys with dots in them must be encapsulated in string quotes: "address.city".

• Using $set to add Array items: If you use $set: { tags: "coding" }, it will delete the entire array and replace it with the single string "coding". You must use $push to append to an array.

9. Best Practices #

• Limit Array Growth: As discussed in Chapter 13, arrays should not grow infinitely. If a $push operation is running 1,000 times a day on a single document, you are architecting the database wrong. Move that data to a separate collection.

10. Exercises #

1. 1. What update operator is used to remove a specific item from an Array?

1. 2. Why is the Positional Operator ($) required when updating an Array of Objects?

11. MongoDB Challenges #

db.employees.updateOne(
    { name: "Sarah" },
    { $push: { skills: "MongoDB" } }
)

12. MCQ Quiz with Answers #

13. Interview Questions #

• Q: Explain the mechanical difference between $push and $set when dealing with MongoDB arrays. What happens if you accidentally use $set on an array field?

• Q: Describe a scenario where Dot Notation is required in a find() query, and explain why the key must be wrapped in quotes.

14. FAQs #

15. Summary #

16. Next Chapter Recommendation #