Querying with where clause in Firebase - Step-by-Step Execution

Process Flow - Querying with where clause

Start Query

↓

Specify Collection

↓

Add where clause

↓

Filter documents

↓

Return matching documents

↓

End Query

This flow shows how a query starts by choosing a collection, then adds a where clause to filter documents, and finally returns only those that match.

Execution Sample

Firebase

const q = query(collection(db, "users"), where("age", ">", 18));
const querySnapshot = await getDocs(q);
querySnapshot.forEach((doc) => {
  console.log(doc.id, "=>", doc.data());
});

This code queries the 'users' collection for documents where the 'age' field is greater than 18, then prints each matching document.

Process Table

Step	Action	Filter Condition	Documents Checked	Documents Matched	Output
1	Start query on 'users' collection	age > 18	All documents in 'users'	N/A	No output yet
2	Check document 1	age=16	Doc1	No	Skip
3	Check document 2	age=22	Doc2	Yes	Include Doc2
4	Check document 3	age=18	Doc3	No	Skip
5	Check document 4	age=25	Doc4	Yes	Include Doc4
6	End query	age > 18	All checked	2 matched	Return Doc2, Doc4

💡 All documents checked; only those with age > 18 are returned.

Status Tracker

Variable	Start	After Doc1	After Doc2	After Doc3	After Doc4	Final
Documents Matched	[]	[]	[Doc2]	[Doc2]	[Doc2, Doc4]	[Doc2, Doc4]

Key Moments - 2 Insights

Why does the document with age 18 not appear in the results?

Because the where clause uses '>' (greater than), not '>=' (greater or equal). The document with age 18 does not satisfy age > 18, as shown in execution_table row 4.

Are all documents checked even if some match early?

Yes, Firestore checks all documents in the collection to find all matches, as seen in execution_table rows 2 to 5.

Visual Quiz - 3 Questions

Look at the execution table, how many documents matched the where clause?

A 2

B 1

C 3

D 4

💡 Hint

Check the 'Documents Matched' column in the last row of the execution_table.

At which step does the query skip a document because it does not meet the condition?

A Step 3

B Step 2

C Step 5

D Step 6

💡 Hint

Look at the 'Documents Checked' and 'Documents Matched' columns in execution_table rows.

If the where clause changed to 'age >= 18', which document would be included additionally?

A Doc1

B Doc4

C Doc3

D No additional document

💡 Hint

Check which document has age exactly 18 in the execution_table.

Concept Snapshot

Querying with where clause in Firebase:
- Use query() with collection() and where(field, operator, value)
- Filters documents by condition
- Returns only matching documents
- Operators: ==, >, >=, <, <=, etc.
- All documents checked, only matches returned

Full Transcript

This visual execution shows how a Firebase query with a where clause works. First, the query starts on the 'users' collection. Then, it applies the filter condition 'age > 18'. Each document in the collection is checked one by one. Documents with age 16 and 18 do not match and are skipped. Documents with age 22 and 25 match and are included in the results. Finally, the query returns only the matching documents. This helps you get only the data you want from your database.

Practice

1. What does the where clause do in a Firebase query?

easy

A. Filters documents based on a condition

B. Deletes documents from a collection

C. Adds new documents to a collection

D. Sorts documents alphabetically

Solution

1. Step 1: Understand the purpose of where clause

   The where clause is used to filter documents in a collection based on a condition.

2. Step 2: Compare with other options

   Deleting, adding, or sorting documents are different operations and not done by where.

3. Final Answer:

   Filters documents based on a condition -> Option A

4. Quick Check:

   where clause = filter condition [OK]

Hint: Remember: where filters, not adds or deletes [OK]

Common Mistakes:

• Confusing filtering with deleting data
• Thinking where adds new documents
• Assuming where sorts data

2. Which of the following is the correct syntax to query documents where the field age is equal to 25 in Firebase?

easy

A. db.collection('users').filter('age', '==', 25)

B. db.collection('users').where('age' = 25)

C. db.collection('users').where('age', '=', 25)

D. db.collection('users').where('age', '==', 25)

Solution

1. Step 1: Recall Firebase where clause syntax

   The correct syntax uses where(field, operator, value) with operator as a string, e.g., '=='.

2. Step 2: Check each option

   db.collection('users').where('age', '==', 25) matches correct syntax. db.collection('users').where('age' = 25) uses '=' instead of '=='. db.collection('users').filter('age', '==', 25) uses 'filter' which is incorrect. db.collection('users').where('age', '=', 25) uses '=' instead of '=='.

3. Final Answer:

   db.collection('users').where('age', '==', 25) -> Option D

4. Quick Check:

   where(field, '==', value) syntax [OK]

Hint: Use '==' operator as a string in where clause [OK]

Common Mistakes:

• Using '=' instead of '==' in where clause
• Using filter() instead of where()
• Missing quotes around operator

3. Given the following Firebase query:

db.collection('products').where('price', '>=', 100).get()

Which products will be returned?

medium

A. Products with price less than 100

B. Products with price equal to 100 only

C. Products with price greater than or equal to 100

D. All products regardless of price

Solution

1. Step 1: Understand the operator '>=' in where clause

   The operator '>=' means greater than or equal to the given value.

2. Step 2: Apply the condition to the query

   The query returns products where price is 100 or more.

3. Final Answer:

   Products with price greater than or equal to 100 -> Option C

4. Quick Check:

   price >= 100 means price ≥ 100 [OK]

Hint: '>=' means greater or equal, so include 100 and above [OK]

Common Mistakes:

• Thinking '>=' means only greater than
• Confusing '<' with '>='
• Assuming it returns all products

4. What is wrong with this Firebase query?

db.collection('orders').where('status', 'equals', 'shipped').get()

medium

A. The operator 'equals' is invalid in where clause

B. The collection name 'orders' is incorrect

C. The field 'status' cannot be queried

D. The get() method is missing parentheses

Solution

1. Step 1: Check the operator used in where clause

   Firebase supports operators like '==', '<', '>=', but not 'equals'.

2. Step 2: Verify other parts of the query

   Collection name and field are valid, and get() is correctly called with parentheses.

3. Final Answer:

   The operator 'equals' is invalid in where clause -> Option A

4. Quick Check:

   Use '==' not 'equals' in where clause [OK]

Hint: Use '==' operator, not words like 'equals' [OK]

Common Mistakes:

• Using 'equals' instead of '=='
• Missing parentheses on get()
• Assuming any string operator works

5. You want to get all users from the 'users' collection whose age is between 18 and 30 inclusive. Which Firebase query correctly achieves this?

hard

A. db.collection('users').where('age', '>', 18).where('age', '<', 30)

B. db.collection('users').where('age', '>=', 18).where('age', '<=', 30)

C. db.collection('users').where('age', '==', 18).where('age', '==', 30)

D. db.collection('users').where('age', '>=', 18 || '<=', 30)

Solution

1. Step 1: Understand how to filter a range in Firebase

   Firebase allows chaining multiple where clauses to filter a range, e.g., age >= 18 and age <= 30.

2. Step 2: Analyze each option

   db.collection('users').where('age', '>=', 18).where('age', '<=', 30) correctly uses two where clauses with '>=' and '<=' operators. db.collection('users').where('age', '>', 18).where('age', '<', 30) excludes 18 and 30 by using '>' and '<'. db.collection('users').where('age', '==', 18).where('age', '==', 30) tries to match age exactly 18 and 30 simultaneously, which is impossible. db.collection('users').where('age', '>=', 18 || '<=', 30) uses invalid syntax combining operators in one where.

3. Final Answer:

   db.collection('users').where('age', '>=', 18).where('age', '<=', 30) -> Option B

4. Quick Check:

   Chain where with >= and <= for inclusive range [OK]

Hint: Chain where clauses for range with >= and <= [OK]

Common Mistakes:

• Using '==' twice for range
• Combining operators incorrectly in one where
• Using > and < excludes boundary values