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

Need a 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

Need a 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

Need a 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

Need a hint?

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