How to add query operators to query of Firestore?

Question

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();

I have no error on output, it looks like .where() isn't attached to query — Adam Szymański
– Adam Szymański, Commented Jan 4, 2022 at 19:22
Can you try changing the last line to const snapshot = await query.get() instead of assigning the result to query itself. I would also log filterParams to check if all values are as intended — Dharmaraj
– Dharmaraj, Commented Jan 4, 2022 at 19:23
filterParams has been checked, I changed const snapshot = await query.get() but it doesn't work. — Adam Szymański
– Adam Szymański, Commented Jan 4, 2022 at 20:46

Frank van Puffelen · Accepted Answer · 2022-01-04 21:10:29Z

2

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();

answered Jan 4, 2022 at 21:10

Frank van Puffelen

603k85 gold badges895 silver badges868 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to add query operators to query of Firestore?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related