I get this error once I added the Where method, but it works without the Where clause. In collection every document has Boolean called "status".
db.firestore().collection('jobs').where("status","==",true).orderBy("createDate").limit(10).get().then(querySnapshot =>{
})
})
All Help is Appreciated. Thanks!
I get this error once I added the Where method, but it works without the Where clause. In collection every document has Boolean called "status".
db.firestore().collection('jobs').where("status","==",true).orderBy("createDate").limit(10).get().then(querySnapshot =>{
})
})
All Help is Appreciated. Thanks!
Share Improve this question edited Feb 9, 2018 at 6:50 Jonny 1,3291 gold badge15 silver badges27 bronze badges asked Feb 9, 2018 at 4:01 Dulan HewageDulan Hewage 1032 gold badges2 silver badges8 bronze badges2 Answers
Reset to default 9Since you're querying on two fields (status and createDate), there needs to be a posite index on those two fields. Indices on individual fields are automatically created, but posite indexes are only created when you ask for them.
The error message should contain a link directly to the console to plete that task. If that's not the case, you can create it here.
Firestore query on more than two fields requires a posite index on that two filed.
So you have to create posite index status and createDate.You will get the error like following when you don't have an index.
ERROR Error: The query requires an index. You can create it here: https://console.firebase.google./project/admin-e8a7b/database/firestore/indexes?create_index=EgR0ZW1wGgcKA3VpZBACGg0KCXN0YXJ0ZWRBdBADGgwKCF9fbmFtZV9fEAM
at new FirestoreError (vendor.bundle.js:19925)
So when you click this link in error index will be created automatically.
You can also manually create index from firebase console
To bine the equality operator (==) with a range parison (<, <=, >, or >=), make sure to create a custom index.