Why querying nested data matters in MongoDB - See It in Action

Why querying nested data matters

📖 Scenario: You work at a company that stores customer orders in a MongoDB database. Each order document contains nested information about the customer and the items they purchased. You want to learn how to query this nested data to find specific details.

🎯 Goal: Build a MongoDB query step-by-step to find orders where a specific item was purchased and extract nested customer information.

📋 What You'll Learn

Create a collection called orders with sample nested documents

Add a filter variable to specify the item name to search for

Write a query to find orders containing that item in the nested items array

Project the customer's name and the matching item details in the query result

💡 Why This Matters

🌍 Real World

Many real-world databases store complex nested data like orders with customers and items. Being able to query inside nested arrays is essential to find relevant information quickly.

💼 Career

Database developers and analysts often need to write queries that access nested data structures to generate reports, filter data, or build APIs.

1

DATA SETUP: Create the orders collection with nested documents

Create a variable called orders and assign it an array with these two documents exactly: { _id: 1, customer: { name: "Alice", age: 30 }, items: [ { name: "Pen", qty: 3 }, { name: "Notebook", qty: 1 } ] } and { _id: 2, customer: { name: "Bob", age: 25 }, items: [ { name: "Pencil", qty: 2 }, { name: "Pen", qty: 5 } ] }

MongoDB

# Create the orders array with two nested documents
# Your code here

Hint

Define orders as a list with two dictionaries. Each dictionary has _id, customer (which is another dictionary), and items (which is a list of dictionaries).

2

CONFIGURATION: Define the item name to search for

Create a variable called search_item and set it to the string "Pen".

MongoDB

orders = [
    {"_id": 1, "customer": {"name": "Alice", "age": 30}, "items": [{"name": "Pen", "qty": 3}, {"name": "Notebook", "qty": 1}]},
    {"_id": 2, "customer": {"name": "Bob", "age": 25}, "items": [{"name": "Pencil", "qty": 2}, {"name": "Pen", "qty": 5}]}
]
# Define the search_item variable
# Your code here

Hint

Just create a variable search_item and assign it the string "Pen".

3

CORE LOGIC: Write a MongoDB-style query to find orders with the search item

Create a variable called matching_orders and assign it a list comprehension that filters orders for documents where any item in items has name equal to search_item. Use for order in orders and any(item['name'] == search_item for item in order['items']) in the condition.

MongoDB

orders = [
    {"_id": 1, "customer": {"name": "Alice", "age": 30}, "items": [{"name": "Pen", "qty": 3}, {"name": "Notebook", "qty": 1}]},
    {"_id": 2, "customer": {"name": "Bob", "age": 25}, "items": [{"name": "Pencil", "qty": 2}, {"name": "Pen", "qty": 5}]}
]
search_item = "Pen"
# Filter orders containing the search_item
# Your code here

Hint

Use a list comprehension with any() to check if any item in order['items'] has the name matching search_item.

4

COMPLETION: Project customer name and matching item details

Create a variable called result and assign it a list comprehension that for each order in matching_orders creates a dictionary with keys customer_name set to order['customer']['name'] and items set to a list of items from order['items'] where item['name'] == search_item.

MongoDB

orders = [
    {"_id": 1, "customer": {"name": "Alice", "age": 30}, "items": [{"name": "Pen", "qty": 3}, {"name": "Notebook", "qty": 1}]},
    {"_id": 2, "customer": {"name": "Bob", "age": 25}, "items": [{"name": "Pencil", "qty": 2}, {"name": "Pen", "qty": 5}]}
]
search_item = "Pen"
matching_orders = [order for order in orders if any(item['name'] == search_item for item in order['items'])]
# Create result with customer_name and filtered items
# Your code here

Hint

Use a list comprehension over matching_orders. For each order, create a dictionary with customer_name and a filtered list of items matching search_item.

Practice

1. What is the main reason to use dot notation when querying nested data in MongoDB?

easy

A. To access fields inside embedded documents

B. To update the entire document at once

C. To delete the whole collection

D. To create a new database

Solution

1. Step 1: Understand nested data structure

   Nested data means one document contains another document inside it.

2. Step 2: Use dot notation to access inner fields

   Dot notation lets you specify the path to a field inside the embedded document.

3. Final Answer:

   To access fields inside embedded documents -> Option A

4. Quick Check:

   Dot notation = access nested fields [OK]

Hint: Dot notation drills down into nested fields fast [OK]

Common Mistakes:

• Thinking dot notation updates whole documents
• Confusing dot notation with collection operations
• Using dot notation to create databases

2. Which of the following is the correct MongoDB query syntax to find documents where the nested field address.city equals "Paris"?

easy

A. { "address.city": "Paris" }

B. { address: { city: "Paris" } }

C. { address.city = "Paris" }

D. { address->city: "Paris" }

Solution

1. Step 1: Recall MongoDB query syntax for nested fields

   MongoDB uses dot notation inside quotes to query nested fields.

2. Step 2: Identify correct syntax

   { "address.city": "Paris" } uses "address.city" as a string key with value "Paris", which is correct.

3. Final Answer:

   { "address.city": "Paris" } -> Option A

4. Quick Check:

   Dot notation in quotes = correct query [OK]

Hint: Use quotes and dot notation for nested field queries [OK]

Common Mistakes:

• Using object syntax without quotes for nested fields
• Using '=' instead of ':' in query
• Using arrow '->' instead of dot notation

3. Given the collection documents:

{ "name": "Alice", "contact": { "email": "[e-mail]", "phone": "1234" } }, { "name": "Bob", "contact": { "email": "[e-mail]", "phone": "5678" } }

What will the query db.collection.find({ "contact.email": "[e-mail]" }) return?

medium

A. [{ "name": "Alice", "contact": { "email": "[e-mail]", "phone": "1234" } }]

B. [] (empty array)

C. [{ "name": "Bob", "contact": { "email": "[e-mail]", "phone": "5678" } }]

D. SyntaxError

Solution

1. Step 1: Understand the query condition

   The query looks for documents where the nested field contact.email equals "[e-mail]".

2. Step 2: Match documents in the collection

   Only Bob's document has contact.email as "[e-mail]", so it will be returned.

3. Final Answer:

   [{ "name": "Bob", "contact": { "email": "[e-mail]", "phone": "5678" } }] -> Option C

4. Quick Check:

   Query matches Bob's email = [{ "name": "Bob", "contact": { "email": "[e-mail]", "phone": "5678" } }] [OK]

Hint: Match exact nested field value with dot notation [OK]

Common Mistakes:

• Expecting all documents to return
• Confusing nested field with top-level field
• Thinking query causes syntax error

4. Consider this query: db.users.find({ contact.phone: "1234" }). What is the main error here?

medium

A. Query is correct and will run fine

B. Using wrong collection name

C. Phone number should be a number, not string

D. Missing quotes around nested field name

Solution

1. Step 1: Check syntax for nested field keys

   MongoDB requires nested field names with dots to be in quotes in queries.

2. Step 2: Identify missing quotes error

   The query uses contact.phone without quotes, causing syntax error.

3. Final Answer:

   Missing quotes around nested field name -> Option D

4. Quick Check:

   Nested keys need quotes = Missing quotes around nested field name [OK]

Hint: Always quote nested keys with dots in queries [OK]

Common Mistakes:

• Ignoring quotes around nested keys
• Assuming phone must be number type
• Thinking collection name causes error

5. You have documents with nested arrays like:

{ "name": "Eve", "orders": [ { "id": 1, "item": "book" }, { "id": 2, "item": "pen" } ] }

Which query finds documents where any order's item is "pen"?

hard

A. { "orders": { "item": "pen" } }

B. { "orders.item": "pen" }

C. { "orders[0].item": "pen" }

D. { "orders": [ { "item": "pen" } ] }

Solution

1. Step 1: Understand querying nested arrays

   MongoDB lets you query array elements using dot notation on the array field.

2. Step 2: Identify correct query for any matching array element

   { "orders.item": "pen" } uses "orders.item" which matches any element's item field equal to "pen".

3. Final Answer:

   { "orders.item": "pen" } -> Option B

4. Quick Check:

   Dot notation on array fields matches any element [OK]

Hint: Use dot notation on array fields to match any element [OK]

Common Mistakes:

• Trying to match whole array instead of elements
• Using array index in query which is invalid
• Using nested object without array context