Comparison operators (==, <, >, >=, <=) in Firebase - Commands & Configuration

Introduction

When working with Firebase Firestore, you often need to find data that matches certain conditions. Comparison operators help you filter documents by checking if a field equals, is less than, greater than, or meets other comparison rules.

When you want to find all users who are exactly 18 years old.

When you need to get all orders with a price greater than 100 dollars.

When you want to list events happening before a certain date.

When you want to find products with stock less than or equal to 10.

When you want to get all messages sent on or after a specific timestamp.

Commands

This command queries the 'users' collection to find documents where the 'age' field is exactly 18.

Terminal

firebase firestore:query --collection=users --where="age == 18"

Expected Output

Document ID: user123

{

  "name": "Alice",

  "age": 18

}

Document ID: user456

{

  "name": "Bob",

  "age": 18

}

→

--collection - Specifies the Firestore collection to query.

→

--where - Defines the filter condition using comparison operators.

This command finds all documents in the 'orders' collection where the 'price' field is greater than 100.

Terminal

firebase firestore:query --collection=orders --where="price > 100"

Expected Output

Document ID: order789

{

  "item": "Laptop",

  "price": 1200

}

Document ID: order101

{

  "item": "Phone",

  "price": 150

}

→

--collection - Specifies the Firestore collection to query.

→

--where - Defines the filter condition using comparison operators.

This command retrieves all events happening on or before June 1, 2024.

Terminal

firebase firestore:query --collection=events --where="date <= '2024-06-01'"

Expected Output

Document ID: event001

{

  "name": "Spring Festival",

  "date": "2024-05-20"

}

Document ID: event002

{

  "name": "Music Concert",

  "date": "2024-06-01"

}

→

--collection - Specifies the Firestore collection to query.

→

--where - Defines the filter condition using comparison operators.

Key Concept

If you remember nothing else from this pattern, remember: comparison operators let you filter Firestore data by checking if fields meet specific conditions like equal, less than, or greater than.

Common Mistakes

Using a single equals sign (=) instead of double equals (==) in the where clause.

A single equals sign is not a valid comparison operator in Firestore queries and will cause an error.

Always use '==' for equality checks in Firestore queries.

Trying to compare fields with unsupported operators or mixing data types (e.g., comparing a string to a number).

Firestore requires the field and value types to match for comparison; otherwise, the query fails.

Ensure the field and value types match and use only supported operators: ==, <, <=, >, >=

Using comparison operators without quotes around the condition in the CLI command.

Without quotes, the shell may misinterpret the symbols, causing syntax errors.

Always enclose the where condition in double quotes.

Summary

Use comparison operators in Firestore queries to filter documents by field values.

Commands include --collection to specify where to look and --where to set the condition.

Always use '==' for equality and remember to quote your conditions in CLI commands.

Practice

1. Which comparison operator in Firebase queries checks if a field value is exactly equal to a given value?

easy

A. ==

B. <

C. >=

D. <=

Solution

1. Step 1: Understand the purpose of each operator

   The operator == checks for exact equality, while <, >=, and <= check for less than, greater or equal, and less or equal respectively.

2. Step 2: Identify the operator for exact equality

   Since the question asks for exact equality, the correct operator is ==.

3. Final Answer:

   == -> Option A

4. Quick Check:

   Exact equality operator = == [OK]

Hint: Use == to check if values are exactly the same [OK]

Common Mistakes:

• Confusing == with assignment operator =
• Using < or > for equality checks
• Thinking >= means equal only

2. Which of the following is the correct Firebase query syntax to find documents where the field age is greater than 18?

easy

A. query.where('age', '==', 18)

B. query.where('age', '<', 18)

C. query.where('age', '>=', 18)

D. query.where('age', '>', 18)

Solution

1. Step 1: Identify the operator for 'greater than'

   The operator for 'greater than' is >.

2. Step 2: Match the operator with the correct syntax

   The correct syntax uses query.where('age', '>', 18) to filter documents where age is greater than 18.

3. Final Answer:

   query.where('age', '>', 18) -> Option D

4. Quick Check:

   Greater than operator = > [OK]

Hint: Use '>' for values strictly greater than target [OK]

Common Mistakes:

• Using '==' instead of '>'
• Confusing '>=' with '>'
• Using '<' when wanting greater values

3. Given this Firebase query: query.where('score', '>=', 50).where('score', '<', 70), which scores will be included in the results?

medium

A. Scores greater than or equal to 50 and less than 70

B. Scores greater than 50 and less than or equal to 70

C. Scores equal to 50 or equal to 70

D. Scores equal to 50 and less than 70

Solution

1. Step 1: Analyze the first condition

   The first condition score >= 50 includes scores 50 and above.

2. Step 2: Analyze the second condition

   The second condition score < 70 includes scores less than 70, excluding 70 itself.

3. Step 3: Combine both conditions

   Only scores that satisfy both conditions are included: scores greater than or equal to 50 and less than 70.

4. Final Answer:

   Scores greater than or equal to 50 and less than 70 -> Option A

5. Quick Check:

   Range includes 50 ≤ score < 70 [OK]

Hint: Combine >= and < for range queries [OK]

Common Mistakes:

• Including 70 when using '<' operator
• Confusing '>' with '>='
• Thinking 'or' instead of 'and' between conditions

4. You wrote this Firebase query: query.where('price', '=>', 100). Why does it cause an error?

medium

A. Because 'price' field cannot be compared

B. Because 100 should be a string, not a number

C. Because '=>' is not a valid comparison operator in Firebase queries

D. Because the operator should be '<=' instead

Solution

1. Step 1: Check the operator syntax

   The operator '=>' is not a valid Firebase comparison operator. The correct operator for 'greater than or equal' is '>='.

2. Step 2: Understand Firebase operator rules

   Firebase only supports specific operators: ==, <, >, <=, and >=. Using any other operator causes a syntax error.

3. Final Answer:

   '=>' is invalid operator causing error -> Option C

4. Quick Check:

   Use >=, not => for greater or equal [OK]

Hint: Use >=, not => for greater or equal [OK]

Common Mistakes:

• Typing => instead of >=
• Using strings instead of numbers for numeric fields
• Assuming all operators are valid

5. You want to query Firebase documents where the field temperature is between 20 and 30 inclusive. Which query correctly uses comparison operators to achieve this?

hard

A. query.where('temperature', '>', 20).where('temperature', '<', 30)

B. query.where('temperature', '>=', 20).where('temperature', '<=', 30)

C. query.where('temperature', '==', 20).where('temperature', '==', 30)

D. query.where('temperature', '<=', 20).where('temperature', '>=', 30)

Solution

1. Step 1: Understand inclusive range requirements

   Inclusive means including both 20 and 30 values.

2. Step 2: Choose operators that include boundary values

   >= includes 20 and <= includes 30, so these operators match the requirement.

3. Step 3: Verify the combined query

   The query query.where('temperature', '>=', 20).where('temperature', '<=', 30) correctly filters temperatures from 20 to 30 inclusive.

4. Final Answer:

   query.where('temperature', '>=', 20).where('temperature', '<=', 30) -> Option B

5. Quick Check:

   Inclusive range uses >= and <= [OK]

Hint: Use >= and <= for inclusive ranges [OK]

Common Mistakes:

• Using > and < excludes boundary values
• Using == twice filters only exact matches
• Reversing operators causing empty results