Querying nested fields at any depth in MongoDB - Step-by-Step Execution

Concept Flow - Querying nested fields at any depth

Start with collection

↓

Specify nested field path

↓

Use dot notation to access nested field

↓

Apply query condition on nested field

↓

MongoDB searches documents

↓

Return matching documents

The query uses dot notation to specify nested fields at any depth and applies conditions to find matching documents.

Execution Sample

MongoDB

db.users.find({"address.city": "New York"})

Finds all users whose nested field 'address.city' equals 'New York'.

Execution Table

Step	Action	Query Part	Documents Checked	Match Found	Result
1	Start query	db.users.find({"address.city": "New York"})	All documents in users	N/A	No output yet
2	Check first document	"address.city" = "New York"?	Doc 1	Yes	Include Doc 1 in results
3	Check second document	"address.city" = "New York"?	Doc 2	No	Exclude Doc 2
4	Check third document	"address.city" = "New York"?	Doc 3	Yes	Include Doc 3 in results
5	Finish scanning	All documents checked	All docs	N/A	Return matched documents (Doc 1, Doc 3)

💡 All documents checked; query returns documents where nested field matches condition.

Variable Tracker

Variable	Start	After Doc 1	After Doc 2	After Doc 3	Final
MatchedDocuments	[]	[Doc 1]	[Doc 1]	[Doc 1, Doc 3]	[Doc 1, Doc 3]

Key Moments - 2 Insights

How does MongoDB know which nested field to check?

MongoDB uses dot notation like "address.city" to look inside nested objects. See execution_table rows 2-4 where it checks that exact path.

What if the nested field does not exist in a document?

If the nested field is missing, the condition is false for that document, so it is excluded. This is shown in execution_table row 3 where Doc 2 does not match.

Visual Quiz - 3 Questions

Look at the execution table, which documents matched the query?

A Doc 2 only

B Doc 1 and Doc 3

C Doc 1 only

D No documents matched

💡 Hint

Check the 'Match Found' and 'Result' columns in rows 2, 3, and 4.

At which step does the query finish scanning all documents?

A Step 3

B Step 2

C Step 5

D Step 4

💡 Hint

Look at the 'Step' and 'Action' columns for when all documents are checked.

If the nested field was "address.zipcode" instead, how would the query change?

A Use {"address.zipcode": value} in the query

B Use {"address.city": value} in the query

C Use {"zipcode": value} in the query

D Use {"address": {"zipcode": value}} in the query

💡 Hint

Dot notation accesses nested fields; see the query in execution_sample.

Concept Snapshot

Query nested fields using dot notation:
- Use "field.subfield" to access nested data
- Apply conditions on nested fields directly
- MongoDB returns documents matching the nested condition
- Works at any depth by chaining dots
- Missing nested fields cause no match

Full Transcript

This visual execution shows how MongoDB queries nested fields at any depth using dot notation. The query specifies the nested field path like "address.city" and applies a condition. MongoDB scans each document in the collection, checks if the nested field matches the condition, and includes matching documents in the result. Documents missing the nested field do not match. The process ends after all documents are checked, returning only those that satisfy the nested field condition.