Why logical operators matter in MongoDB - See It in Action

Why Logical Operators Matter in MongoDB Queries

📖 Scenario: You are managing a small online bookstore database. You want to find books based on multiple conditions, such as books that are either by a certain author or belong to a specific genre. Logical operators help you combine these conditions effectively.

🎯 Goal: Build a MongoDB query using logical operators to find books that match either one or more conditions.

📋 What You'll Learn

Create a collection named books with sample book documents

Add a variable for the author name to filter

Write a MongoDB query using the $or logical operator to find books by the author or in a specific genre

Complete the query by adding a projection to show only the book title and author

💡 Why This Matters

🌍 Real World

Logical operators are essential in real-world databases to filter data based on multiple criteria, such as finding products, users, or records that meet one or more conditions.

💼 Career

Understanding logical operators in MongoDB queries is important for roles like database administrators, backend developers, and data analysts who need to retrieve precise data efficiently.

1

DATA SETUP: Create the books collection with sample documents

Create a variable called books and assign it an array with these exact documents: { title: "The Great Gatsby", author: "F. Scott Fitzgerald", genre: "Classic" }, { title: "1984", author: "George Orwell", genre: "Dystopian" }, { title: "To Kill a Mockingbird", author: "Harper Lee", genre: "Classic" }

MongoDB

# Create the books array with the specified documents
# Your code here

Hint

Use an array of objects with keys title, author, and genre.

2

CONFIGURATION: Add a variable for the author filter

Create a variable called authorFilter and set it to the string "George Orwell"

MongoDB

books = [
  { "title": "The Great Gatsby", "author": "F. Scott Fitzgerald", "genre": "Classic" },
  { "title": "1984", "author": "George Orwell", "genre": "Dystopian" },
  { "title": "To Kill a Mockingbird", "author": "Harper Lee", "genre": "Classic" }
]
# Create authorFilter variable with value "George Orwell"
# Your code here

Hint

Just assign the string "George Orwell" to authorFilter.

3

CORE LOGIC: Write a MongoDB query using $or to find books by author or genre

Create a variable called query and assign it a MongoDB query object that uses $or to find books where author equals authorFilter or genre equals "Classic"

MongoDB

books = [
  { "title": "The Great Gatsby", "author": "F. Scott Fitzgerald", "genre": "Classic" },
  { "title": "1984", "author": "George Orwell", "genre": "Dystopian" },
  { "title": "To Kill a Mockingbird", "author": "Harper Lee", "genre": "Classic" }
]
authorFilter = "George Orwell"
# Create query using $or with authorFilter and genre "Classic"
# Your code here

Hint

Use $or with an array of conditions inside the query object.

4

COMPLETION: Add a projection to show only title and author

Create a variable called projection and assign it an object that includes title and author set to 1, and excludes _id by setting it to 0

MongoDB

books = [
  { "title": "The Great Gatsby", "author": "F. Scott Fitzgerald", "genre": "Classic" },
  { "title": "1984", "author": "George Orwell", "genre": "Dystopian" },
  { "title": "To Kill a Mockingbird", "author": "Harper Lee", "genre": "Classic" }
]
authorFilter = "George Orwell"
query = { "$or": [ { "author": authorFilter }, { "genre": "Classic" } ] }
# Create projection to include title and author, exclude _id
# Your code here

Hint

Set title and author to 1 and _id to 0 in the projection object.

Practice

1. Which logical operator in MongoDB requires all conditions to be true for a document to match?

easy

A. $and

B. $or

C. $not

D. $nor

Solution

1. Step 1: Recall MongoDB logical operators

   $and combines multiple conditions and only matches documents where every condition is true. $or matches if any condition is true, $not excludes matches, and $nor matches if none are true.

2. Final Answer:

   $and -> Option A

3. Quick Check:

   $and requires all true [OK]

Hint: Remember $and means all conditions must be true [OK]

Common Mistakes:

• Confusing $and with $or
• Thinking $not means all true
• Mixing $nor with $and

2. Which of the following is the correct syntax to find documents where age is greater than 25 or status is "active" in MongoDB?

easy

A. { $and: [ { age: { $gt: 25 } }, { status: "active" } ] }

B. { $nor: [ { age: { $gt: 25 } }, { status: "active" } ] }

C. { $not: [ { age: { $gt: 25 } }, { status: "active" } ] }

D. { $or: [ { age: { $gt: 25 } }, { status: "active" } ] }

Solution

1. Step 1: Identify $or operator and verify syntax

   $or matches documents where at least one condition is true, perfect for age > 25 or status = "active". The syntax with $or and array of conditions is correct; $and requires both true, $not and $nor have different meanings.

2. Final Answer:

   { $or: [ { age: { $gt: 25 } }, { status: "active" } ] } -> Option D

3. Quick Check:

   $or for either condition true = { $or: [ { age: { $gt: 25 } }, { status: "active" } ] } [OK]

Hint: Use $or for any condition true, syntax needs array [OK]

Common Mistakes:

• Using $and instead of $or
• Wrong array brackets
• Using $not with array incorrectly

3. Given the collection documents:
{ name: "Alice", age: 30, status: "active" }
{ name: "Bob", age: 20, status: "inactive" }
{ name: "Carol", age: 25, status: "active" }
What will the query { $and: [ { age: { $gt: 20 } }, { status: "active" } ] } return?

medium

A. [{ name: "Bob", age: 20, status: "inactive" }]

B. [{ name: "Alice", age: 30, status: "active" }, { name: "Carol", age: 25, status: "active" }]

C. [{ name: "Alice", age: 30, status: "active" }]

D. []

Solution

1. Step 1: Evaluate documents against $and conditions

   age > 20 and status = "active": Alice (30, active) matches, Carol (25, active) matches, Bob (20, inactive) does not. Both Alice and Carol returned.

2. Final Answer:

   [{ name: "Alice", age: 30, status: "active" }, { name: "Carol", age: 25, status: "active" }] -> Option B

3. Quick Check:

   Both age > 20 and active status = [{ name: "Alice", age: 30, status: "active" }, { name: "Carol", age: 25, status: "active" }] [OK]

Hint: Check each condition carefully for all documents [OK]

Common Mistakes:

• Including Bob who fails conditions
• Returning only one document
• Confusing $and with $or results

4. You wrote this query to exclude documents where status is "inactive":
{ $not: { status: "inactive" } }
But it returns an error. What is the problem?

medium

A. $not must be inside $and

B. $not cannot be used with strings

C. $not requires a condition operator like $eq, not a direct value

D. $not only works with numeric fields

Solution

1. Step 1: Identify $not syntax error

   $not expects a condition operator like { status: { $not: { $eq: "inactive" } } }, not { $not: { status: "inactive" } } with direct value.

2. Final Answer:

   $not requires a condition operator like $eq, not a direct value -> Option C

3. Quick Check:

   $not needs operator condition [OK]

Hint: Use $not with operators like $eq, not direct values [OK]

Common Mistakes:

• Passing direct values to $not
• Assuming $not works alone
• Using $not with arrays incorrectly

5. You want to find documents where age is greater than 20 but NOT with status equal to "inactive". Which query correctly uses logical operators to achieve this?

hard

A. { $and: [ { age: { $gt: 20 } }, { status: { $ne: "inactive" } } ] }

B. { $and: [ { age: { $gt: 20 } }, { $not: { status: { $eq: "inactive" } } } ] }

C. { $or: [ { age: { $gt: 20 } }, { $not: { status: { $eq: "inactive" } } } ] }

D. { $and: [ { age: { $gt: 20 } }, { $not: { status: "inactive" } } ] }

Solution

1. Step 1: Analyze requirement and options

   Need age > 20 AND status != "inactive". A: $not with direct value (invalid). B: $not wrongly placed at top-level; must be { status: { $not: { $eq: "inactive" } } } (but $ne simpler). C: $or allows documents failing one condition. D: Correctly uses $and with $gt and $ne.

2. Final Answer:

   { $and: [ { age: { $gt: 20 } }, { status: { $ne: "inactive" } } ] } -> Option A

3. Quick Check:

   Use $ne for NOT equal, combine with $and = { $and: [ { age: { $gt: 20 } }, { status: { $ne: "inactive" } } ] } [OK]

Hint: Use $ne for NOT equal, combine with $and for all true [OK]

Common Mistakes:

• Using $not with direct value
• Using $or instead of $and
• Overcomplicating with $not and $eq