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.