Why query operators are needed in MongoDB - See It in Action

Why Query Operators Are Needed in MongoDB

📖 Scenario: Imagine you run a small bookstore and keep your book records in a MongoDB database. You want to find books based on different conditions like price, author, or publication year.

🎯 Goal: Build a simple MongoDB query step-by-step to understand why query operators are needed to filter data effectively.

📋 What You'll Learn

Create a collection named books with sample book documents

Add a variable to specify a price limit

Write a query using a query operator to find books cheaper than the price limit

Complete the query to include sorting by publication year

💡 Why This Matters

🌍 Real World

Filtering and sorting data is essential in real-world apps like online stores, libraries, or any system managing collections.

💼 Career

Understanding query operators is key for database developers, backend engineers, and data analysts to retrieve precise data efficiently.

1

DATA SETUP: Create the books collection with sample documents

Create a variable called books that holds an array of three book documents. Each document must have these exact fields and values: { title: "Book A", author: "Author X", price: 15, year: 2010 }, { title: "Book B", author: "Author Y", price: 25, year: 2015 }, and { title: "Book C", author: "Author Z", price: 10, year: 2020 }.

MongoDB

const books = [
  // Your code here
];

Need a hint?

Use an array with three objects. Each object should have title, author, price, and year fields.

2

CONFIGURATION: Define a price limit variable

Create a variable called maxPrice and set it to 20.

MongoDB

const books = [
  { title: "Book A", author: "Author X", price: 15, year: 2010 },
  { title: "Book B", author: "Author Y", price: 25, year: 2015 },
  { title: "Book C", author: "Author Z", price: 10, year: 2020 }
];

// Your code here

Need a hint?

Just create a variable named maxPrice and assign it the number 20.

3

CORE LOGIC: Use a query operator to find books cheaper than maxPrice

Create a variable called affordableBooks and set it to the result of filtering books where the price is less than maxPrice. Use the MongoDB query operator $lt inside the filter condition.

MongoDB

const books = [
  { title: "Book A", author: "Author X", price: 15, year: 2010 },
  { title: "Book B", author: "Author Y", price: 25, year: 2015 },
  { title: "Book C", author: "Author Z", price: 10, year: 2020 }
];

const maxPrice = 20;

// Your code here

Need a hint?

Use the filter method on books and check if book.price is less than maxPrice.

4

COMPLETION: Sort the filtered books by publication year

Update affordableBooks by chaining a sort method that orders books by year in ascending order.

MongoDB

const books = [
  { title: "Book A", author: "Author X", price: 15, year: 2010 },
  { title: "Book B", author: "Author Y", price: 25, year: 2015 },
  { title: "Book C", author: "Author Z", price: 10, year: 2020 }
];

const maxPrice = 20;

const affordableBooks = books.filter(book => book.price < maxPrice);

// Your code here

Need a hint?

Chain the sort method after filter to order by year ascending.