[Solved] This Firestore query throws an error:db.collection('events').where('date', '>=', '2023-01-01').orderBy('location')What is the cause? | GCP

GCP - Cloud Firestore and Bigtable

This Firestore query throws an error:

db.collection('events').where('date', '>=', '2023-01-01').orderBy('location')

What is the cause?

AFirestore does not support filtering by date fields.

BInvalid operator '>=' used in where clause.

CorderBy field must be the same as where field for inequality filters.

DMissing composite index for inequality filter on 'date' and orderBy on 'location'.

Step-by-Step Solution

Solution:

Step 1: Check Firestore rules for inequality filters and orderBy
When using inequality filter on one field and orderBy on another, a composite index is required.
Step 2: Identify cause of error
Error occurs because composite index for 'date' and 'location' is missing.
Final Answer:
Missing composite index for inequality filter on 'date' and orderBy on 'location'. -> Option D
Quick Check:
Inequality + orderBy different field = composite index needed [OK]

Quick Trick: Inequality + orderBy different field needs composite index [OK]

Common Mistakes:

Master "Cloud Firestore and Bigtable" in GCP

9 interactive learning modes - each teaches the same concept differently

More GCP Quizzes

This Firestore query throws an error: