Firestore query for same value in multiple fields

Question

Is it possible to query data in cloud firestore for same value in either of multiple fields of a document.

Example like this

await firestore()
      .collection('chats')
      .where('ownerUserId', '==', user.uid)
      .where('chatUserId', '==', user.uid)
      .orderBy('createdAt', 'desc')
      .get()

or to be more precise, something like this

await firestore()
      .collection('chats')
      .where('ownerUserId', '==', user.uid || 'chatUserId', '==', user.uid)
      // .where('chatUserId', '==', user.uid)
      .orderBy('createdAt', 'desc')
      .get()

Rafael Lemos · Accepted Answer · 2021-05-26 11:57:43Z

2

For an OR condition we've to do multiple queries like this:

//We define an async function that takes user uid and return chats
async function getChatsByUserOrOwner(userId) {
      const chatsRef=firestore().collection('chats')
      const ownerChats = chatsRef.where('ownerUserId', '==', userId).orderBy('createdAt', 'desc').get();
      const userChats = chatsRef.where('chatUserId', '==', userId).orderBy('createdAt', 'desc').get();  
      const [ownerChatsSnapshot, userChatsSnapshot] = await Promise.all([
              ownerChats,
              userChats
            ]);
      const ownerChatsList = ownerChatsSnapshot.docs;
      const userChatsList = userChatsSnapshot.docs;
      const allChats = ownerChatsList.concat(userChatsList);
      return allChats;
  }

Now we'll call this function to get required result:

//We call the asychronous function
getChatsByUserOrOwner(user.uid).then(result => {
    result.forEach(docSnapshot => {
        console.log(docSnapshot.data());
    });
});

edited May 26, 2021 at 11:57

Rafael Lemos

5,8692 gold badges12 silver badges21 bronze badges

answered May 26, 2021 at 5:20

Atif Zia

7932 gold badges12 silver badges31 bronze badges

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

1 Comment

Zukzuk Over a year ago

As soon as I do multiple requests to the same ref I run into the following error, any idea: FirebaseError: Missing or insufficient permissions.

Collectives™ on Stack Overflow

Firestore query for same value in multiple fields

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related