Why compound queries narrow results in Firebase - See It in Action

Why compound queries narrow results

📖 Scenario: You are managing a small online bookstore database using Firebase Firestore. You want to find books that match multiple conditions to help customers find exactly what they want.

🎯 Goal: Build a Firebase Firestore query that uses compound conditions to narrow down the list of books based on genre and price.

📋 What You'll Learn

Create a collection of books with fields: title, genre, and price

Add a configuration variable for the maximum price filter

Write a compound query filtering books by genre and price

Complete the query by adding a limit to the number of results

💡 Why This Matters

🌍 Real World

Online stores often need to filter products by multiple conditions to help customers find exactly what they want quickly.

💼 Career

Understanding compound queries is essential for cloud developers working with databases to efficiently retrieve relevant data.

1

Create the initial books collection data

Create a variable called books that is an array of objects. Each object should have these exact fields and values: { title: 'Book A', genre: 'fiction', price: 10 }, { title: 'Book B', genre: 'fiction', price: 15 }, { title: 'Book C', genre: 'non-fiction', price: 20 }, { title: 'Book D', genre: 'fiction', price: 25 }.

Firebase

// Create the books array with the given objects
// Your code here

Hint

Use const books = [ ... ] with the exact objects inside.

2

Add a maximum price filter variable

Create a variable called maxPrice and set it to 20 to filter books by price.

Firebase

const books = [
  { title: 'Book A', genre: 'fiction', price: 10 },
  { title: 'Book B', genre: 'fiction', price: 15 },
  { title: 'Book C', genre: 'non-fiction', price: 20 },
  { title: 'Book D', genre: 'fiction', price: 25 }
];

// Create maxPrice variable set to 20
// Your code here

Hint

Use const maxPrice = 20; exactly.

3

Write a compound query filtering by genre and price

Create a variable called filteredBooks that filters books to include only those with genre equal to 'fiction' and price less than or equal to maxPrice. Use the filter method with a function that checks both conditions.

Firebase

const books = [
  { title: 'Book A', genre: 'fiction', price: 10 },
  { title: 'Book B', genre: 'fiction', price: 15 },
  { title: 'Book C', genre: 'non-fiction', price: 20 },
  { title: 'Book D', genre: 'fiction', price: 25 }
];

const maxPrice = 20;

// Filter books by genre 'fiction' and price <= maxPrice
// Your code here

Hint

Use books.filter(book => book.genre === 'fiction' && book.price <= maxPrice).

4

Limit the number of results returned

Create a variable called limitedBooks that contains the first 2 books from filteredBooks. Use the slice method to get the first 2 items.

Firebase

const books = [
  { title: 'Book A', genre: 'fiction', price: 10 },
  { title: 'Book B', genre: 'fiction', price: 15 },
  { title: 'Book C', genre: 'non-fiction', price: 20 },
  { title: 'Book D', genre: 'fiction', price: 25 }
];

const maxPrice = 20;

const filteredBooks = books.filter(book => book.genre === 'fiction' && book.price <= maxPrice);

// Limit results to first 2 books
// Your code here

Hint

Use filteredBooks.slice(0, 2) to get the first two books.

Practice

1. What is the main reason compound queries in Firebase narrow down results?

easy

A. They increase the number of documents returned.

B. They combine multiple conditions to filter data more precisely.

C. They ignore some conditions to speed up queries.

D. They randomly select documents from the database.

Solution

1. Step 1: Understand what compound queries do

   Compound queries use more than one condition to filter data.

2. Step 2: Effect of combining conditions

   Combining conditions means only documents matching all conditions are returned, narrowing results.

3. Final Answer:

   They combine multiple conditions to filter data more precisely. -> Option B

4. Quick Check:

   Compound queries = multiple conditions = narrower results [OK]

Hint: Think: More conditions mean fewer matching results [OK]

Common Mistakes:

• Thinking compound queries increase results
• Believing conditions are ignored
• Assuming random selection happens

2. Which of the following is the correct syntax to create a compound query in Firebase Firestore?

easy

A. db.collection('users').query('age', '>=', 18).query('active', '==', true)

B. db.collection('users').filter('age', '>=', 18).filter('active', '==', true)

C. db.collection('users').select('age', 'active')

D. db.collection('users').where('age', '>=', 18).where('active', '==', true)

Solution

1. Step 1: Recall Firestore query syntax

   Firestore uses chained where methods to add conditions.

2. Step 2: Identify correct chaining

   db.collection('users').where('age', '>=', 18).where('active', '==', true) correctly chains two where calls for compound conditions.

3. Final Answer:

   db.collection('users').where('age', '>=', 18).where('active', '==', true) -> Option D

4. Quick Check:

   Compound query syntax uses chained where() calls [OK]

Hint: Remember: Firestore uses chained where() for multiple conditions [OK]

Common Mistakes:

• Using filter() instead of where()
• Using query() which is invalid
• Using select() which only picks fields

3. Given this Firestore query:
db.collection('products').where('price', '<=', 100).where('inStock', '==', true)
What kind of results will this query return?

medium

A. Products priced at 100 or less and currently in stock

B. All products priced above 100 and in stock

C. Products priced at 100 or less regardless of stock

D. Only products that are out of stock

Solution

1. Step 1: Analyze the first condition

   The query filters products with price less than or equal to 100.

2. Step 2: Analyze the second condition

   It also filters products where inStock is true, meaning available products.

3. Final Answer:

   Products priced at 100 or less and currently in stock -> Option A

4. Quick Check:

   Compound query narrows to price ≤ 100 AND inStock = true [OK]

Hint: Both conditions must be true for results [OK]

Common Mistakes:

• Ignoring the inStock condition
• Thinking price > 100 is included
• Confusing AND with OR logic

4. You wrote this query:
db.collection('orders').where('status', '==', 'shipped').where('status', '==', 'delivered')
Why does this query return no results?

medium

A. Because the collection 'orders' does not exist.

B. Because the syntax for multiple where clauses is incorrect.

C. Because a document cannot have 'status' equal to both 'shipped' and 'delivered' at the same time.

D. Because Firestore does not support queries on the 'status' field.

Solution

1. Step 1: Understand the conditions on the same field

   The query asks for documents where 'status' equals 'shipped' AND 'delivered' simultaneously.

2. Step 2: Realize the logical impossibility

   A single field cannot have two different values at once, so no documents match both.

3. Final Answer:

   Because a document cannot have 'status' equal to both 'shipped' and 'delivered' at the same time. -> Option C

4. Quick Check:

   Same field with conflicting conditions returns no results [OK]

Hint: Same field can't equal two different values simultaneously [OK]

Common Mistakes:

• Thinking syntax is wrong
• Assuming Firestore disallows querying 'status'
• Assuming collection absence causes this

5. You want to find users who are both 'active' and have a 'score' greater than 50. Which compound query correctly narrows results to this criteria?

hard

A. db.collection('users').where('active', '==', true).where('score', '>', 50)

B. db.collection('users').where('active', '==', true).where('score', '<', 50)

C. db.collection('users').where('active', '==', false).where('score', '>', 50)

D. db.collection('users').where('active', '==', true).where('score', '==', 50)

Solution

1. Step 1: Identify the conditions needed

   Users must be 'active' (true) and have 'score' greater than 50.

2. Step 2: Match conditions to query options

   db.collection('users').where('active', '==', true).where('score', '>', 50) matches both conditions correctly: active equals true and score greater than 50.

3. Final Answer:

   db.collection('users').where('active', '==', true).where('score', '>', 50) -> Option A

4. Quick Check:

   Correct compound query matches all criteria [OK]

Hint: Match conditions exactly to narrow results [OK]

Common Mistakes:

• Using wrong comparison operators
• Mixing true/false for active
• Using equality instead of greater than