Firestore - how to do a "reverse" array-contains?

Question

I have a collection users in firestore where one of the fields is "contact_person".

Then I have an array arrNames {'Jim', 'Danny', 'Rachel'} in my frontend and I want to get all users that have either of these names in their "contact_person" field. Something like where("contact_person" IN arrNames)

How could I do that?

Answer 1

This is currently not possible within the Firestore API. You will need to do a separate get for each document, unless the names happen to be in a single contiguous range.

Also see:

• FireStore Where In Query
• Google Firestore - how to get document by multiple ids in one round trip?

Answer 2

It is now possible (from 11/2019) https://firebase.googleblog.com/2019/11/cloud-firestore-now-supports-in-queries.html but keep in mind that the array size can't be greater than 10.

db.collection("projects").where("status", "in", ["public", "unlisted", "secret"]);