I have problem. My app allows user to filter offers by few params.
I would like to fetch data with .where() operator by I need to stack them. How can I do it?
My attempt (don't work):
let query = db.collection("cards").where("cardId", "==", id);
if (filterParams.price.from && filterParams.price.to) {
query
.where("price", ">=", filterParams.price.from)
.where("price", "<=", filterParams.price.to);
}
if (filterParams.graded) {
query.where("isGraded", "==", filterParams.graded);
}
if (filterParams.condition) {
query.where("condition", "==", filterParams.condition);
}
query = await query.get();
Query objects are immutable. Each time you call where it returns a new Query object, which you need to then keep a reference to that query.
So:
let query = db.collection("cards").where("cardId", "==", id);
if (filterParams.price.from && filterParams.price.to) {
query = query // 👈
.where("price", ">=", filterParams.price.from)
.where("price", "<=", filterParams.price.to);
}
if (filterParams.graded) {
query = query.where("isGraded", "==", filterParams.graded); // 👈
}
if (filterParams.condition) {
query = query.where("condition", "==", filterParams.condition); // 👈
}
query = await query.get();