Firebase Firestore - OR query

Question

How to get data by multiple values of one field? For example, I have database with posts and I want to query for all posts where blogId is 1 or 2, sorting by timestamp.

collection("posts").whereEqualTo("blogId", "1") .whereEqualTo("blogId", 2).orderBy("timestamp", Query.Direction.DESCENDING).limit(50) 

Code above is not working :(

How to achieve this? Regards :)

Answer 1

Firestore now supports "IN" queries for this purpose.

The query would look like this:

database.collection("collectionName").where("fieldName", "in", ["fieldValue1", "fieldValue2"]); 

You can have up to 10 values (fieldValueX) to check "IN" of.

---

The code OP desired would be as follows:

database.collection("posts").where("blogId", "in", ["1", "2"]);  

Answer 2

You could combine the Observables and return as one

orQuery(){      const $one = this.afs.collection("posts", ref => ref.where("blogId","==","1")).valueChanges();     const $two = this.afs.collection("posts", ref => ref.where("blogId","==","2")).valueChanges();      return combineLatest($one,$two).pipe(         map(([one, two]) => [...one, ...two])     ) }  getOr(){     this.orQuery().subscribe(data => console.log(data)) }