Querying array elements directly in MongoDB - Step-by-Step Execution

Concept Flow - Querying array elements directly

Start with collection

↓

Specify query on array field

↓

MongoDB checks each array element

↓

Match elements that satisfy condition?

Yes No↓

Return document

↓

End

MongoDB checks each element in the array field to find if any element matches the query condition, then returns the whole document if a match is found.

Execution Sample

MongoDB

db.students.find({ scores: { $elemMatch: { score: { $gt: 80 } } } })

Finds all student documents where at least one score in the scores array is greater than 80.

Execution Table

Step	Document	Array Field 'scores'	Condition Check	Match Result	Action
1	{name: 'Alice', scores: [{score: 75}, {score: 85}]}	[75, 85]	Check 75 > 80? No	No match yet	Continue checking
2	{name: 'Alice', scores: [{score: 75}, {score: 85}]}	[75, 85]	Check 85 > 80? Yes	Match found	Return document
3	{name: 'Bob', scores: [{score: 60}, {score: 70}]}	[60, 70]	Check 60 > 80? No	No match yet	Continue checking
4	{name: 'Bob', scores: [{score: 60}, {score: 70}]}	[60, 70]	Check 70 > 80? No	No match	Skip document
5	{name: 'Carol', scores: [{score: 90}]}	[90]	Check 90 > 80? Yes	Match found	Return document
6	End of collection	-	-	-	Query complete

💡 All documents checked; query returns documents where any array element matches condition.

Variable Tracker

Variable	Start	After 1	After 2	After 3	After 4	After 5	Final
Current Document	None	Alice	Alice	Bob	Bob	Carol	End
Array Elements Checked	None	75	85	60	70	90	Complete
Match Found	False	False	True	False	False	True	Final

Key Moments - 2 Insights

Why does MongoDB return the whole document even if only one array element matches?

Because the query checks if any element in the array matches the condition, and if yes, the entire document containing that array is returned, as shown in execution_table rows 2 and 5.

What happens if no array elements satisfy the condition?

MongoDB skips that document entirely, as seen in execution_table rows 4 where no scores are greater than 80, so the document is not returned.

Visual Quiz - 3 Questions

Look at the execution table, what is the match result when checking Alice's score 75?

A No match yet

B Match found

C No match

D Query complete

💡 Hint

Refer to execution_table row 1 under 'Match Result' column.

At which step does the query decide to skip Bob's document?

A Step 3

B Step 5

C Step 4

D Step 2

💡 Hint

Check execution_table row 4 for the action taken on Bob's document.

If the condition changed to score > 90, which document would still be returned?

A Alice

B None

C Carol

D Bob

💡 Hint

Look at the scores in variable_tracker and see which scores are greater than 90.

Concept Snapshot

Querying array elements directly in MongoDB:
Use $elemMatch to specify conditions on array elements.
MongoDB checks each element; if any matches, returns the whole document.
If no elements match, document is skipped.
Example: db.collection.find({arrayField: {$elemMatch: {condition}}})

Full Transcript

This visual execution shows how MongoDB queries documents by checking each element inside an array field. For each document, MongoDB looks at every element in the array to see if it meets the query condition. If any element matches, the entire document is returned. If none match, the document is skipped. For example, when querying students with scores greater than 80, MongoDB checks each score in the scores array. Alice has a score 85 which matches, so her document is returned. Bob's scores do not match, so his document is skipped. Carol has a score 90 which matches, so her document is returned. This process continues until all documents are checked. This helps beginners understand that MongoDB does not return just the matching array element but the whole document containing it.

Practice

1. What does the MongoDB query { tags: "mongodb" } do when applied to a collection where tags is an array field?

easy

A. Finds documents where the tags array contains the value "mongodb".

B. Finds documents where the tags array is exactly equal to "mongodb".

C. Finds documents where the tags array is empty.

D. Finds documents where the tags field does not exist.

Solution

1. Step 1: Understand array field querying in MongoDB

   When querying an array field with a value, MongoDB checks if the array contains that value anywhere.

2. Step 2: Analyze the query { tags: "mongodb" }

   This query looks for documents where the tags array includes the string "mongodb" as one of its elements.

3. Final Answer:

   Finds documents where the tags array contains the value "mongodb". -> Option A

4. Quick Check:

   Querying array with value checks for presence = B [OK]

Hint: Querying array with value checks for presence [OK]

Common Mistakes:

• Thinking it matches exact array equality
• Assuming it matches empty arrays
• Confusing missing field with array content

2. Which of the following is the correct MongoDB query syntax to find documents where the array field scores contains the number 85?

easy

A. { scores: { $contains: 85 } }

B. { scores: { $in: 85 } }

C. { scores: 85 }

D. { scores: { $eq: [85] } }

Solution

1. Step 1: Recall MongoDB syntax for matching array elements

   To find documents where an array contains a value, simply use { field: value } syntax.

2. Step 2: Evaluate each option

   { scores: { $contains: 85 } } uses a non-existent operator $contains. { scores: { $eq: [85] } } incorrectly uses $eq with an array. { scores: { $in: 85 } } uses $in incorrectly without an array. { scores: 85 } correctly uses { scores: 85 }.

3. Final Answer:

   { scores: 85 } -> Option C

4. Quick Check:

   Simple value match syntax = D [OK]

Hint: Use {field: value} to match array elements directly [OK]

Common Mistakes:

• Using non-existent operators like $contains
• Misusing $eq with arrays
• Passing non-array to $in operator

3. Given the collection documents:

{ _id: 1, scores: [70, 85, 90] }

{ _id: 2, scores: [60, 75] }

{ _id: 3, scores: [85, 95] }

What will be the result of the query { scores: 85 }?

medium

A. [] (empty array)

B. [{ _id: 2, scores: [60, 75] }]

C. Syntax error

D. [{ _id: 1, scores: [70, 85, 90] }, { _id: 3, scores: [85, 95] }]

Solution

1. Step 1: Identify which documents have 85 in their scores array

   Document 1 has scores [70, 85, 90] which includes 85. Document 3 has scores [85, 95] which also includes 85. Document 2 does not have 85.

2. Step 2: Understand the query result

   The query { scores: 85 } returns all documents where the scores array contains 85, so documents 1 and 3.

3. Final Answer:

   [{ _id: 1, scores: [70, 85, 90] }, { _id: 3, scores: [85, 95] }] -> Option D

4. Quick Check:

   Documents with 85 in scores = C [OK]

Hint: Query returns docs where array contains value [OK]

Common Mistakes:

• Expecting only one document
• Thinking query returns empty if multiple matches
• Confusing syntax error with valid query

4. Consider this incorrect MongoDB query to find documents where the tags array contains both "red" and "blue":

{ tags: { $all: "red", "blue" } }

What is the main issue with this query?

medium

A. The $all operator requires an array of values, not separate arguments.

B. The query should use $elemMatch instead of $all.

C. The field name should be inside quotes.

D. The query is missing a $and operator.

Solution

1. Step 1: Understand $all operator syntax

   The $all operator expects an array of values to match all elements inside the array field.

2. Step 2: Identify the syntax error in the query

   The query incorrectly passes separate arguments to $all instead of an array. Correct syntax is { tags: { $all: ["red", "blue"] } }.

3. Final Answer:

   The $all operator requires an array of values, not separate arguments. -> Option A

4. Quick Check:

   $all needs array syntax = A [OK]

Hint: Use array syntax with $all operator [OK]

Common Mistakes:

• Passing multiple values without array brackets
• Confusing $all with $elemMatch
• Ignoring syntax errors in operator usage

5. You want to find documents where the ratings array contains at least one element greater than 4 and less than 7. Which query correctly uses $elemMatch to achieve this?

hard

A. { ratings: { $gt: 4, $lt: 7 } }

B. { ratings: { $elemMatch: { $gt: 4, $lt: 7 } } }

C. { ratings: { $in: [5, 6] } }

D. { ratings: { $elemMatch: { $gte: 4, $lte: 7 } } }

Solution

1. Step 1: Understand $elemMatch usage for multiple conditions on array elements

   $elemMatch allows specifying multiple conditions that must be true for the same array element.

2. Step 2: Analyze each option for correctness

   { ratings: { $elemMatch: { $gt: 4, $lt: 7 } } } correctly uses $elemMatch with $gt and $lt to find elements >4 and <7. { ratings: { $gt: 4, $lt: 7 } } is invalid syntax because $gt and $lt cannot be used directly on the array field. { ratings: { $in: [5, 6] } } matches specific values but does not cover the range condition. { ratings: { $elemMatch: { $gte: 4, $lte: 7 } } } uses $gte and $lte which includes 4 and 7, not strictly greater and less.

3. Final Answer:

   { ratings: { $elemMatch: { $gt: 4, $lt: 7 } } } -> Option B

4. Quick Check:

   Use $elemMatch for multiple conditions on one element = A [OK]

Hint: Use $elemMatch for multiple conditions on array elements [OK]

Common Mistakes:

• Using $gt and $lt directly on array field
• Using $in instead of range operators
• Confusing inclusive and exclusive range operators