Excluding fields from results in MongoDB - Step-by-Step Execution

Concept Flow - Excluding fields from results

Start with collection

↓

Write find query

↓

Add projection with exclusion

↓

MongoDB processes query

↓

Return documents without excluded fields

↓

Display results

The flow shows how a MongoDB find query uses projection to exclude specific fields from the returned documents.

Execution Sample

MongoDB

db.users.find({}, {password: 0, _id: 0})

This query finds all documents in 'users' collection but excludes 'password' and '_id' fields from the results.

Execution Table

Step	Action	Query Part	Effect	Result Sample
1	Start query	db.users.find()	No filter, all documents selected	{name: 'Alice', age: 30, password: 'abc123', _id: ObjectId(...)}
2	Add projection	{password: 0, _id: 0}	Exclude 'password' and '_id' fields	{name: 'Alice', age: 30}
3	MongoDB processes	Find + projection	Removes specified fields from each document	{name: 'Bob', age: 25}
4	Return results	Final output	Documents without excluded fields	[{name: 'Alice', age: 30}, {name: 'Bob', age: 25}]
5	End	Query complete	No more documents	Query finished

💡 All documents processed with specified fields excluded, query ends.

Variable Tracker

Variable	Start	After Step 2	After Step 3	Final
documents	[{name:'Alice', age:30, password:'abc123', _id:1}, {name:'Bob', age:25, password:'xyz789', _id:2}]	[{name:'Alice', age:30}, {name:'Bob', age:25}]	[{name:'Alice', age:30}, {name:'Bob', age:25}]	[{name:'Alice', age:30}, {name:'Bob', age:25}]

Key Moments - 2 Insights

Why do we use 0 in the projection object to exclude fields?

Using 0 tells MongoDB to exclude that field from the results. This is shown in execution_table step 2 where {password: 0, _id: 0} means those fields are removed.

Can we exclude some fields and include others at the same time?

No, MongoDB projection requires either inclusion or exclusion, not both (except _id). Here, only exclusion is used as shown in the query and execution_table.

Visual Quiz - 3 Questions

Look at the execution_table at step 2, what fields are excluded from the documents?

A name and age

B password and _id

C only _id

D no fields excluded

💡 Hint

Check the 'Query Part' column in step 2 showing {password: 0, _id: 0}

At which step does MongoDB remove the excluded fields from each document?

A Step 3

B Step 1

C Step 2

D Step 4

💡 Hint

Look at the 'Effect' column in step 3 describing removal of fields

If we remove '_id: 0' from the projection, what changes in the results?

A No change, both fields excluded

B password field will be included

C _id field will be included in results

D Query will fail

💡 Hint

Projection excludes fields explicitly set to 0; removing '_id: 0' means _id is included

Concept Snapshot

MongoDB find() can exclude fields using projection.
Use {field: 0} to exclude a field.
Cannot mix inclusion and exclusion except _id.
Example: db.collection.find({}, {password: 0, _id: 0})
Returns documents without those fields.

Full Transcript

This visual execution shows how MongoDB excludes fields from query results using projection. The query starts by selecting all documents from the collection. Then, the projection object specifies fields to exclude by setting them to 0. MongoDB processes the query by removing those fields from each document before returning the results. The variable tracker shows how documents change from including all fields to excluding password and _id. Key moments clarify why 0 is used for exclusion and that inclusion and exclusion cannot be mixed. The quiz tests understanding of which fields are excluded and when. The snapshot summarizes the syntax and rules for excluding fields in MongoDB queries.

Practice

1. What does setting a field to 0 in a MongoDB query projection do?

easy

A. It excludes that field from the query results.

B. It includes that field in the query results.

C. It renames the field in the query results.

D. It sorts the results by that field.

Solution

1. Step 1: Understand projection in MongoDB

   Projection controls which fields appear in the query results.

2. Step 2: Interpret setting a field to 0

   Setting a field to 0 means exclude that field from the results.

3. Final Answer:

   It excludes that field from the query results. -> Option A

4. Quick Check:

   Field set to 0 = excluded [OK]

Hint: Use 0 in projection to exclude fields quickly [OK]

Common Mistakes:

• Thinking 0 includes the field
• Confusing exclusion with sorting
• Mixing exclusion and inclusion in projection

2. Which of the following is the correct syntax to exclude the field password from the results in a MongoDB query?

easy

A. db.users.find({}, {password: 0})

B. db.users.find({}, {password: 1})

C. db.users.find({password: 0})

D. db.users.find({}, {exclude: 'password'})

Solution

1. Step 1: Identify correct projection syntax

   Projection is the second argument to find(), with field names and 0 or 1 values.

2. Step 2: Exclude field by setting it to 0

   Setting password: 0 excludes it from results.

3. Final Answer:

   db.users.find({}, {password: 0}) -> Option A

4. Quick Check:

   Exclude field = field: 0 in projection [OK]

Hint: Use {field: 0} in second find() argument to exclude [OK]

Common Mistakes:

• Using 1 instead of 0 to exclude
• Putting projection inside query filter
• Using non-existent 'exclude' keyword

3. Given the collection products with documents like {_id: 1, name: 'Pen', price: 5, stock: 100}, what will be the result of db.products.find({}, {price: 0, stock: 0})?

medium

A. [{name: 'Pen', price: 5, stock: 100}]

B. [{name: 'Pen'}]

C. [{_id: 1, price: 5, stock: 100}]

D. [{_id: 1, name: 'Pen'}]

Solution

1. Step 1: Understand projection excludes price and stock

   Setting price: 0 and stock: 0 excludes these fields from results.

2. Step 2: Check which fields remain

   _id is included by default, name is included as not excluded.

3. Final Answer:

   [{_id: 1, name: 'Pen'}] -> Option D

4. Quick Check:

   Excluded fields missing, others present [OK]

Hint: Excluded fields disappear; others stay including _id by default [OK]

Common Mistakes:

• Expecting excluded fields to appear
• Forgetting _id is included by default
• Assuming all fields are excluded

4. What is wrong with this MongoDB query to exclude email and include name fields: db.users.find({}, {email: 0, name: 1})?

medium

A. You should use exclude keyword instead of 0.

B. The syntax is correct and will work as expected.

C. You cannot mix exclusion and inclusion except for _id.

D. You must exclude _id explicitly when mixing fields.

Solution

1. Step 1: Recall projection rules

   MongoDB does not allow mixing inclusion and exclusion in projection except for _id.

2. Step 2: Analyze the query

   Query mixes email: 0 (exclude) and name: 1 (include), which is invalid.

3. Final Answer:

   You cannot mix exclusion and inclusion except for _id. -> Option C

4. Quick Check:

   Mixing 0 and 1 fields (except _id) = error [OK]

Hint: Exclude or include fields, but don't mix except _id [OK]

Common Mistakes:

• Mixing 0 and 1 in projection
• Assuming syntax is always flexible
• Using 'exclude' keyword which doesn't exist

5. You want to query orders collection and exclude creditCardNumber and cvv fields for security, but include all other fields including _id. Which query achieves this correctly?

hard

A. db.orders.find({}, {creditCardNumber: 1, cvv: 1})

B. db.orders.find({}, {creditCardNumber: 0, cvv: 0})

C. db.orders.find({}, {creditCardNumber: 0, cvv: 0, _id: 0})

D. db.orders.find({}, {creditCardNumber: false, cvv: false})

Solution

1. Step 1: Exclude sensitive fields by setting them to 0

   Setting creditCardNumber and cvv to 0 excludes them from results.

2. Step 2: Keep _id included by default

   Not excluding _id means it stays included, as required.

3. Final Answer:

   db.orders.find({}, {creditCardNumber: 0, cvv: 0}) -> Option B

4. Quick Check:

   Exclude sensitive fields only, keep others including _id [OK]

Hint: Exclude sensitive fields with 0, leave others alone [OK]

Common Mistakes:

• Excluding _id unintentionally
• Using 1 to exclude fields
• Using false instead of 0