How to query a Firestore collection with an array filter?

Question

I was doing a query to get information about the user. I want to save in a state the documents that contain the user's id, the user's ids are in an array within the document, my database is like this:

I was doing a query like this:

const loadingInformation = async () => {

        db.collection('channels').get()
            .then((querySnapshot) => {
                querySnapshot.forEach((doc) => {
                    if (doc.data()?.users?.includes(user.id)) {
                        setInformation([...information, {
                            id: doc.id,
                            data: doc.data()
                        }
                        ])
                    }
                })
            })

    }

 useEffect(() => {
        loadingInformation();
    }, [])

the problem is that it only brings me one document and this user is in more than two collections, also, when updating the page, a push is made but from the same document.

I also saw in the documentation that there is a request something like that, but it doesn't work for me:

await db.collection('channels').where('users', 'in', [[user.id]]).onSnapshot(snap => {
            setInformation(snap.docs.map(doc => ({
                doc
            })))
        })

Mises · Accepted Answer · 2022-06-22 22:24:45Z

1

In operator returns documents with field that can be equal to many values, not just one. For example, .where('country', 'in', ['France', 'Germany']) will return documents where country is equal to France or Germany. In operator is meant to be used on number and string field, not arrays. What you need is .where('users', 'array-contains', user.id). If you want to search for more than one user use 'array-contains-any' it works same as 'in' operator but for arrays.

edited Jun 22, 2022 at 22:24

answered Jun 22, 2022 at 22:17

Mises

4,6332 gold badges24 silver badges37 bronze badges

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

1 Comment

YCrhis Over a year ago

Thank you very much for the information, I did not know that this type of request could be made, now it works correctly.

Collectives™ on Stack Overflow

How to query a Firestore collection with an array filter?

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