How to query data with multiple where clauses from a Firestore 7.24.0 instance?

Question

I want to query my Firestore data depending on two where clauses.

Firstly the spaceId == someString and secondly the field ìsDeleted == false.

I could already find a solution with one where clause. However, I could not find any tutorials or documentation on how to query with multiple where clauses, especially for Firebase version 7.24.0.

Anyone an idea how to solve this?

Here is the code:

   this.activities = this.angularFirestore
      .collection("accounts")
      .doc(this.userId)
      .collection("activities", (ref) => 
        ref.where("spaceId", "==", this.spaceId)
      )
      .valueChanges();

Frank van Puffelen · Accepted Answer · 2021-12-16 22:05:15Z

2

You can just chain where calls, so:

ref.where("spaceId", "==", this.spaceId)
   .where("isDeleted", "==", false)

answered Dec 16, 2021 at 22:05

Frank van Puffelen

603k85 gold badges896 silver badges869 bronze badges

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

1 Comment

vlntn Over a year ago

That worked. Thanks!

Collectives™ on Stack Overflow

How to query data with multiple where clauses from a Firestore 7.24.0 instance?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related