Query filter syntax in MongoDB - Step-by-Step Execution

Concept Flow - Query filter syntax

Start with collection

↓

Apply filter object

↓

Match documents

↓

Return matched documents

↓

End

The query filter syntax in MongoDB starts by applying a filter object to a collection, matching documents that meet the filter criteria, and returning those matched documents.

Execution Sample

MongoDB

db.users.find({ age: { $gt: 25 } })

This query finds all documents in the 'users' collection where the 'age' field is greater than 25.

Execution Table

Step	Filter Applied	Document Checked	Match Result	Action
1	{ age: { $gt: 25 } }	{ name: 'Alice', age: 22 }	No	Skip document
2	{ age: { $gt: 25 } }	{ name: 'Bob', age: 30 }	Yes	Include document
3	{ age: { $gt: 25 } }	{ name: 'Carol', age: 25 }	No	Skip document
4	{ age: { $gt: 25 } }	{ name: 'Dave', age: 40 }	Yes	Include document
5	No more documents	-	-	Return matched documents

💡 All documents checked; query returns documents where age > 25

Variable Tracker

Variable	Start	After 1	After 2	After 3	After 4	Final
Matched Documents	[]	[]	[{ name: 'Bob', age: 30 }]	[{ name: 'Bob', age: 30 }]	[{ name: 'Bob', age: 30 }, { name: 'Dave', age: 40 }]	[{ name: 'Bob', age: 30 }, { name: 'Dave', age: 40 }]

Key Moments - 2 Insights

Why does the document with age 25 not match the filter { age: { $gt: 25 } }?

Because $gt means 'greater than', so age must be strictly more than 25. The document with age 25 is equal, not greater, so it does not match (see execution_table row 3).

What happens if the filter is an empty object {}?

An empty filter matches all documents in the collection, so all documents would be returned.

Visual Quiz - 3 Questions

Look at the execution table, which document is included at step 2?

A { name: 'Alice', age: 22 }

B { name: 'Carol', age: 25 }

C { name: 'Bob', age: 30 }

D { name: 'Dave', age: 40 }

💡 Hint

Check the 'Document Checked' and 'Match Result' columns at step 2 in the execution_table.

At which step does the query finish checking documents?

A Step 4

B Step 5

C Step 3

D Step 2

💡 Hint

Look for the row where 'No more documents' is noted in the 'Filter Applied' column.

If the filter changed to { age: { $gte: 25 } }, which document would now match that did not before?

A { name: 'Carol', age: 25 }

B { name: 'Bob', age: 30 }

C { name: 'Alice', age: 22 }

D { name: 'Dave', age: 40 }

💡 Hint

Compare the difference between $gt and $gte operators and check the document ages in variable_tracker.

Concept Snapshot

MongoDB query filter syntax:
- Use an object to specify conditions, e.g., { field: value }
- Use operators like $gt (greater than), $gte (greater or equal)
- Filters match documents that satisfy all conditions
- Result is all matched documents from the collection
- Empty filter {} returns all documents

Full Transcript

This visual execution shows how MongoDB applies a query filter to a collection. The filter { age: { $gt: 25 } } is applied to each document. Documents with age greater than 25 are matched and included in the result. Documents with age 25 or less are skipped. The process continues until all documents are checked, then the matched documents are returned. Key points include understanding the $gt operator means strictly greater than, and that an empty filter matches all documents.