GCP Firestore Indexing Errors When Using Composite Indexes for Complex Queries
I've been struggling with this for a few days now and could really use some help... I'm working with an scenario with indexing in GCP Firestore while trying to query a collection with multiple filters. My current setup involves using composite indexes to support queries that filter on multiple fields. However, when I attempt to run the query, I receive the following behavior: `The query requires an index. You can create it here: <index-link>`. I've confirmed that I've created the necessary composite index in the Firestore console, which includes the fields I am filtering on. Here is the query I've constructed: ```javascript const admin = require('firebase-admin'); const db = admin.firestore(); async function fetchData() { const snapshot = await db.collection('users') .where('age', '>=', 18) .where('status', '==', 'active') .orderBy('age') .get(); snapshot.forEach(doc => { console.log(doc.id, '=>', doc.data()); }); } ``` Despite having the index, the query continues to unexpected result with the same message. I've verified that the index is not in a pending state but I'm unsure if there are any limitations or specific configurations that I might be missing. Additionally, I've tried deleting the index and recreating it, but that did not resolve the scenario. Are there any best practices I should follow when creating composite indexes in Firestore, or could there be something else at play that I'm not considering? Any guidance would be greatly appreciated! My development environment is Windows. Any ideas what could be causing this?