Query Firestore field/value using multiple multiple 'where' values?

Question

I'm considering letting users follow other users in a app, and would have a feed of posts from people who they follow.

Is there a way to query multiple 'where' statements at once, or compare to a List? Or would a alternate route need to be taken?

Here is a example scenario in NodeJS:

var usersFollowed = ['GKXgK2CPPGPQjmQ3Lsrh', 'cBjzo3MSjjaOHksVmO0o', 'tc9gMwZR9SiyjWonyCWF'];

var followingPosts = await db.collection('posts').where('posterUID', '==', usersFollowed.Any()).get();

(.Any() is made up and what I would like to do)

Here is a example of a post's document in Firestore:

postID
    caption: 'a picture of something'
    type: 'picutre'
    size: 1
    posterUID: GKXgK2CPPGPQjmQ3Lsrh

Renaud Tarnec · Accepted Answer · 2021-02-09 21:23:29Z

4

You should use the in operator: "Use the in operator to combine up to 10 equality (==) clauses on the same field with a logical OR. An in query returns documents where the given field matches any of the comparison values".

var usersFollowed = ['GKXgK2CPPGPQjmQ3Lsrh', 'cBjzo3MSjjaOHksVmO0o', 'tc9gMwZR9SiyjWonyCWF'];
var followingPosts = await db.collection('posts').where('posterUID', 'in', usersFollowed).get();

However, note that you can only combine up to 10 equality (==) clauses.

If you need to combine more than 10 clauses, you will need to do several similar queries and merge the results. This article explains how to merge two queries with the JS SDK.

edited Feb 9, 2021 at 21:23

answered Feb 9, 2021 at 21:15

Renaud Tarnec

83.4k10 gold badges99 silver badges130 bronze badges

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

2 Comments

August Kimo Over a year ago

This wouldn't work as the posterUID is a string. I'm updating the question to reflect this, thanks anyways.

Renaud Tarnec Over a year ago

Sorry, my mistake... it should be the in operator. I'm going to re-write the answer.

Collectives™ on Stack Overflow

Query Firestore field/value using multiple multiple 'where' values?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related