find method basics in MongoDB - Mini Project: Build & Apply

PMC: find method basics

📖 Scenario: You are managing a small library database. You want to find books by their titles and authors.

🎯 Goal: Build a MongoDB query using the find method to retrieve books from the collection.

📋 What You'll Learn

Create a collection named books with specific book documents

Add a filter variable to search for books by author

Use the find method with the filter to get matching books

Complete the query to return the results as an array

💡 Why This Matters

🌍 Real World

Finding specific records in a database is a common task in apps like libraries, stores, or user management systems.

💼 Career

Knowing how to use the find method in MongoDB is essential for backend developers and data engineers working with NoSQL databases.

1

Create the books collection with documents

Create a variable called books and assign it an array with these exact documents: { title: 'The Hobbit', author: 'J.R.R. Tolkien' }, { title: '1984', author: 'George Orwell' }, and { title: 'To Kill a Mockingbird', author: 'Harper Lee' }.

MongoDB

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

Hint

Use an array of objects with the exact titles and authors given.

2

Add a filter variable to find books by author

Create a variable called authorFilter and set it to an object that filters books where the author is exactly 'George Orwell'.

MongoDB

const books = [
  { title: 'The Hobbit', author: 'J.R.R. Tolkien' },
  { title: '1984', author: 'George Orwell' },
  { title: 'To Kill a Mockingbird', author: 'Harper Lee' }
];
// Create authorFilter to find books by George Orwell
// Your code here

Hint

Use an object with the key author and value 'George Orwell'.

3

Use the find method with the filter

Create a variable called resultCursor and assign it the result of calling db.books.find(authorFilter).

MongoDB

const books = [
  { title: 'The Hobbit', author: 'J.R.R. Tolkien' },
  { title: '1984', author: 'George Orwell' },
  { title: 'To Kill a Mockingbird', author: 'Harper Lee' }
];

const authorFilter = { author: 'George Orwell' };
// Use find method on db.books with authorFilter
// Your code here

Hint

Use db.books.find(authorFilter) exactly as shown.

4

Convert the cursor to an array to get the results

Create a variable called resultArray and assign it the result of calling resultCursor.toArray().

MongoDB

const books = [
  { title: 'The Hobbit', author: 'J.R.R. Tolkien' },
  { title: '1984', author: 'George Orwell' },
  { title: 'To Kill a Mockingbird', author: 'Harper Lee' }
];

const authorFilter = { author: 'George Orwell' };

const resultCursor = db.books.find(authorFilter);
// Convert resultCursor to an array
// Your code here

Hint

Use resultCursor.toArray() to get the matching documents as an array.

Practice

1. What does the find method do in MongoDB?

easy

A. It deletes documents from a collection.

B. It updates documents in a collection.

C. It searches for documents that match a query.

D. It creates a new collection.

Solution

1. Step 1: Understand the purpose of find

   The find method is used to search for documents in a collection that match a given query.

2. Step 2: Compare with other operations

   Deleting, updating, or creating collections are done by other methods like deleteOne, updateOne, or createCollection.

3. Final Answer:

   It searches for documents that match a query. -> Option C

4. Quick Check:

   find = search documents [OK]

Hint: Remember: find means search for matching documents [OK]

Common Mistakes:

• Confusing find with delete or update methods
• Thinking find creates collections
• Assuming find modifies documents

2. Which of the following is the correct syntax to find all documents in a collection named users?

easy

A. db.users.find({})

B. db.users.findAll()

C. db.users.search({})

D. db.users.get()

Solution

1. Step 1: Recall the correct method name and syntax

   The correct method to find documents is find, and to find all documents, we pass an empty query {}.

2. Step 2: Check other options for validity

   findAll, search, and get are not valid MongoDB methods.

3. Final Answer:

   db.users.find({}) -> Option A

4. Quick Check:

   Use find({}) to get all documents [OK]

Hint: Use empty braces {} inside find() to get all documents [OK]

Common Mistakes:

• Using non-existent methods like findAll or search
• Omitting parentheses after find
• Passing wrong arguments to find

3. Given the collection products with documents:
{ name: "Pen", price: 5 }
{ name: "Book", price: 15 }
What will db.products.find({ price: { $lt: 10 } }).toArray() return?

medium

A. [{ name: "Pen", price: 5 }]

B. [{ name: "Book", price: 15 }]

C. []

D. [{ name: "Pen", price: 5 }, { name: "Book", price: 15 }]

Solution

1. Step 1: Understand the query filter

   The query { price: { $lt: 10 } } means find documents where price is less than 10.

2. Step 2: Check documents against the filter

   "Pen" has price 5 which is less than 10, "Book" has price 15 which is not less than 10.

3. Final Answer:

   [{ name: "Pen", price: 5 }] -> Option A

4. Quick Check:

   Price < 10 returns only Pen [OK]

Hint: Use $lt to filter values less than a number [OK]

Common Mistakes:

• Confusing $lt with $gt
• Expecting all documents to return
• Not converting cursor to array before viewing

4. What is wrong with this query?
db.orders.find(price: 100)

medium

A. The query should use double quotes around price.

B. The collection name is incorrect.

C. The find method cannot filter by price.

D. Missing curly braces around the query object.

Solution

1. Step 1: Check the syntax of the find method

   The query argument to find must be an object enclosed in curly braces {}.

2. Step 2: Identify the missing braces

   The query is written as price: 100 without braces, which is invalid syntax.

3. Final Answer:

   Missing curly braces around the query object. -> Option D

4. Quick Check:

   Query must be inside {} in find() [OK]

Hint: Always wrap query in curly braces {} inside find() [OK]

Common Mistakes:

• Omitting curly braces around query
• Using wrong collection name
• Thinking quotes are mandatory around keys

5. You want to find all documents in employees collection but only show their name and department fields. Which query is correct?

hard

A. db.employees.find({ name: 1, department: 1 })

B. db.employees.find({}, { name: 1, department: 1, _id: 0 })

C. db.employees.find({}, { name: 1, department: 1 })

D. db.employees.find({ name: 1, department: 1, _id: 0 })

Solution

1. Step 1: Understand projection in find()

   Projection is the second argument to find and specifies which fields to include (1) or exclude (0).

2. Step 2: Check the correct syntax for showing only name and department

   Use { name: 1, department: 1, _id: 0 } to include those fields and exclude the _id field.

3. Final Answer:

   db.employees.find({}, { name: 1, department: 1, _id: 0 }) -> Option B

4. Quick Check:

   Projection is second arg with 1 to include fields [OK]

Hint: Use second argument in find() to project fields [OK]

Common Mistakes:

• Putting projection inside the query object
• Not excluding _id when projecting
• Using query to filter fields instead of projection